List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:November 9 2009 6:41am
Subject:DROP TABLE TOOK 39MIN
View as plain text  
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

Thread
DROP TABLE TOOK 39MINKrishna Chandra Prajapati9 Nov
  • Re: DROP TABLE TOOK 39MINJohan De Meersman9 Nov
    • Re: DROP TABLE TOOK 39MINMichael Dykman9 Nov
      • Re: DROP TABLE TOOK 39MINKrishna Chandra Prajapati9 Nov
        • RE: DROP TABLE TOOK 39MINDilip Kumar Parikh10 Nov
          • Re: DROP TABLE TOOK 39MINJohan De Meersman10 Nov