Ozz Posted December 7, 2005 Share Posted December 7, 2005 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. Link to comment https://forums.phpfreaks.com/topic/2997-help-how-to-find-mysql-query-log/ Share on other sites More sharing options...
Arenium Posted December 11, 2005 Share Posted December 11, 2005 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]. Link to comment https://forums.phpfreaks.com/topic/2997-help-how-to-find-mysql-query-log/#findComment-10129 Share on other sites More sharing options...
fenway Posted December 24, 2005 Share Posted December 24, 2005 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. Link to comment https://forums.phpfreaks.com/topic/2997-help-how-to-find-mysql-query-log/#findComment-10376 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.