Easier-to-read MySQL “show table status”

mysqlshow --status yourdbnamehere |sort -n -k10 |awk -F\| '($6 !~ /0/)' |awk -F\| '{print $2 " " $6 " " $7 " " $14}' |egrep -v "^  "

Name Rows Avg_row_length Update_time
wp_links 1 128 2009-06-14 04:30:57
wp_comments 11 536 2009-12-01 02:43:25
wp_terms 12 30 2009-10-26 00:37:54
wp_term_taxonomy 13 47 2009-12-01 01:23:39
wp_users 13 118 2009-11-14 07:56:55
wp_usermeta 75 107 2009-12-01 01:23:06
wp_options 244 3326 2009-12-01 01:31:52
wp_postmeta 449 61 2009-12-01 01:28:43
wp_posts 815 2111 2009-12-01 01:23:39
wp_term_relationships 823 21 2009-12-01 01:23:39

g33kadmin

I am a g33k, Linux blogger, developer, student and Tech Writer for Liquidweb.com/kb. My passion for all things tech drives my hunt for all the coolz. I often need a vacation after I get back from vacation....

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.