MySQL Forums
Forum List  »  General

slow log - COMMIT;
Posted by: jongse park
Date: January 12, 2015 09:43PM

Hi,

I use mysqldumpslow to analyze for slow log.
This is output;
-----------------
....

# Time: 150112 14:16:15
# User@Host: push[push] @ [20.20.20.11]
# Thread_id: 3851032 Schema: db_queue QC_hit: No
# Query_time: 6.726409 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1421039775;
COMMIT;
# User@Host: push[push] @ [20.20.20.11]
# Thread_id: 3851018 Schema: db_queue QC_hit: No
# Query_time: 6.766168 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1421039775;
COMMIT;
# User@Host: push[push] @ [20.20.20.11]
# Thread_id: 3851017 Schema: db_queue QC_hit: No
# Query_time: 6.657709 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1421039775;
COMMIT;
# User@Host: push[push] @ [20.20.20.11]
# Thread_id: 3851028 Schema: d b_queue QC_hit: No
# Query_time: 6.767998 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1421039775;
COMMIT;
# User@Host: push[push] @ [20.20.20.11]
# Thread_id: 3851029 Schema: db_queue QC_hit: No
# Query_time: 6.692594 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1421039775;
COMMIT;
...
---------------------
Which case does it display in a logs ?
there is a just "COMMIT;" statement in output log.
what does it mean COMMIT; in this case?

Options: ReplyQuote


Subject
Written By
Posted
slow log - COMMIT;
January 12, 2015 09:43PM
January 12, 2015 11:46PM
January 13, 2015 07:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.