New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Mysql abuse
WillGrehem
Member
in Help
Hello,
How to see which user abuse the mysql? My system load is always very low. But sometimes 1-2 user use all cores for mysql.
So my mysql use all cpu power. How to discover which database abuse the system?
Comments
show processlist;will show you the current queries.look for the one with wordpress or databases in the querry from "show processlist' that have a name that includes _wp. Chances are its a wordpress module gone rogue/overloading you. Unfortunately show processlist doesnt always show the right info instantly for you, thats why as a last resort scrutinize which are wordpress, then manually check those wordpress installs for strange stuff (hacked, or add-on modules that are highly inefficient,known to overload servers)