LinuxQuestions.org

LinuxQuestions.org (http://www.linuxquestions.org/questions/index.php)
-   Linux - Newbie (http://www.linuxquestions.org/questions/forumdisplay.php?f=8)
-   -   Log slow queries mysql (http://www.linuxquestions.org/questions/showthread.php?t=754122)

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
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


All times are GMT -5. The time now is 09:17 PM.