InnoDB-Rowformat-Compact 图解

测试表

mysql> show create table keys_order\G
*************************** 1. row ***************************
       Table: keys_order
Create Table: CREATE TABLE `keys_order` (
  `id` int(11) NOT NULL,
  `name` varchar(10) NOT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

注意这里特意设置了主键是由 id 和 name 组成。

测试数据

mysql> use xiaohaizi;
mysql> select * from keys_order;
+----+-------+------+
| id | name  | age  |
+----+-------+------+
|  7 | seven |    7 |
|  8 | eight |    8 |
|  9 | nine  |    9 |
| 10 | ten   |   10 |
+----+-------+------+
4 rows in set (0.00 sec)

数据目录查看表对应的独立表空间文件

mysql> show variables like 'datadir';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| datadir       | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.00 sec)

cd /var/lib/mysql

cd ‘database_name’;
xxd keys_order.ibd

图解分析 Row Format 之 Compact

compact format 组成

keys_order.ibd 分析