Can't drop index !

2 posts
[expired user #10825]'s profile image [expired user #10825] posted 7 years ago in General Permalink

Hello,

firstly congrats for the great software.

Now with the problem: I have a table with 2 indexes and I am trying to drop the second index (non-primary).

But, when I try to do that, the cursor waits indefinitely and it looks like HeidiSql is stuck :-(

At first I thought it is taking a lot of time because it is a big table (it has 2 text fields and 100+ million records) , but it takes hours and won't complete !

Any ideas ? Do you think the table is too big to handle ? It is around 14 GB.

2 posts
[expired user #10825]'s profile image [expired user #10825] posted 7 years ago Permalink

Noone ?

Please login to leave a reply, or register at first.