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

---

Script to convert all tables to DYNAMIC format:

- Generate ALTER statements for all affected tables

SELECT CONCAT( 'ALTER TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAME, '` ROW_FORMAT=DYNAMIC;' ) AS alter_statement FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('mysql', 'information_schema', 'performance_schema', 'sys') AND ROW_FORMAT IN ('Compact', 'Redundant') AND ENGINE = 'InnoDB';

Copy the output and execute each ALTER statement. to solve the issue

---