MYSQLでテーブルの状態確認では、SHOW STATUSを良く
利用するが詳細な統計情報を確認にするには以下のようなコマンドで確認する。


mysql> show table status like 'TABLE911'\G
*************************** 1. row ***************************
Name: TABLE911
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 12
Avg_row_length: 1365
Data_length: 16384
Max_data_length: 0
Index_length: 32768
Data_free: 0
Auto_increment: 22
Create_time: 2009-04-10 21:41:36
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.01 sec)

mysql>

show_status


select * from TABLE911 PROCEDURE ANALYSE();

optimise

Comments are closed.

Post Navigation