Help Center/ TaurusDB/ FAQs/ Database Performance/ What Should I Do If the CPU Usage of My TaurusDB Instance Is High?
Updated on 2024-12-30 GMT+08:00
View PDF
Share

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, affecting workloads.

Solution

  1. 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 Managing Slow Query Logs of a DB Instance.

  2. View the CPU usage of your TaurusDB instance to facilitate problem locating.

    For details, see TaurusDB 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.
Parent topic: Database Performance