/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


안정적인 DNS서비스 DNSEver DNS server, DNS service
Posted by 키르히

댓글을 달아 주세요