All Products
Search
Document Center

PolarDB:Performance Insight (original version)

Last Updated:Mar 11, 2024

PolarDB for MySQL provides the diagnostics feature that integrates some features of Database Autonomy Service (DAS). You can use the Performance Insight feature to rapidly evaluate the workloads on databases and identify the root causes of performance issues. This helps you improve the stability of your databases.

Background information

The Performance Insight feature collects and analyzes data from the following major sources:

  • If performance_schema is enabled for database instances, the Performance Insight feature collects and analyzes the data stored in performance_schema.

  • If performance_schema is disabled for database instances, the Performance Insight feature collects and analyzes the data of active sessions.

Procedure

  1. Log on to the PolarDB console.

  2. In the left-side navigation pane, click Clusters.

  3. In the top navigation bar, select the region in which the cluster that you want to manage is deployed.

  4. On the Clusters page, find the cluster for which you want to enable the autonomy service, and click the cluster ID.
  5. In the left-side navigation pane, choose Diagnostics and Optimization > Quick Diagnostics.
  6. Click the Performance Insight tab.

  7. Click Enable Performance Insight.

    Performance Insight

  8. In the dialog box that appears, click Confirm.

  9. On the Performance Insight tab, view and manage the following information:

    • In the Performance Trend section, you can specify a time range to view the performance trends of databases. If you want to view the details of a specific performance metric such as CPU utilization, click Details in the upper-right corner of the performance metric section. Performance trends

      Note

      The duration of the specified time range cannot exceed seven days.

    • In the Average Active Session section, you can view the trends of different types of sessions, such as sessions that are created to execute SQL statements. You can also view the database workloads from multiple dimensions. This can help you identify the root causes of performance issues. Active sessionsMultidimensional