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.
Related posts:
How to make a slow motion video with Yi Action Camera
Top 10 Search Queries
Use GoAccess to Generate Report with Multiple Nginx Log Files
Schedule Backup MySQL database and FTP offsite in Centos
How to install Apache2 With PHP5 And MySQL On CentOS 6.3
Another MySQL daemon already running with the same unix socket
bc not found error when running Mysql tuning primer script
Thanks for the tutorial, however, this tutorial is full of typos.
After mkdir mysql, you should either cd to the directory, or in the next step, include the directory in the touch statement. Lastly, chmod should be chown, and these days, it’s good form to use the : instead of . between the username and group.
Thanks for the tutorial, however, this tutorial is full of typos.
After mkdir mysql, you should either cd to the directory, or in the next step, include the directory in the touch statement. Lastly, chmod should be chown, and these days, it’s good form to use the : instead of . between the username and group.
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
I think you mean chown instead of chmod