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