tencent cloud

All product documents
TencentDB for MariaDB
DocumentationTencentDB for MariaDBOperation GuideDatabase AuditViewing Audit Logs
Viewing Audit Logs
Download PDF
Last updated: 2024-01-11 15:28:37
Viewing Audit Logs
Last updated: 2024-01-11 15:28:37
Download PDF

Viewing Logs

1. Log in to the TencentDB for MariaDB console, select Database Audit on the left sidebar, select a region at the top, and click the Audit Log tab.
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.

Tool list


Click the time box and select a time period to view the 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 audit results. Common key tags include SQL command, client IP, database name, database account, execution time, affected rows, and returned rows.
When entering multiple key tags in the text box for search, you can separate them by pressing Enter.
You can filter IP addresses by using the wildcard "". For example, if you enter "client IP: 10.0.0.0", IP addresses that start with "10.0.0.0" will be searched.

Log list

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.
The Affected Rows field represents the specific number of rows modified by executing the SQL command, which is mainly used to determine the impact of rewrite commands.

Audit Log Download

You can click the following icon on the Audit Log tab in the TencentDB for MariaDB console to obtain and view the complete SQL audit log.

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon