Aikesheng Open Source Community
Sep 14, 2023 · Databases
Understanding Index Prefix Length Limits in MySQL 8.0 and 5.7
This article explains MySQL's index prefix length restrictions for BLOB/TEXT columns in versions 8.0 and 5.7, demonstrates verification experiments showing the 767‑byte and 3072‑byte limits for different InnoDB row formats, and discusses the underlying design implications.
Database DesignInnoDBPrefix Length
0 likes · 8 min read