Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Mysql abuse
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.

Mysql abuse

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.

    Thanked by 1WillGrehem
  • turnkeyintenetturnkeyintenet Member, Host Rep

    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)

    Thanked by 1WillGrehem
Sign In or Register to comment.