Compressed和Dynamic行记录格式

Post author: 戛戛Happy
Post link: <a href="https://blog.gagahappy.cn/compressed-and-dynamic-record-format/" title="Compressed和Dynamic行记录格式">https://blog.gagahappy.cn/compressed-and-dynamic-record-format/
Copyright Notice: All articles in this blog are licensed under <a href="https://creativecommons.org/licenses/by-nc-sa/4.0/" rel="noopener" target="_blank"> BY-NC-SA unless stating additionally.

Posted on 2015-02-13 In mysql , innodb

主要区别是在存储BLOB和TEXT时采用完全溢出的方式，行记录中只存20个字节的指针，数据存放在off page页中。同时，Compressed格式可以对BLOB、TEXT这样的大对象进行zip算法的压缩存储