2. In the audit instance section on the Audit Log tab, select a database instance with audit enabled to view its SQL audit logs. Or, on the Audit Instance tab, click an instance ID to enter the Audit Log tab and view audit logs.
Note:
The audit log display time is down to milliseconds, facilitating more precise sorting and problem analysis of SQL commands.
Tool list
In the time box, select a time period to view audit results in the selected time period.
Note:
You can select any time period with data for search. Up to the first 60,000 eligible records can be displayed.
You can search by key tag to view related audit results. Common key tags include SQL command, client IP, database name, database account, SQL type, policy name, execution time, affected rows, and returned rows.
When entering multiple key tags for search, you can separate them by pressing "Enter".
You can filter IP addresses using the wildcard "". For example, if you enter "client IP: 9.223.23.2", IP addresses that start with "9.223.23.2" will be searched.
Combo search is supported. Selecting the key tag "SQL Command" allows you to separate filters using commas or spaces, and the logic relationship between them is AND. You may also use vertical bars ("|") to separate filters, and the logic relationship between them is OR.
Note:
When filtering by SQL command, the symbol * does not represent a fuzzy match. All SQL command searches are fuzzy searches.
Log list
In the SQL Type drop-down list, you can select multiple SQL types for filtering.
The Returned Rows field represents the specific number of rows returned by executing the SQL command, which is mainly used to determine the impact of SELECT commands.
SQL Audit Fields
TencentDB for MySQL and TDSQL-C for MySQL
The following fields are supported in TencentDB for MySQL and TDSQL-C for MySQL audit logs. You can click the following icon on the Audit Log tab in the TencentDB for MySQL or TDSQL-C for MySQL console to get and view the complete SQL audit logs.
No.
Field Name
Description
Remarks
1
host
Client IP
-
2
dbname
Database name
-
3
user
Username
-
4
sql
SQL statement
-
5
sqlType
SQL statement type
-
6
errCode
Error code
0 indicates success
7
affectRows
Number of affected rows
-
8
checkRows
Number of scanned rows
-
9
sentRows
Number of returned rows
-
10
threadId
Thread ID
-
11
ruleNum
Audit rule ID
-
12
policyName
Audit policy name
-
13
instanceName
Instance name
-
14
timestamp
Start time (s)
-
15
nsTime
Start Time (ns), which forms the start time accurate down to the nanosecond together with timestamp
Yes
No
Was this page helpful?