Pada Mon, 4 Nov 2002 11:55:59 +0100
"Toni" <toni@stripped> menulis:
> I've got mysql 3.23.47 running on a freebsd 4.5 box for long time without
> problems, until now that consumes nearly all available CPU.
> Also, I am unable to stop the server using mysqladmin -u root shutdown (the
> process freezes) neither can restart it. If I kill -9 the process it
> restarts and keeps using all my resources.
> Aparently there isn't any other active process on the machine.
> I have checked at mysql.com but I couldn't find any related information.
> ¿Where could this problem come from?
> ¿Any solution?
Check the running queries .... show processlist ... or mysqladmin -p processlist ... or
even better use mytop / mtop
for some condition (high cpu usage), optimize your tables, or mysqlcheck -or -A -p
You should avoid kill -9 (safe_mysqld/mysql) ... it's only for "desperate" move ... :D
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286