Troubleshoot MySQL high-load issues

http://dngood.blog.51cto.com/446195/1150031

1. Log_slow_queries =/usr/local/mysql/var/slow_queries.log #慢查询日志路径
2. Long_query_time = Ten #记录SQL查询超过10s的语句
3. log-queries-not-using-indexes = 1 #记录没有使用索引的sql

The reason is that because a table is too large, I use SELECT * from XXX where yyy=zzz order by time limit 1, when it becomes very slow, because so many historical data sorting fee time. Workaround, the table puts a corresponding up-to-date record.

Troubleshoot MySQL high-load issues