Log Slow Queries in MySQL

Posted by cikul | Posted in Linux | Posted on 01-06-2008-05-2008

0

logged slow queries by MySQL Server and you can optimize them.

# touch /var/log/slow-queries.log
# chmod 644 /var/log/slow-queries.log


Edit your /etc/my.cnf and under [mysqld] add following lines.

[mysqld]

log-slow-queries = /var/log/slow-queries.log

# /scripts/restartsrv_mysql

Write a comment

*