MySQL Slow Query Log 설정

/etc/my.cnf

[mysqld]

# slow queries log file
log-slow-queries=/var/log/mysqlslow.log

# check sec : 1sec
long_query_time=1

service mysql restart

====================================

>> mysql 5.6 이상

slow_query_log                  = 1
slow_query_log_file             = /var/log/mysql/slow.log
long_query_time                 = 5