I use below command to drop a column activetime from my table. While this command never end. I waited for 5 mins while there is only 100 records in MY_TABLENAME
ALTER TABLE MY_TABLENAME DROP COLUMN activetime
;
The column activetime is defined as below:
| activetime | bigint(20) | NO | | NULL | |