http://blog.csdn.net/xfcy1990/article/details/51957557
開啟方法有兩種:
1,修改配置文件(需重啟mysqld服務(wù)):
[root@localhost app]# cat /etc/my.cnf
[mysqld]? ??
#開啟慢查詢?nèi)罩居涗??
slow_query_log=1??
#查詢時(shí)間超過0.1秒的sql語句會(huì)被記錄??
long_query_time=0.1??
#記錄沒有使用索引的查詢??
log_queries_not_using_indexes=1??
#記錄慢查詢?nèi)罩镜奈募刂??
slow-query-log-file=/var/lib/mysql/localhost-slow.log??
注意：先創(chuàng)建文件 并賦予mysql用戶權(quán)限?
touch /var/lib/mysql/localhost-slow.log??
chown mysql:mysql?/var/lib/mysql/localhost-slow.log
2,在mysql控制臺修改,無需重啟mysqld服務(wù)
#開啟慢查詢?nèi)罩居涗?/p>
mysql> set global slow_query_log=on;
Query OK, 0 rows affected (0.00 sec)
#查詢時(shí)間超過0.1秒的sql語句會(huì)被記錄
mysql> set global long_query_time=0.1;
Query OK, 0 rows affected (0.03 sec)
#記錄慢查詢?nèi)罩镜奈募刂?/p>
mysql> set global slow_query_log_file="/var/lib/mysql/localhost-slow.log";
Query OK, 0 rows affected (0.04 sec)
#記錄沒有使用索引的查詢
mysql> set global log_queries_not_using_indexes=on;
Query OK, 0 rows affected (0.00 sec)
注意：先創(chuàng)建文件 并賦予mysql用戶權(quán)限?
touch?/var/lib/mysql/localhost-slow.log
chown mysql:mysql?/var/lib/mysql/localhost-slow.log
運(yùn)維QQ交流群：171586999
