How can I see how big each mysql table is?

Log in to mysql, or phpmyadmin, and run this command:

mysql> show table status like '%';

This will return a bunch of statistics for each table:

# rows
average row length
data_length
max data length
auto_increment value

which can be useful for finding big tables or other purposes.