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 |
+-----------------------+------------+-------------+----------------+

WordPress freemiums getting a little out of control

I’ve spent the last two 2 – 1/2 years working for WP Engine and Pantheon, both managed hosting solutions for WordPress. And it’s been nearly that long since I’ve actually built a site using it.

Weird I know. But I generally just do straight PHP these days and lately I’ve been playing around with Drupal some. 

This weekend I taught a short workshop in Petaluma about building sites with WordPress. Needless to say, I spent time last week building a couple of different test sites and experimenting with some newer plugins I had not used before.

Biggest takeaway? The whole “freemium” plugin marketing explosian might be getting a little out of hand. I totally get why people do it ( heck I did it for a while ),  but it’s an awful user experience to have every single plugin you install try to sell you an upgrade. 

If WordPress is going to continue to allow freemium marketing in their repository I think there should be some agreed about conventions about where those ads should be. For instance, a ‘nag’ on the settings page is ok, but on every admin page not much.

Is it me ?