Re: Why does dropping indexes takes such a long time?

2005-02-02 Thread Keith Ivey
Homam S.A. wrote: I have a non-primary-key index on a large MyISAM table, and dropping the index takes a long time, in addition to maxing out the CPU utilization in its final 1/3 interval. Why is that? You asked the question last week, and several people answered. Do you think the answer has

RE: Why does dropping indexes takes such a long time?

2005-02-02 Thread Dathan Pattishall
DVP Dathan Vance Pattishall http://www.friendster.com -Original Message- From: Homam S.A. [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 11:50 AM To: mysql@lists.mysql.com Subject: Why does dropping indexes takes such a long time? I have a

Re: Why does dropping indexes takes such a long time?

2005-02-02 Thread Homam S.A.
This is the reply I got when I posted the same message last week. I checked the list for hours and my message didn't show up. This is why I assumed it never made it. I have no idea what this auto-reply is saying. I tried the AltaVista bablefish with Spanish. It was the closest, but it gave me

RE: Why does dropping indexes takes such a long time?

2005-02-02 Thread Tom Crimmins
To: Keith Ivey; mysql@lists.mysql.com Cc: Homam S.A. Subject: Re: Why does dropping indexes takes such a long time? This is the reply I got when I posted the same message last week. I checked the list for hours and my message didn't show up. This is why I assumed it never made it. I have