There is a database online, and there are a lot of records similar to the following in slow log:
Copy codeThe Code is as follows:
# Time: 130823 13:56:08
# User @ Host: repl [repl] @ slave [10. x]
# Query_time: 9.000833 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 1
SET timestamp = 1377237368;
# Administrator command: Binlog Dump;
Every time binlog dump is completed, it will be recorded, and it looks very uncomfortable (I have obsessive-compulsive disorder, O (strong _ strong) O Haha ~), You have to figure it out.
After investigation, it was finally confirmed that this phenomenon exists in a specific version. Currently, it is found that the official version 5.1.49 exists. It is estimated that this phenomenon will occur throughout the official version 5.1.x.
Solution:
Modify the my. cnf configuration file and add or modify the following options:
Copy codeThe Code is as follows:
Log-slow-admin-statements = 0
If this option cannot be modified online in MySQL 5.1, restart mysqld.
The manual explains this option as follows:
Copy codeThe Code is as follows:
Include slow administrative statements in the statements written to the slow query log. Administrative statements include alter table, analyze table, check table, create index, drop index, optimize table, and repair table.
When the manual is unreliable, it is still a matter of practice.