In PolarDB for MySQL, both the old and new versions of the SQL Explorer and Audit feature are provided. The new version of SQL Explorer and Audit uses a tiered storage architecture that separates hot data from cold data. This reduces the cost of using the feature by 17% to 83%. The new version has become available in multiple regions since May 7, 2023.
Applicable regions
China (Hangzhou), China (Shanghai), China (Beijing), China (Zhangjiakou), China (Shenzhen), China (Hong Kong), and Singapore
Price reduction rate
In this example, a cluster in the China (Hangzhou) region is used to describe the price difference.
This example is for reference only. You can view your bill for the actual prices.
Data retention period | Volume of data stored (Unit: GB) | Fee for the old version of SQL Explorer and Audit (Unit: USD per month) | Fee for the new version of SQL Explorer and Audit (Unit: USD per month) | Price reduction rate |
7 days | 100 | 125.22 | 104.35 | 17% |
30 days | 429 | 357.83 | 147.25 | 59% |
6 months | 2571 | 2,146.52 | 426.67 | 81% |
1 year | 5214 | 4,352.75 | 771.45 | 83% |
Billing
Billable item | Billing method | Unit price | Description |
Storage resources | Pay-as-you-go |
| SQL Explorer and Audit data generated in the last seven days is stored in hot storage mode, and the data generated exactly seven days ago is transferred from hot storage to cold storage. |
Resources used for data queries | USD 0.029 per GB | You are charged for querying data on a pay-as-you-go basis when one of the following conditions is met:
|
For more information, see Billing method for the new version.
Feature description
The SQL Explorer and Audit feature is developed based on the full request analysis and security audit capabilities and is integrated with features such as SQL statement search and SQL Explorer. You can query information about SQL statements and use the information to troubleshoot performance issues and identify risk sources. In addition, you can use the traffic playback and stress testing features to check whether you need to scale up your PolarDB for MySQL cluster to handle workloads during peak hours. See SQL Explorer for more details.
Usage notes
If SQL Explorer or the old version of SQL Explorer and Audit is enabled for your cluster, perform the following operations:
If SQL Explorer is enabled for your cluster, log on to the PolarDB for MySQL console, go to the SQL Explorer page, and then click Upgrade in the dialog box that appears to upgrade SQL Explorer to the old version of SQL Explorer and Audit. Then, follow the steps in Upgrade to new SQL Explorer and Audit to upgrade the feature to the new version in the PolarDB for MySQL console.
If the old version of SQL Explorer and Audit is enabled for your cluster, follow the steps in Upgrade to new SQL Explorer and Audit to upgrade the feature to the new version in the PolarDB for MySQL console.
NoteYou can upgrade SQL Explorer and Audit to the new version if your PolarDB for MySQL cluster is deployed in the China (Hangzhou), China (Shanghai), China (Beijing), or China (Shenzhen) region.
If SQL Explorer is not enabled for your cluster:
In the left-side navigation pane of the Basic Information page of your PolarDB for MySQL cluster, choose Autonomy Service > SQL Explorer and Audit, and click Enable on the page that appears.