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. 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. Any ideas/suggestions on how I can troubleshoot the hung process and why I am unable to optimize the tables? Thanks! Paul
--------------------------------------------------------------------- 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
