Web Hosting Talk







View Full Version : HELP! Mysql spiking to 100%


titoboo
11-14-2002, 09:32 AM
For the last few hours I've noticed that some mysql processes have been running for 10+ mins and keep spiking to 60-100% cpu usage every few seconds.

Normally (for the last few months of monitoring the server) mysql processes normall use less than 1% cpu and only rarely spiked to 15%.

All of a sudden every 3-4 sec one or 2 mysql processes are spiking up to 100% cpu usage .. any ideas what could be going on?

apollo
11-14-2002, 04:45 PM
check if there is a problem with some scripts that use mysql database..... check out if mysql partition is not full either..

clockwork
11-14-2002, 09:24 PM
mysqladmin status
mysqladmin processlist