MySQL: How to find out table stats like rows, space used and last update time

The following MySQL command provides a lot of good information about tables.

show table status 

This statement also displays information about views.

SHOW TABLE STATUS returns the following important fields along with a lot of other intersting data:

The storage engine for the table. See Chapter 13, Storage Engines.

The number of rows. Some storage engines, such as MyISAM, store the exact count. For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40 to 50%. In such cases, use SELECT COUNT(*) to obtain an accurate count.

The average row length.

The length of the data file.

More info here