Where can I find the mysql slow log?

Question

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

Answer 1

In MySQL : show global variables like '%slow%';

Update : here's a link to the manual: link text

Answer 2

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

Answer 3

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.

Answer 4

Here is something to consider as well :

If you use the option

log-output=TABLE

in you /etc/my.cnf file, look for the slow log to be a CSV storage engine based table located in, of all places, the mysql schema.

This affects the general log as well, once you enable it.

Answer 5

Search your mysqld config file (usually, /etc/my.cnf)

At your shell:

grep slow /etc/my.cnf