MySQL 테이블 Fixed 확인

MySQL 테이블 Fixed, Dynamic 확인
MySQL Row_format 확인

1 방법 1[ | ]

SHOW TABLE STATUS LIKE '테이블명';

mysql> SHOW TABLE STATUS LIKE 'alexa_rank_history'\G
*************************** 1. row ***************************
           Name: alexa_rank_history
         Engine: MyISAM
        Version: 10
     Row_format: Fixed
           Rows: 0
 Avg_row_length: 0
    Data_length: 0
Max_data_length: 16888498602639359
   Index_length: 1024
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2015-01-11 21:01:04
    Update_time: 2015-01-11 21:01:04
     Check_time: NULL
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options: 
        Comment: 
1 row in set (0.00 sec)

→ Row_format: Fixed

2 방법 2[ | ]

SELECT ROW_FORMAT FROM information_schema.TABLES WHERE TABLE_NAME='테이블명';

mysql> SELECT ROW_FORMAT FROM information_schema.TABLES WHERE TABLE_NAME='alexa_rank_history';
+------------+
| ROW_FORMAT |
+------------+
| Fixed      |
+------------+
1 row in set (0.00 sec)

3 같이 보기[ | ]