MySQL slow queries

Posted by jack on Stack Overflow See other posts from Stack Overflow or by jack
Published on 2010-03-20T06:58:16Z Indexed on 2010/03/20 7:01 UTC
Read the original article Hit count: 285

Filed under:
|
|

The MySQL slow query log often shows a bunch of following entries in sequence.

SET timestamp=1268999330;
commit;
# User@Host: username[username] @ localhost []
# Query_time: 4.172700  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1268999330;
commit;
# User@Host: username[username] @ localhost []
# Query_time: 3.628924  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1268999330;
commit;
# User@Host: username[username] @ localhost []
# Query_time: 3.116018  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
...

Usually 6-7 "commit" queries in sequence. Anyone what they are and what's the preceding query of each of them?

Thanks in advance.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about slow