Knowledgebase
Knowledgebase
Portal Home > Knowledgebase > Articles Database > MySQL slow query log
MySQL slow query log
Posted by kevinnivek, 02-14-2012, 01:05 PM Hello, I'm diagnosing a slow site via the mysql slow query log. I'm just curious how much actual extra overhead the slow query log may attach to a server. Is this something strictly recommended for diagnosis purposes? The client in question actually had it on 24x7 and I'm wondering if the process through which mysql has to record all slow queries that take longer than X seconds adds any significant amount of load to the system itself. Any insight would be appreciated, as I'm curious myself.
Posted by eva2000, 02-14-2012, 02:11 PM I usually only enable slow query logging for diagnostic purposes. But duration to run it can be for days if need be. How much extra load it adds depends on the system and how furious that logging gets. Still worth enabling if you need to find what's slowing mysql down though.
Posted by kevinnivek, 02-14-2012, 02:27 PM Logging is actually quite furious. I have turned it off in the meantime. This system has multiple bottlenecks so removing any potential causes might be best.
Add to Favourites 
Print this Article
Also Read
