首页 > 数据库 > MySQL > Mysql 行的存储格式
Mysql 的行数据存储格式有4种:
Compact
Redundant
Dynamic (Mysql5.7的默认格式)
mysql> show variables like '%row_format%';
+---------------------------+---------+
| Variable_name | Value |
+---------------------------+---------+
| innodb_default_row_format | dynamic |
+---------------------------+---------+
1 row in set (0.00 sec)
Compressed
详细信息参考:
https://www.cnblogs.com/zhuwenjoyce/p/15032812.html
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/21374452/viewspace-2846677/ ,如需转载,请注明出处,否则将追究法律责任。