How to get rowcount for all tables in MySQL

Question

How can I get a rowcount for all tables in MySQL. I can do this databases by database if that is easier.

The purpose is to do a cursory check on my database replication that was just setup.

Answer 1

try mk-table-checksum instead. docs might be scary but together with mk-checksum-filter it's very useful tool.

Answer 2

If you are want to check on your replication setup, have you considered using:

• SHOW SLAVE STATUS check the Seconds_Behind_Master value
• SHOW MASTER STATUS not as useful as the above

Answer 3

./mysql -utest -ptest dbname -e 'show table status\G' | awk '/Name/ {name = $2}; /Rows/ {print $2"\t"name}' | sort -gr

Answer 4

A very crisp and clean way to retrieve all the tables along with its row count

Row count of all tables in a database