28M, or even 256M and see what happens. I hope this
helps.
- Original Message -
From: bowen <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Tuesday, October 10, 2006 9:33:36 PM GMT-0500 US/Eastern
Subject: Re: Why does mysql drop index very very slow in a large table?
>
> 1)
1) create table T1 like T;
This creates an empty table T1 with indexes ndx1,ndx2,ndx3 and ndx4.
2) alter table T1 drop index ndx3;
This drops index ndx3 on the empty T1, which should be instantaneous.
3) insert into T1 select * from T;
This will populate table T and load all three(3) indexes for
.
Just make sure that empty table T1 has all the indexes you want before loading.
Please Try This Method and let me know how it worked for you.
Thank You for reading this whole thing
- Original Message -
From: Chris Wagner (GE Infra, Non-GE, US) <[EMAIL PROTECTED]>
To: bowen <[EMAIL
A workaround is to use mysqlhotcopy to snapshot the table and also only copy
the header to the MYI file. Then delete the original and rename the copy back
to the original. This will effectively drop all indexes and should take no
more time than what the disk takes to copy the .my* files.
-
Why does mysql drop index very very slow in a large table?
I have a large table with more than 5M rows, and many indexes. Now I
want to drop some of them. But it seems that mysql can not handle this
very well. It takes a very long time (more than half an hour) to do ,
and make me unbearable
