Jump to content

Archived

This topic is now archived and is closed to further replies.

Ozz

Help: How to find MySQL query log?

Recommended Posts

I have huge load on my site because of mysql database queries.

I did necessary indexes and make some optimisations on data values. Now I'm tryin "EXPLAIN SELECT" query to find slow queries.

But if I get a query log with query times that will be a shortcut to find the problem.

Has mysql got a query log and where can I find it?

Do you recommend a tool or script to log mysql queries?

If I can see on the server that would be so helpful. But I can try on my windows localhost too.

Share this post


Link to post
Share on other sites
:) Apparently you're not the first person to have this dilemma: [a href=\"http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html\" target=\"_blank\"]See here[/a].

Share this post


Link to post
Share on other sites

You can definitely turn on general query logging; however, I recommend using the [a href=\"http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html\" target=\"_blank\"]slow query log[/a] instead -- it narrows down the log quite a bit, and makes it much easier to find the offending queries.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.