rendered paste bodymysql> 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)