Hi Server Loads (mySql

[sbrad]

I've been getting really high server loads with mySql, using 90+% of the CPU. How do I find out which user is doing this?

 

[feanor]

mysqladmin -p processlist

(will show you current processes, and threads that are hanging in memory and more than likely abusing your sql server's resources)

You'll need the mysql root pass here of course.

 

[sbrad]

Suweeeeeeeeeeeeet.

Thanks

 

[DHL]

How do you then kill that process? Just restart?

Newbie

Steve

 

[Daniel]

Logged in as root you can also type mysql then at the mysql prompt type show processlist;

You will get the same output but without having to put in the root pass each time.

 

[Juanra]

There's also an option in WHM, under the Mysql group, &Show MySQL processes&.

 

[big]

what about if both processlist via mysqladmin and by mysql says all connection in use , what to do? this happened to me several times.