LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Log slow queries mysql (https://www.linuxquestions.org/questions/linux-newbie-8/log-slow-queries-mysql-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 02:15 PM.