How do I monitor SQL audit log storage in MySQL?
Background Description:
After the SQL audit function is enabled for RDS for MySQL, the number of SQL audit logs stored is 10, each with a size of 1 GB. If there are more than 10 logs, the excessive log will overwrite the first log. The SQL audit log storage can only occupy a disk size of 10 GB.
Steps:
1. Perform search and query by keyword.
2. Perform search and query by time range.
3. Perform search and query by user name.
4. Perform search and query by database name.
5. Perform search and query by operation type.
6. Select the status as success or failure for the query.