Help Center/ Data Admin Service/ Best Practices/ SQL Explorer
Updated on 2023-04-20 GMT+08:00
View PDF

SQL Explorer

Overview

SQL Explorer is also called SQL audit. It allows you to not only query all executed SQL statements, but also analyze and search for the tables that are accessed and updated the most frequently, and SQL statements that have the longest lock wait, helping you quickly identify exceptions to ensure stable database services.

Scenarios

  • SQL query for performance tuning
  • SQL diagnosis for problem tracking

FAQs

  1. Is SQL Explorer available to all RDS instances?

    No. This function is available to only RDS for MySQL 5.7 instances whose minor versions are later than 5.7.29.2.

  2. Does this function affect the storage space of DB instances?

    No. This function does not occupy storage space.

  3. Is this function available to databases built on ECSs?

    No. This function is not available to community edition databases built on ECSs.

  4. Does this function affect performance of DB instances?

    This function has slight impact on instance performance. The performance loss is within 5%.