Pada Mon, 4 Nov 2002 11:55:59 +0100 "Toni" <[EMAIL PROTECTED]> menulis:
> Hello > > 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 Web: http://www.1rstwap.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
