I attempted to optimize a table last night, which usually takes about 5 minutes but I expected to take longer as I had done a slew of deletes.
Well, it took over an hour, and from the last modified dates on the table and temp files, it looked like they hadnt been updated in 10-15 minutes. Eventually I gave up and disconnected, as I was on a laptop and had to disconnect from ssh. Today I found the tables corrupted, and am attempting a repair table, but I am in the same situation - the command is still running after 20 minutes and the table files have not been modified for a while (th eindex file's modified date is being updated but the filesize has not changed). mysqld is at 85% CPU in top. How can you tell when mysql is just taking a lot of time or has croaked/frozen/is stuck in a bad loop????? --------------------------------------------------------------------- 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
