Help Center/ Relational Database Service/ Troubleshooting/ RDS for MySQL/ Performance Issues/ System Inaccessible After Field Addition to an RDS for MySQL Database Table
Updated on 2022-12-05 GMT+08:00
View PDF
Share

System Inaccessible After Field Addition to an RDS for MySQL Database Table

Description

After a field was added to an RDS for MySQL database table, the system becomes inaccessible.

Solution

The database performance is affected due to the addition of table fields. A possible reason is that indexes are not added to the new table fields. As a result, a large amount of data consumes a large number of CPU resources. You are advised to:

  • Add indexes and primary keys.
  • Optimize slow SQL statements.
Parent topic: Performance Issues