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

Comments (0)

› No comments yet.

Leave a Reply

Allowed Tags - You may use these HTML tags and attributes in your comment.

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Pingbacks (0)

› No pingbacks yet.