http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
Repair with keycache - The repair code is using creating keys one by one through the key cache. This is much slower than Repair by sorting. It is going to take a long time to build an index on a table that big, especially if you still have questions coming into the machine. -----Original Message----- From: Robert Citek [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 12:33 PM To: MySQL Subject: repair with keycache 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 --------------------------------------------------------------------- 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
