Simple Log Service and PolarDB-X 1.0 jointly launch the SQL audit and analysis feature that allows you to collect SQL audit logs to Simple Log Service. You can use the feature to query, visualize, analyze, ship and transform logs in real time. You can also use the feature to configure alerts for the logs. This topic describes the assets, billing, and limits of the SQL audit and analysis feature.
Assets
Dedicated project and Logstore
After you enable the SQL audit and analysis feature, Simple Log Service creates a project named drds-audit-Region name-Alibaba Cloud account ID and a dedicated Logstore named drds-audit-log by default.
ImportantIf you have enabled the pay-by-ingested-data billing mode, Simple Log Service creates a dedicated Logstore that uses the pay-by-ingested-data billing mode by default. If you want to switch the billing mode from pay-by-ingested-data to pay-by-feature, you can modify the configuration of the Logstore. For more information, see Modify the configurations of a Logstore.
Dedicated dashboards
By default, Simple Log Service generates three dashboards after you enable the feature.
NoteWe recommend that you do not make changes to the dedicated dashboards because the dashboards may be upgraded or updated at any time. You can create a custom dashboard to visualize query results. For more information, see Create a dashboard.
Dashboard
Description
Operation Center (Simple)
Shows the statistics of DRDS instances, including the metrics, distribution, and trends of SQL statement executions.
Performance Center
Shows the performance metrics, average time consumed by each type of SQL statement, and the distribution and sources of slow SQL queries.
Security Center
Shows the security metrics, batch delete events, and malicious SQL executions.
Billing
You are not charged for the SQL audit and analysis feature.
If the dedicated Logstore uses the pay-by-feature billing mode, you are charged for storage, read traffic, number of requests, data transformation, and data shipping after the logs are collected from PolarDB-X 1.0 to Simple Log Service. The fees are included in the bills of Simple Log Service. For more information, see Billable items of pay-by-feature.
If the dedicated Logstore uses the pay-by-ingested-data billing mode, you are charged only for read traffic over the Internet after the logs are collected from PolarDB-X 1.0 to Simple Log Service. The fees are included in the bills of Simple Log Service. For more information, see Billable items of pay-by-ingested-data.
Limits
You can write only SQL audit logs to the dedicated Logstore. You cannot modify the indexes of the dedicated Logstore. No limits are imposed for features such as query, analysis and alerting.
The SQL audit and analysis feature is supported only in the China (Hong Kong) and Singapore regions.
Log Audit Service also allows you to collect SQL audit logs of PolarDB-X 1.0 to Simple Log Service. For more information, see Log Audit Service.