Initial: Due to the high CPU consumption of the newly installed server, the response is not timely troubleshooting, because the environment based on the most basic lamp architecture
Think of turning on MYSQL slow_query_log slow query log for reasons analysis;
But after seeing the log content is a bit dazed "I clearly set slower than 2 seconds to record slow query" but the content is as follows:
A lot of log query_time actually only a few milliseconds. This causes too much file content to be analyzed with ease
Later found: Http://dba.stackexchange.com/questions/21308/mysqls-slow-query-log-strange-query-time
It turns out that because:
Shield the log_queries_not_using_indexes; restart MySQL;
echo >/data/logs/mysql-slow.log
All slow queries re-recorded;
And then you can safely analyze the
Doubts about MySQL slow query slow the content of query log records