Log slow queries mysql

a4kata · 09-10-2009, 06:02 AM

Hello, I would like to log slow queries in mysql I found the script for that

Code:

log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1

But in my /var/log directory I haven't got folder named mysql or file named mysql-slow.log If I want to use this script will I have to create /mysql/mysql-slow.log in var/log directory ?

PMP · 09-10-2009, 07:14 AM

This is not a script. these are configuration settings that you need to keep in your configuration files, OR you can start mysql with these options.

Check out this link
http://dev.mysql.com/doc/refman/5.1/...query-log.html