MySQL slow query log

[erb5]

Is it possible to use the MySQL Server Log to log slow queries? I tried altering the my.cnf file (adding --log-slow-queries) but that did not seem to work.

Thanks.

[allyn]

you would put "log_slow_queries" in the /etc/my.cnf file.

and don't forget to restart your vps or restart mysqld ("/etc/rc.d/init.d/mysqld restart").

[erb5]

Thank you! I didn't know about the restarting! Am going to try first thing tomorrow...

[erb5]

Anyone know exactly where the slow query log would appear? I was assuming in the /var/lib/mysql directory, but after a day, nothing.

Wasn't sure if the query time (I set it to "1") was long enough that my queries weren't getting caught, but I tried setting it to 0 for a few hours and still am not seeing anything.

I've reset it it 1 for fear of creating a huge file (perhaps unfounded as my sites are LOW traffic) over the weekend.

Insight very much appreciated... feeling very foolish!

[wildjokerdesign]

Other logs are written to /var/log. Have you checked there?

[erb5]

I have and I'm not seeing it.

Any other ideas appreciated. I'm going to try putting the query time down to 0 and waiting 24 hours.