Just as the title says, where can I see it ?
Are there any config options for it ( like how many ms would determine if a query is slow or not ) ?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
You can find it in the default directory, depending on your install. For instance, on my Red Hat, it's /var/log/mysql/
Query time is time, in seconds, over which it should start recording. This can be done at startup and at runtime.
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
In MySQL :
show global variables like '%slow%';
Update : here's a link to the manual: link text
These are the pertinent options (and settings) I generally have/use in all my
my.cnfs to log slow queries:
log_output=FILE slow_query_log=1 slow_query_log_file=/var/log/mysql/mysql.slow long_query_time=0.001 log-queries-not-using-indexes=0
Note that for long_query_time,
Beginning with MySQL 5.1.21 ... a resolution of microseconds is supported when logging to a file.