Hello all, What does it mean to be in the "Repair with keycache" state, and how do I fix this?
I am running MySQL v3.23.36 on a Red Hat 7.1 machine. One of my tables has about 21,000,000 (21 Million) records in it. I am trying to index one of the fields with the alter table command: mysql> alter table foo add index (bar); bar is an unsigned integer. Unfortunately, the indexing never completes. So I ran a mysqladmin command: # mysqladmin processlist --------+------+----------------------+---------------------------------+ Command | Time | State | Info | --------+------+----------------------+---------------------------------+ Query | 3753 | Repair with keycache | alter table foo add index (bar) | --------+------+----------------------+---------------------------------+ What does "Repair with keycache" mean? Where can I find more information about this? What other information would I need to diagnose and fix this problem? I've searched the documentation and the archives, but nothing shows with "replair with keycache." One course I have tried is to change these variables: key_buffer_size=256M sort_buffer=16M record_buffer=4M but I still get this error. Regards, - Robert --------------------------------------------------------------------- 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
