Regarding "[Warning] InnoDB: Cannot add field"
Hi,
I'm looking into the following warnings. It is the same kind of warning while one is regarding a regular table and the other is a tmp table. Can someone please help me understand them?
My interruption is that the row size has exceeded the max and as the row format is dynamic, it should just store the column values off-page which is the expected behavior; therefore, the warning is more like an FYI.
[Warning] InnoDB: Cannot add field <column_a> in table <db_a>.`#sql-ib693-621870abc` because after adding it, the row size is 8144 which is greater than maximum allowed size (8126) for a record on index leaf page.
[Warning] InnoDB: Cannot add field <column_b> in table `db_a`.`table_b` because after adding it, the row size is 8128 which is greater than maximum allowed size (8126) for a record on index leaf page.
The database hosting on: AWS RDS
MySQL version: 5.7.33
innodb_default_row_format: Dynamic
Thanks very much.
Subject
Views
Written By
Posted
Regarding "[Warning] InnoDB: Cannot add field"
7149
July 27, 2021 04:24PM
2899
July 27, 2021 07:51PM
2186
July 29, 2021 11:40AM
1558
July 29, 2021 12:17PM
1604
August 02, 2021 01:09PM
1719
August 02, 2021 03:17PM
1493
August 02, 2021 06:18PM
1718
August 02, 2021 11:47PM
1482
August 03, 2021 07:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.