All, I have around 60 web sites on a server and maybe a dozen of them use MySQL for various functions, and the control panel software (Plesk 7.5 Reloaded) is also MySQL driven. Recently, the MySQL processes have been consuming an increasing amount of CPU on this server. I have a reasonable idea of which site it is, becuase the increase started around the time one customer took his site live on this server. However, I want to *know* which site is is that is beating up on MySQL. Anyone got a handy/clever way to figure out which site is hitting MySQL ?
This server is not in iowait at all(couple percent max). Surprisingly, it's all user and system time being used by the MySQL process.. not much I/O. So, I am upgrading the CPU from a Celeron 2.4GHz to a P4 2.8GHz, which may help some. It's an older machine still on Socket 478, and heat is always a concern. I think this is best, safest CPU for this system. I want to know which site, for sure, so that I tell the right customer to get a dedicated server, when it's time. Thoughts ? Mike -- ************************************************************ Michael J. McCafferty Principal, Security Engineer M5 Hosting 858-576-7325 Voice http://www.m5hosting.com ************************************************************ -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
