mysql中的show table status like 'tablename'中的version表示什么意思？

Question

mysql> show table status like 'wp_xdlog'\G;
*************************** 1. row ***************************
           Name: wp_xdlog
         Engine: MyISAM
        Version: 10
     Row_format: Dynamic
           Rows: 0
 Avg_row_length: 0
    Data_length: 0
Max_data_length: 281474976710655
   Index_length: 1024
      Data_free: 0
 Auto_increment: 1
    Create_time: 2016-05-03 18:26:45
    Update_time: 2016-05-03 18:26:45
     Check_time: NULL
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options:
        Comment:
1 row in set (0.00 sec)

ERROR:
No query specified

上面的version版本号是什么意思？官方的解释是

Version

The version number of the table's .frm file.

这个版本号会不会随着一些操作改变，还是固定的？

Answer 1

I haven’t tested it yet. It is speculated that it is the version number of the MySQL table structure. Its function is to track the process of the table structure. For example, during replication, if the version of the table structure is inconsistent, replication should not be performed. You can test it yourself and alter it. For the table structure, use show to see if the version has changed. It should be used by the internal mechanism of MySQL, which is transparent to users.