4 days to drop Index

Dear all,

Things becomes too lazy when it takes too much time.

I am suffering from this problem when droping index of size 17.7 GB on a
table of size 24.7 GB.
This table have some more indexes of different sizes.
It takes near about 4 days to drop the index.

Can anyone Please guide me whether it is fine in MySQL or things needed
to work on.


Thanks & Regards

Adarsh Sharma

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: 4 days to drop Index

--20cf30434300ab6901049822ef84
Content-Type: text/plain; charset=UTF-8

Hi.
I think you should upgrade your hardware and adjust your mysqld's
parameters. Then your job will be fine.

David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao0608@gmail.com



2010/12/23 Adarsh Sharma

> Dear all,
>
> Things becomes too lazy when it takes too much time.
>
> I am suffering from this problem when droping index of size 17.7 GB on a
> table of size 24.7 GB.
> This table have some more indexes of different sizes.
> It takes near about 4 days to drop the index.
>
> Can anyone Please guide me whether it is fine in MySQL or things needed to
> work on.
>
>
> Thanks & Regards
>
> Adarsh Sharma
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=yueliangdao0608@gmail.com
>
>

--20cf30434300ab6901049822ef84--

RE: 4 days to drop Index

VGhlIGZpcnN0IHRoaW5nIHRvIGNoZWNrIGlzIGVpdGhlciB0aGF0IHlvdXIg a2V5X2J1ZmZlcl9T
aXplIGlzIHRvbyBzbWFsbCAoaWYgaXQncyBhIG15aXNhbSB0YWJsZSkgb3Ig eW91ciBpbm5vZGJf
YnVmZmVyX3Bvb2xfc2l6ZSBpcyB0b28gc21hbGwgKGlmIGl0J3MgYSBpbm5v ZGIgdGFibGUpLg0K
DQpBZnRlciB0aGF0LCBtb3N0IG9mIHRoZSB0aW1lIGZvciBhbHRlciB0YWJs ZSBkZXBlbmRzIG9u
IGRpc2sgSU8uICBPbiBkZWNlbnQgaGFyZHdhcmUgYSByYXRlIG9mIDRHL2hy IGlzIGNvbW1vbiwg
c28gYXJvdW5kIDYgaG91cnMgaXMgbXVjaCBtb3JlIHJlYXNvbmFibGUgZm9y IHlvdXIgb3BlcmF0
aW9uLg0KDQpSZWdhcmRzLA0KR2F2aW4gVG93ZXkNCg0KDQotLS0tLU9yaWdp bmFsIE1lc3NhZ2Ut
LS0tLQ0KRnJvbTogeXVlbGlhbmdkYW8wNjA4QGdtYWlsLmNvbSBbbWFpbHRv Onl1ZWxpYW5nZGFv
MDYwOEBnbWFpbC5jb21dIE9uIEJlaGFsZiBPZiA/Pz8NClNlbnQ6IFRodXJz ZGF5LCBEZWNlbWJl
ciAyMywgMjAxMCAxMToyOSBQTQ0KVG86IEFkYXJzaCBTaGFybWENCkNjOiBt eXNxbEBsaXN0cy5t
eXNxbC5jb20NClN1YmplY3Q6IFJlOiA0IGRheXMgdG8gZHJvcCBJbmRleA0K DQpIaS4NCiAgIEkg
dGhpbmsgeW91IHNob3VsZCB1cGdyYWRlIHlvdXIgaGFyZHdhcmUgYW5kIGFk anVzdCB5b3VyIG15
c3FsZCdzDQpwYXJhbWV0ZXJzLiBUaGVuIHlvdXIgam9iIHdpbGwgYmUgZmlu ZS4NCg0KRGF2aWQg
WWV1bmcsIEluIENoaW5hLCBCZWlqaW5nLg0KTXkgRmlyc3QgQmxvZzpodHRw Oi8veXVlbGlhbmdk
YW8wNjA4LmN1YmxvZy5jbg0KTXkgU2Vjb25kIEJsb2c6aHR0cDovL3l1ZWxp YW5nZGFvMDYwOC5i
bG9nLjUxY3RvLmNvbQ0KTXkgTXNuOiB5dWVsaWFuZ2RhbzA2MDhAZ21haWwu Y29tDQoNCg0KDQoy
MDEwLzEyLzIzIEFkYXJzaCBTaGFybWEgPGFkYXJzaC5zaGFybWFAb3JrYXNo LmNvbT4NCg0KPiBE
ZWFyIGFsbCwNCj4NCj4gVGhpbmdzIGJlY29tZXMgdG9vIGxhenkgd2hlbiBp dCB0YWtlcyB0b28g
bXVjaCB0aW1lLg0KPg0KPiBJIGFtIHN1ZmZlcmluZyBmcm9tIHRoaXMgcHJv YmxlbSB3aGVuIGRy
b3BpbmcgaW5kZXggb2Ygc2l6ZSAxNy43IEdCIG9uIGENCj4gdGFibGUgb2Yg c2l6ZSAyNC43IEdC
Lg0KPiBUaGlzIHRhYmxlIGhhdmUgc29tZSBtb3JlIGluZGV4ZXMgb2YgZGlm ZmVyZW50IHNpemVz
Lg0KPiBJdCB0YWtlcyBuZWFyIGFib3V0IDQgZGF5cyB0byBkcm9wIHRoZSBp bmRleC4NCj4NCj4g
Q2FuIGFueW9uZSBQbGVhc2UgZ3VpZGUgbWUgd2hldGhlciBpdCBpcyBmaW5l IGluIE15U1FMIG9y
IHRoaW5ncyBuZWVkZWQgdG8NCj4gd29yayBvbi4NCj4NCj4NCj4gVGhhbmtz ICYgUmVnYXJkcw0K
Pg0KPiBBZGFyc2ggU2hhcm1hDQo+DQo+IC0tDQo+IE15U1FMIEdlbmVyYWwg TWFpbGluZyBMaXN0
DQo+IEZvciBsaXN0IGFyY2hpdmVzOiBodHRwOi8vbGlzdHMubXlzcWwuY29t L215c3FsDQo+IFRv
IHVuc3Vic2NyaWJlOg0KPiBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3Fs P3Vuc3ViPXl1ZWxp
YW5nZGFvMDYwOEBnbWFpbC5jb20NCj4NCj4NCg0KSU1QT1JUQU5UOiBUaGlz IGVtYWlsIG1lc3Nh
Z2UgaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIHVzZSBvZiB0aGUgaW5kaXZp ZHVhbCB0byB3aG9t
LCBvciBlbnRpdHkgdG8gd2hpY2gsIGl0IGlzIGFkZHJlc3NlZCBhbmQgbWF5 IGNvbnRhaW4gaW5m
b3JtYXRpb24gdGhhdCBpcyBwcml2aWxlZ2VkLCBjb25maWRlbnRpYWwgYW5k IGV4ZW1wdCBmcm9t
IGRpc2Nsb3N1cmUgdW5kZXIgYXBwbGljYWJsZSBsYXcuIElmIHlvdSBhcmUg Tk9UIHRoZSBpbnRl
bmRlZCByZWNpcGllbnQsIHlvdSBhcmUgaGVyZWJ5IG5vdGlmaWVkIHRoYXQg YW55IHVzZSwgZGlz
c2VtaW5hdGlvbiwgZGlzdHJpYnV0aW9uIG9yIGNvcHlpbmcgb2YgdGhpcyBj b21tdW5pY2F0aW9u
IGlzIHN0cmljdGx5IHByb2hpYml0ZWQuICBJZiB5b3UgaGF2ZSByZWNlaXZl ZCB0aGlzIGNvbW11
bmljYXRpb24gaW4gZXJyb3IsIHBsZWFzZSByZXBseSB0byB0aGUgc2VuZGVy IGltbWVkaWF0ZWx5
IGFuZCBwZXJtYW5lbnRseSBkZWxldGUgdGhpcyBlbWFpbC4gVGhhbmsgeW91 Lg0K