Query Analysis

By analyzing SQL query activities, you can accurately identify SQL statements that affect database performance or continuously monitor query activities for statement adjustments and optimizations.

Procedure

Web Console
  1. Click on MySQL-PXC in the left navigation bar.

  2. Click on Namespace Name.

  3. Click on Instance Name.

  4. In the Query Analysis tab, set the search criteria.

    • To find statements executed within a specific time period: select a time period in the Time Range section.

    • To find specific statements: enter keyword(s) in the Search by SQL Statement section, then click search.

  5. Wait for a moment and view the results.

ON THIS PAGE