How to increase innodb_page_size in RDS?

Unfortunately, it is not possible to increase the innodb_page_size parameter in Amazon Relational Database Service (Amazon RDS) for MySQL, Amazon RDS for MariaDB and Amazon Aurora MySQL-Compatible Edition (Amazon Aurora MySQL). Currently, innodb_page_size is not modifiable parameter.

Instead of increasing innodb_page_size, there are a few alternative approaches you can consider to address the "Row size too large" error:

1. Consider changing some of your larger columns to TEXT or BLOB data types, as suggested in the error message. This allows MySQL to store these values off-page, reducing the size of the row stored in the main table.

2. Use ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED: These row formats can help manage large row sizes more efficiently. Note: Amazon Aurora MySQL does not support ROW_FORMAT=COMPRESSED.

3. Split your large table into multiple smaller tables, each with fewer columns.

Remember to always test any changes in a non-production environment before applying them to your production database.

Sources

• MySQL :: MySQL 8.4 Reference Manual :: 10.4.7 Limits on Table Column Count and Row Size
• MySQL :: MySQL 8.4 Reference Manual :: 17.10 InnoDB Row Formats
• Viewing parameter values for a DB parameter group in Amazon RDS - Amazon Relational Database Service
• Aurora MySQL configuration parameters - Amazon Aurora