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