Hi

I have a mysql database with a table which has grown huge. The data
itself take up around 6GB and the indexes around 14GB. So I decided to
remove some of the indexes because I'm running low on space. But the
"ALTER TABLE xxx DROP INDEX zzz" result in a "copy data to tmp table"
which takes up a lot of space too - which is pretty uncool when space is
what you miss!

Does anyone know a way to solve the problem - remove indexes without
getting this "copy to tmp table" before the removal of the index?


Thanks

Ask