MySQL:统计数据填充的不同

作者简介：高鹏，笔名八怪。《深入理解MySQL主从原理》图书作者，同时运营个人公众号“MySQL学习”，持续分享遇到的有趣case以及代码解析！

5.7.22，此处以表的统计信息为例进行描述

一、 information_schema.tables

表的信息大部分的信息来自Innodb数据字典dict_table_t内存信息。

   TABLE_CATALOG: def                   0     TABLE_SCHEMA: test                  1           TABLE_NAME: tt3_1383              2           TABLE_TYPE: BASE TABLE            3               ENGINE: InnoDB                4              VERSION: 10                    5           ROW_FORMAT: Dynamic               6           TABLE_ROWS: 0                     7       AVG_ROW_LENGTH: 0                     8          DATA_LENGTH: 16384                 9      MAX_DATA_LENGTH: 0                    10         INDEX_LENGTH: 0                    11            DATA_FREE: 0                    12       AUTO_INCREMENT: NULL                 13          CREATE_TIME: 2021-05-07 05:50:17  14          UPDATE_TIME: NULL                 15           CHECK_TIME: NULL                 16      TABLE_COLLATION: latin1_swedish_ci    17             CHECKSUM: NULL                 18       CREATE_OPTIONS:                      19        TABLE_COMMENT:                      20             {"TABLES", tables_fields_info, create_schema_table,         get_all_tables, make_old_format, get_schema_tables_record, 1, 2, 0,            OPTIMIZE_I_S_TABLE}