InnoDB Row Formats

Title Description
InnoDB Row Formats Overview InnoDB's row formats are REDUNDANT, COMPACT, DYNAMIC, and COMPRESSED.
InnoDB REDUNDANT Row Format The REDUNDANT row format is the original non-compacted row format.
InnoDB COMPACT Row Format Similar to the REDUNDANT row format, but stores data in a more compact manner.
InnoDB DYNAMIC Row Format Similar to the COMPACT row format, but can store even more data on overflow pages.
InnoDB COMPRESSED Row Format Similar to the COMPACT row format, but can store even more data on overflow pages.
Troubleshooting Row Size Too Large Errors with InnoDB Fixing "Row size too large (> 8126). Changing some columns to TEXT or BLOB may help."
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/innodb-row-formats/