MySQL inspect table sizes

Discovered a database was stupid big? Need a quick break down of where all the junk is? Here’s a quick mysql example to help:

select TABLE_NAME,TABLE_ROWS,DATA_LENGTH,AVG_ROW_LENGTH FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'wp_cdobs';
+-----------------------+------------+-------------+----------------+
| TABLE_NAME            | TABLE_ROWS | DATA_LENGTH | AVG_ROW_LENGTH |
+-----------------------+------------+-------------+----------------+
| pt_called_function    |      22428 |     2637824 |            117 |
| pt_file               |          1 |       16384 |          16384 |
| pt_function           |      25295 |     3686400 |            145 |
| wp_commentmeta        |     127659 |   137674752 |           1078 |
| wp_comments           |      35662 |   106528768 |           2987 |
| wp_links              |         24 |     2179072 |          90794 |
| wp_options            |        721 |     7880704 |          10930 |
| wp_postmeta           |     965198 |   112885760 |            116 |
| wp_posts              |     159491 |   444596224 |           2787 |
| wp_term_relationships |     232723 |    13156352 |             56 |
| wp_term_taxonomy      |        753 |       81920 |            108 |
| wp_terms              |        791 |       81920 |            103 |
| wp_usermeta           |      21783 |     1589248 |             72 |
| wp_users              |       2237 |      475136 |            212 |
| wp_w3tc_cdn_queue     |          0 |           0 |              0 |
+-----------------------+------------+-------------+----------------+