DROP TABLE TOOK 39MIN

[Krishna Chandra Prajapati]

Hi Experts,

I have a crm(customer resource management) table which contains 654 million
records. Dropping table took 39min. In addition to this other queries become
very slow and they are not associated with bkp_mtlog any way. why?

mysql> show table status like 'bkp_mtlog';
+-----------+--------+---------+------------+-----------+----------------+--------------+-----------------+--------------+-------------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
| Name      | Engine | Version | Row_format | Rows      | Avg_row_length |
Data_length  | Max_data_length | Index_length | Data_free   | Auto_increment
| Create_time | Update_time | Check_time | Collation         | Checksum |
Create_options | Comment |
+-----------+--------+---------+------------+-----------+----------------+--------------+-----------------+--------------+-------------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
| bkp_mtlog | InnoDB |      10 | Compact    | 654135647 |            289 |
189507928064 |               0 | 549887164416 | 58322845696 |           NULL
| NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |
partitioned    |         |
+-----------+--------+---------+------------+-----------+----------------+--------------+-----------------+--------------+-------------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
1 row in set (2 min 11.29 sec)

mysql> drop table bkp_mtlog;
Query OK, 0 rows affected (39 min 7.39 sec)

Thanks,
Krishna