Help Center/ GaussDB(for MySQL)/ Troubleshooting/ Backup and Restoration Issues/ System Inaccessible After Field Addition to a Database Table
Updated on 2023-10-19 GMT+08:00

System Inaccessible After Field Addition to a Database Table

Scenarios

After a field was added to a 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.