What Should I Do If the CPU Usage of My Instance Is High?

Solution

1. Check slow SQL logs for slow queries and examine their performance characteristics (if any) to locate the cause.

   For details on viewing MySQL logs, see Viewing Slow Query Logs.

2. View the CPU usage of your GaussDB(for MySQL) instance to facilitate problem locating.

   For details, see Configuring Displayed Metrics.

3. Create read replicas to offload read pressure from the primary node.
4. Add indexes for associated fields in multi-table association queries.
5. Do not use the SELECT statement to scan all tables. You can specify fields or add the WHERE condition.