ERROR AND high loading of my mysql!

[clbbhk]

When i trying to stop the mysql in the directadmin!
then , i showed that
An error has occurred
Details
but i can stop it by SSH..

Also ...the mysql always make my server to the high loading...
it is about i upgreat to the mysql 4.1.15?


Apache 1.3.34 Running
DirectAdmin 1.25.4 Running
Exim 4.50 Running
MySQL 4.1.15 Running
Named 9.2.4 Running
ProFTPd 1.2.10 Running
sshd Running
vm-Pop3d 1.1.7f-DA-2 Running

 

[nobaloney]

MySQL may not stop well from the DA control panel, or even by using:

service mysqld stop

from the shell, because it has to close down each connection before it can shut down mysql itself, to avoid corrupting the databases.

When that happens the best thing to do is to stop it from the shell and to run the command over and over again (as root) until its fully stopped.

Though you may be tempted to try the service -9 option, I highly recommend you don't; it will result in corrupted databases.

There are posts on these forums for how to optimize MySQL; you might want to look for them.

Jeff