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

2005-02-02 Thread Tom Crimmins
2005 2:56 PM > 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

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 garbl

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? &g

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 chang

Why does dropping indexes takes such a long time?

2005-02-02 Thread Homam S.A.
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? In MS SQL Server for example, dropping the index is almost instantaeous, unless it's clustered and you have other