Hello.
On Sat 2002-12-07 at 12:09:44 -0500, [EMAIL PROTECTED] wrote:
> I am running MySQL 3.23.46 under Linux kernel 2.2.20 as the back-end of
> an active website. On occasion mysql seems to stop responding. When I
> log into the server one of the MySQL processes is consuming a
> substantial amount of CPU resources (i.e. it is on the top of the list
> when viewing the “top” command.).
>
> Killing all of the mysql processes (using killall -9) and restarting
> seems to fix the problem.
Arg! Do NOT use killall -9 on your database, except if you are
prepared to screw it majorly or know about all the consequences. This
signal does not give MySQL the tiniest chance to do some cleanup.
Using -9 should only be your *very* last resort.
> After reading the list archives, I came upon the idea of repairing and
> optimizing the database using the command:
> ./mysqlcheck -or -A -u root –p
>
> But when I type that command, I receive the following message
>
> error : The handler for the table doesn't support check/repair
>
> for most of the tables in the database.
MySQL 3.23.46 supports check/repair only for tables of type MYISAM.
The error simply means that you are using different table types. Use
SHOW CREATE TABLE to determine the table type and then read in the
manual how to do maintenance for it.
> Any ideas/suggestions on how I can troubleshoot the hung process
The answers depend a lot on what/how you are using (e.g. did you
compile it yourself). You could start with presenting the full output
of mysqlbug.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
