mysql配置慢查询日志/etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

#Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

#开启慢查询日志记录
slow_query_log=1

#查询时间超过1秒的sql语句会被记录
long_query_time=0.9

#记录没有使用索引的查询
log_queries_not_using_indexes=0

#记录慢查询日志的文件地址
slow-query-log-file=/data/slowQueryLog/slowQuery.log

query_cache_size = 120M
query_cache_type = ON

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid