To enable slow query log, it is have to add one line into my.cnf.
I have MySQL installation on a Centos server.
It is MySQL 5.0.22 i686.
Let's go through the details of setting of it.
Open my.cnf which is located at /etc/
add following under mysqld section.
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 5
log-queries-not-using-indexes
The key point is to manually create the mysql-slow.log file.
cd /var/log
mkdir mysql
touch mysql-slow.log
chmod mysql.mysql -R /var/log/mysql
Last step is to restart mysql server.
After minutes, I saw some records in this log file.
The next question is how to analyse the slow queries log and optimize the program of MySQL.
I think you mean chown instead of chmod
Hello,
Great post, but i think that the "chmod mysql.mysql -R /var/log/mysql" should be: "chown mysql.mysql -R /var/log/mysql"
Happy debuging