MySQL: Index Length Exceeds Limit After MySQL Upgrade: ROW FORMAT COMPACT REDUNDANT Issue

Mysql

MySQL: Index Length Exceeds Limit After MySQL Upgrade: ROW FORMAT COMPACT REDUNDANT Issue

This is a common issue when upgrading MySQL. The problem is that in MySQL 5.7 (pre-5.7.34), tables using COMPACT or REDUNDANT row formats could have indexes exceeding 767 bytes, but MySQL 8 enforces stricter limits.

by Steps Easy on November 26, 2025