Problem description
When you create a table in an apsaradb RDS for MySQL instance, the following error occurs.
ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs.
Cause
There are restrictions when creating a table in a MySQL database. For more information, see MySQL documentation.
- The length of each field cannot exceed 65535. Otherwise, the string is converted into the TEXT type.
- Single row length cannot exceed 65535 (excluding TEXT and BLOB types).
Solution
Alibaba Cloud reminds you that:
- Before you perform operations that may cause risks, such as modifying instance configurations or data, we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
- You can modify the configurations and data of instances including but not limited to Elastic Compute Service (ECS) and Relational Database Service (RDS) instances. Before the modification, we recommend that you create snapshots or enable RDS log backup.
- If you have authorized or submitted sensitive information such as the logon account and password in the Alibaba Cloud Management Console, we recommend that you modify such information in a timely manner.
- Narrow the length of the field and ensure that the length of the field does not exceed 65535 characters.
- Use the TEXT and BLOB types for long fields.
Application scope
- ApsaraDB RDS for MySQL