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

Reply via email to