Scott Chamberlain wrote:
>
> 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
Hi,
I have been adding and deleting indexes on a table with ~250,000 records
for benchmarking purposes lately and it worked fine.
However, maybe you are not waiting long enough to let it finish.
I am currently doing it with a 'key_buffer' parameter big enough to hold
all indexes in memory (128Mb in my case) and adding or deleting an index
takes around 2 minutes. When I did the same thing with a smaller key_buffer
(16 Mb), I killed mysqld after 1h30 and it had not finished adding a
new index !
Hope this helps
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
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
