MySQL Forums
Forum List  »  Quality Assurance

some SQL are not caught in the query-slow.log
Posted by: tiger zhang
Date: February 28, 2013 09:34PM

when I turn on the slow_query_log_file ,and found lots of SQL is not caught in the file , as followed:
I want to know : how can I find the missed SQL( there is only commit).

the server version: mysql Ver 14.14 Distrib 5.1.32, for unknown-linux-gnu (x86_64) using readline 5.1
main parameters: binlog_format=mixed


thanks!

# Time: 130301 6:51:58
# User@Host: dingzhic[dingzhic] @ [192.168.1.106]
# Query_time: 1.768163 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1362091918;
commit;
# User@Host: dingzhic[dingzhic] @ [127.0.0.1]
# Query_time: 1.545211 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 0
SET timestamp=1362091918;
CALL loginUpdate2(582272,null,'192.168.1.125',0,'','',1);
# Time: 130301 6:54:37
# User@Host: dingzhic[dingzhic] @ [192.168.1.106]
# Query_time: 1.137814 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1362092077;
commit;

Options: ReplyQuote


Subject
Views
Written By
Posted
some SQL are not caught in the query-slow.log
2556
February 28, 2013 09:34PM


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.