What Should I Do If the CPU Usage of My TaurusDB Instance Is High?
If the CPU usage is high or close to 100% when you use TaurusDB, data read/write processing slows down, connections cannot be established, and errors are reported, interrupting services.
Solution
- Check slow SQL logs for slow queries and examine their performance characteristics (if any) to locate the cause.
For details on viewing TaurusDB logs, see Viewing Slow Query Logs.
- View the CPU usage of your TaurusDB instance to facilitate problem locating.
- Create read replicas to offload read pressure from the primary node.
- Add indexes for associated fields in multi-table association queries.
- Do not use the SELECT statement to scan all tables. You can specify fields or add the WHERE condition.