MySQL 테이블 Fixed 확인

MySQL 테이블 Fixed, Dynamic 확인

MySQL Row_format 확인

방법 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

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)

같이 보기

• SHOW TABLE STATUS
• information_schema.TABLES