Database Autonomy Service (DAS) provides the diagnostics feature for ApsaraDB RDS for MySQL. This feature diagnoses your ApsaraDB RDS for MySQL instance and visualizes the results.

Prerequisites

Your RDS instance runs one of the following MySQL versions and RDS editions:
  • MySQL 8.0 on RDS High-availability Edition or RDS Enterprise Edition
  • MySQL 5.7 on RDS High-availability Edition or RDS Enterprise Edition
  • MySQL 5.6 on RDS High-availability Edition
  • MySQL 5.5 on RDS High-availability Edition

Procedure

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, choose Autonomy Service > Diagnostics.
  3. Click the Diagnostics tab.
  4. On the Diagnostics tab, specify a time range to diagnose the RDS instance and check the diagnostic results.

    Click View History to view historical diagnostic results.

FAQ

  • How do I calculate the thread usage, connection usage, and maximum number of threads of a session on an RDS instance?
    You can calculate these metrics by using the following formulas:
    • Thread usage = Number of active threads/Maximum number of threads
    • Connection usage = Number of current connections/Maximum number of connections allowed by the instance type
    • Maximum number of threads = Value of thread_pool_size × (Value of thread_pool_oversubscribe + 1)
  • Why does the thread usage exceed 100%?

    If the number of active threads is greater than the maximum number of threads, the thread usage exceeds 100%. The method that is used to implement thread pooling for ApsaraDB RDS for MySQL does not impose limits on the number of active threads. Therefore, the number of active threads may be greater than the maximum number of threads.