Linux Hosting Optimization - Slow Query Log for Mysql
One of the difficulties found in running a shared hosting environment, or even a dedicated hosting area, is finding out who is using resources and why. Apache running Suexec or some variant thereof can let you know who owns the scripts that are pounding the box. MySQL process are a bit more difficult to analyze. MyTop is definitely an essential tool for seeing who is pounding it RIGHT NOW, but isn’t as accurate or at least helpful in finding routine abusers. Luckily MySQL provides for the logging of slow queries. This is their story.
[Read more →]
