When I try to create an index on any table with greater than about 200,000
records, it hangs using show processlist shows the process to have died. I
have even tried moving the data out of the table, creating the index on the
empty table and moving the data back in again, but the process moving the
data back also dies.
Has anyone seen anything like this before ?
Thanks in anticipation
Scott Chamberlain
---------------------------------------------------------------------
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
