InnoDB Row Formats

Explore InnoDB row formats in MariaDB Server. Understand different formats like Compact, Dynamic, and Compressed, and how they impact storage efficiency and performance for your data.

InnoDB Row Formats Overview

An overview of the four InnoDB row formats (REDUNDANT, COMPACT, DYNAMIC, COMPRESSED), comparing their storage efficiency and feature support.

InnoDB COMPACT Row Format

Detailed information on the COMPACT row format, which reduces storage space by roughly 20% compared to REDUNDANT, handling NULLs and variable-length columns efficiently.

InnoDB COMPRESSED Row Format

Learn about the COMPRESSED row format, which compresses data and index pages using algorithms like zlib to minimize storage footprint at the cost of CPU.

InnoDB DYNAMIC Row Format

The DYNAMIC row format, default in modern MariaDB versions, optimizes storage for large BLOB/TEXT columns by storing them on separate overflow pages.

InnoDB REDUNDANT Row Format

Information on the legacy REDUNDANT row format, primarily maintained for backward compatibility with older MySQL versions.

Troubleshooting Row Size Too Large Errors with InnoDB

Complete InnoDB row size troubleshooting: innodb_strict_mode, ALTER TABLE ROW_FORMAT=DYNAMIC, VARCHAR/VARBINARY(256) overflow, and BLOB/TEXT solutions.

_{This page is licensed: CC BY-SA / Gnu FDL}