SHOW TABLE STATUS FROM MyDatabaseName;

Run that query if you would like to know basic details about a database, especially the overhead to see if you would need to optimize it.

Name: AdSpeedDB
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 0
Avg_row_length: 0
Data_length: 4676
Max_data_length: 281474976710655
Index_length: 3072
Data_free: 4676
Auto_increment: 221
Create_time: 2007-08-01 17:15:24
Update_time: 2008-06-03 07:26:13
Check_time: NULL
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment: Ad Server