show table status<\/p>\n
login to your server via ssh and run <\/p>\n
show table status login to your server via ssh and run root@host [~]# mysqlshow –status g33kinfo_wrdp1 |sort -n -k10 |awk -F\\| ‘($6 !~ \/0\/)’ |awk -F\\| ‘{print $2 ” ” $6 ” ” $7 ” ” $14}’ |egrep -v “^ ” this will give a result which looks like this Name Rows Avg_row_length Update_time wp_links… <\/p>\n
\nroot@host [~]# mysqlshow --status g33kinfo_wrdp1 |sort -n -k10 |awk -F\\| '($6 !~ \/0\/)' |awk -F\\| '{print $2 \" \" $6 \" \" $7 \" \" $14}' |egrep -v \"^ \"
\n<\/code>
\nthis will give a result which looks like this
\n
\n Name Rows Avg_row_length Update_time
\n wp_links 1 128 2009-06-14 04:30:57
\n wp_commentmeta 12 54 2010-01-03 18:29:22
\n wp_terms 12 30 2009-10-26 00:37:54
\n wp_term_taxonomy 13 47 2010-01-03 18:51:25
\n wp_users 14 119 2009-12-27 17:12:45
\n wp_usermeta 84 136 2010-01-03 18:52:58
\n wp_options 251 1536 2010-01-03 19:35:50
\n wp_postmeta 888 59 2010-01-03 18:51:26
\n wp_posts 1496 3603 2010-01-03 18:51:25
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"