vim /etc/my.cnf

[mysqld]

slow-query-log = on # 開(kāi)啟慢查詢(xún)功能
slow_query_log_file = /usr/local/mysql/data/slow-query.log # 慢查詢(xún)?nèi)罩敬娣怕窂脚c名稱(chēng)
long_query_time = 5 # 查詢(xún)時(shí)間超過(guò)5s的查詢(xún)語(yǔ)句
### log-queries-not-using-indexes = on # 列出沒(méi)有使用索引的查詢(xún)語(yǔ)句