-   Linux - Newbie (
-   -   Log slow queries mysql (

a4kata 09-10-2009 06:02 AM

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

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

All times are GMT -5. The time now is 12:30 PM.