Help Center> GaussDB(for MySQL)> Troubleshooting> Backup and Restoration Issues> System Inaccessible After Field Addition to a Database Table
Updated on 2023-09-15 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.