I upgraded mysql 5.6 -> mysql 8.0.23 in AWS RDS. There is a warning:
- Creating indexes larger than 767 bytes on tables with redundant row format might cause the tables to be inaccessible. You have one or more tables with redundant row format. Creating an index larger than 767 bytes might cause the table to be inaccessible (only 50 tables are shown). More Information: https://bugs.mysql.com/bug.php?id=99791
[table_schema, table_name] <schema, table_name> - Consider restoring the DB instance from a snapshot creating before upgrading, and change the row_format of the tables to dynamic.
So in the database, there are tables that have row format equals COMPACT, DYNAMIC or FIXED. As I understand I have to change to dynamic from compact.
What is proper way to change all tables format to DYNAMIC?
ALTER TABLE table_name ROW_FORMAT=DYNAMIC; the table will have BARACUDA in mysql 8?
Or there is another way to fixed this warning?