使用MySQL慢查日志日志有效率问题的SQL进行监控 show variables like ‘slow_query_log’;
确定是否开启 show variables like ‘%log%’; set global log_queries_not_using_indexes = on; s
how variables like ‘long_query_time’; set global slow_query_log=on; show variables like ‘slow%’;
//百分号的作用? set global slow-query_log_file = ‘/home……/mysql-slow.log’ 慢查日志的存储格式
