When you need to monitor and manage SQL statements executed in a database instance, you can use the SQL insight and audit feature to record and analyze SQL statement execution. After you enable this feature, it automatically records SQL statements from the database kernel, along with the execution account, IP address, and execution details. This feature has no impact on instance performance and provides traffic replay and stress testing capabilities to help you verify whether your instance specifications need to be scaled up, effectively handling traffic peaks.
Features
-
SQL audit: Query and export SQL statements and their associated information, such as the database, status, and execution time.
-
SQL Explorer: Diagnose SQL health, troubleshoot performance issues, and analyze business traffic.
-
Traffic playback and stress testing: Provide traffic replay and stress testing capabilities to help you verify whether your instance specifications need to be scaled up, effectively handling traffic peaks.
Enable SQL insight and stress testing (new version)
-
Log on to the PolarDB-X console. Go to the Basic Information page of the target instance. In the left-side navigation pane, choose .
-
Click Enable Enterprise Edition V3, configure Audit Scenarios as needed, and then click Activate.