mysql> show table status; +--------------------+--------+---------+------------+----------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+--------------------------+ | 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 | +--------------------+--------+---------+------------+----------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+--------------------------+ | callme_count | MyISAM | 10 | Dynamic | 1198069 | 32 | 38347424 | 281474976710655 | 44996608 | 32 | 5472771 | 2008-07-31 01:01:54 | 2009-03-27 14:27:27 | 2009-02-10 09:55:02 | utf8_unicode_ci | NULL | | | | credit_extension | InnoDB | 10 | Compact | 529824 | 68 | 36241408 | 0 | 27885568 | 0 | 529537 | 2008-12-12 00:15:38 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 13042688 kB | | daily_ussd_users | MyISAM | 10 | Fixed | 61 | 13 | 793 | 3659174697238527 | 3072 | 0 | NULL | 2008-07-31 01:02:15 | 2008-07-31 01:02:15 | 2008-07-31 01:43:20 | utf8_unicode_ci | NULL | | | | menu_action | MyISAM | 10 | Dynamic | 10725 | 37 | 403420 | 281474976710655 | 489472 | 0 | 10726 | 2008-07-31 01:02:15 | 2009-03-27 14:27:35 | 2008-08-01 02:09:00 | utf8_unicode_ci | NULL | | | | monthly_ussd_users | InnoDB | 10 | Compact | 13 | 1260 | 16384 | 0 | 0 | 0 | NULL | 2008-08-01 02:24:00 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 13042688 kB | | msg | MyISAM | 10 | Dynamic | 41 | 35 | 1440 | 281474976710655 | 3072 | 0 | NULL | 2008-07-31 01:02:15 | 2008-07-31 01:02:15 | 2008-07-31 01:54:35 | utf8_general_ci | NULL | | | | prepaid9bonus | InnoDB | 10 | Compact | 16678 | 95 | 1589248 | 0 | 0 | 0 | NULL | 2009-03-03 11:08:47 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 13042688 kB | | prevb_count | MyISAM | 10 | Dynamic | 243424 | 54 | 13149268 | 281474976710655 | 13116416 | 0 | 688434 | 2008-07-31 01:02:15 | 2009-03-27 14:26:38 | 2008-08-01 02:21:01 | utf8_unicode_ci | NULL | | | | sms_user_action | MyISAM | 10 | Dynamic | 35417 | 87 | 21657752 | 281474976710655 | 21225472 | 18555216 | 611564 | 2008-07-31 01:02:17 | 2009-03-27 14:23:30 | 2008-08-01 02:20:05 | utf8_unicode_ci | NULL | | | | user_action | MyISAM | 10 | Dynamic | 13558593 | 82 | 1112456736 | 281474976710655 | 1026879488 | 481864 | 96537092 | 2008-07-31 01:02:25 | 2009-03-27 14:27:35 | 2009-01-20 13:48:44 | utf8_unicode_ci | NULL | | | +--------------------+--------+---------+------------+----------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+--------------------------+ 10 rows in set (0.00 sec)