mysql> SHOW TABLE STATUS; — It looks horrible!

TL;DR; – the results of MySQL’s SHOW TABLE STATUS is pretty horrible on a small terminal window, and most of the time shows way more than you’ll ever want to know for a quick summary.

Ivan Cachicatari over at http://en.latindevelopers.com/ivancp/2012/a-better-show-table-status/ came up with a stored procedure which nicely cuts it down to just the information that’s useful about a database, but I decided that most of the time it could be cut down even further:

This literally just shows the information about the tables, and not any of the crap associated with stuff I don’t use (interoperability is a pain) such as stored procedures and triggers, and I also rarely use views so that went too.