Overview

This article describes the reason why 0 is returned in the SQL audit query record of RDS for MySQL.

 

Detail

Alibaba Cloud reminds you that:

  • Before you perform operations that may cause risks, such as modifying instance configurations or data, we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
  • You can modify the configurations and data of instances including but not limited to Elastic Compute Service (ECS) and Relational Database Service (RDS) instances. Before the modification, we recommend that you create snapshots or enable RDS log backup.
  • If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.

The SQL audit feature of RDS for MySQL records executed SQL statements, including the client IP address, database name, statement account, and SQL statement. The following two situations cause the number of returned records to be 0.

 

No data found

The following picture shows that no data can be queried.

未查询到数据

 

Data obtained from query cache

If the Query Cache is enabled, the number of records returned for queries that Cache data is 0. For more information, see configure and use the RDS for MySQL Query Cache.

查询缓存

 

Application scope

  • ApsaraDB RDS for MySQL