MySql Statistics Pseudo Top

Using "mysqlshow"
# mysqlshow -u root -p******** -i mydbname "mytable*"

Using "watch" and "mysql -e"
# watch -d -n 10 "mysql -u root -p******** -e \"show status\" | egrep \"Byte|Com_insert|Hand|Key|Quest|Table\" "

http://dev.mysql.com/doc/refman/4.1/en/show-status.html
http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html

REFERRERS
MySql
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki