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 | +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------------------------------+-----------------------+ | archive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | category | InnoDB | 10 | Compact | 683 | 71 | 49152 | 0 | 32768 | 0 | 1137 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | categorylinks | InnoDB | 10 | Compact | 4297 | 76 | 327680 | 0 | 442368 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | externallinks | InnoDB | 10 | Compact | 331 | 346 | 114688 | 0 | 196608 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | filearchive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 0 | 1 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | hitcounter | MEMORY | 10 | Fixed | 0 | 8 | 0 | 200000 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=25000 | | | image | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | imagelinks | InnoDB | 10 | Compact | 421 | 194 | 81920 | 0 | 49152 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | interwiki | InnoDB | 10 | Compact | 102 | 160 | 16384 | 0 | 0 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | ipblocks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 81920 | 0 | 1 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | job | InnoDB | 10 | Compact | 141 | 348 | 49152 | 0 | 16384 | 0 | 818 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | langlinks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | logging | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 0 | 1 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | math | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | objectcache | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | oldimage | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | page | InnoDB | 10 | Compact | 2848 | 120 | 344064 | 0 | 376832 | 0 | 3002 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | page_props | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | page_restrictions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 0 | 1 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | pagelinks | InnoDB | 10 | Compact | 17965 | 145 | 2605056 | 0 | 1556480 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | protected_titles | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | querycache | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | querycache_info | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | querycachetwo | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | recentchanges | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 114688 | 0 | 2 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | redirect | InnoDB | 10 | Compact | 12 | 1365 | 16384 | 0 | 16384 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | revision | InnoDB | 10 | Compact | 3083 | 127 | 393216 | 0 | 720896 | 0 | 3009 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | max_rows=10000000 avg_row_length=1024 | InnoDB free: 11264 kB | | searchindex | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2008-09-16 16:10:45 | 2008-09-16 16:10:45 | NULL | utf8_general_ci | NULL | | | | site_stats | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | templatelinks | InnoDB | 10 | Compact | 5275 | 46 | 245760 | 0 | 196608 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | text | InnoDB | 10 | Compact | 28110 | 4010 | 112738304 | 0 | 0 | 0 | 2985 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | max_rows=10000000 avg_row_length=10240 | InnoDB free: 11264 kB | | trackbacks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | transcache | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | updatelog | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | user | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 32768 | 0 | 2 | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | user_groups | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 16384 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | user_newtalk | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | | watchlist | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2008-09-16 16:10:45 | NULL | NULL | binary | NULL | | InnoDB free: 11264 kB | +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------------------------------+-----------------------+ 38 rows in set (0.03 sec)