Dec 032009
 
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

 Posted by at 2:58 am

 Leave a Reply