This topic describes the benefits of the AliSQL kernel.
An instance in a dedicated cluster that runs the ApsaraDB RDS for MySQL database engine uses the same AliSQL kernel as a regular ApsaraDB RDS for MySQL instance and provides all features of a regular ApsaraDB RDS for MySQL instance. An instance in a dedicated cluster that runs the ApsaraDB RDS for MySQL database engine also provides advanced features such as enterprise-level security, backup, recovery, monitoring, performance optimization, and read-only instances. For more information, see Overview of AliSQL features and Introduction to X-Engine.
Version support
Category | Feature | Description | MySQL 8.0 | MySQL 5.7 | MySQL 5.6 |
Functionality | The native flashback feature lets you query or restore the data at a specified point in time by executing SQL statements. This way, you can obtain the historical data at your earliest opportunity after accidental operations. | Supported | Not supported | Not supported | |
The thread pool feature separates threads from sessions. If many sessions are created on your ApsaraDB RDS for MySQL instance, the system can run a small number of threads to process the tasks in all active sessions. | Supported | Supported | Supported | ||
The statement outline feature allows the system to stably run query plans using optimizer hints and index hints. You can install the DBMS_OUTLN package to use this feature. | Supported | Supported | Not supported | ||
The Sequence engine simplifies the generation of sequence values on your RDS instance. | Supported | Supported | Supported | ||
The returning feature allows DML statements to return result sets. You can install the DBMS_TRANS package to use this feature. | Supported | Not supported | Not supported | ||
The always-confidential feature encrypts the data columns that you want to protect in your RDS instance. This prevents unauthorized users from accessing the plaintext of the protected data columns using software and tools on the cloud platform. | Not supported | Supported | Not supported | ||
Performance | The fast query cache is a query cache that is developed by Alibaba Cloud based on the native MySQL query cache. The fast query cache uses a new design and a new implementation mechanism to increase the query performance of your RDS instance. | Not supported | Supported | Not supported | |
The Binlog in Redo feature allows the system to write binary logs to the redo log file when transactions are committed. This reduces the operations on the disk and increases the performance of your RDS instance. | Supported | Not supported | Not supported | ||
The statement queue feature allows statements to queue in the same bucket. These statements may be executed on the same resources. For example, these statements are executed on the same row of a table. This feature reduces the overheads that are caused by potential conflicts. | Supported | Supported | Not supported | ||
The inventory hint feature can be used in combination with the returning feature and the statement queue feature to commit and roll back transactions at fast speeds. This increases the throughput of your application. | Supported | Supported | Supported | ||
The Binlog Parallel Flush feature allows the system to write binary logs in parallel when transactions are committed. This reduces performance bottlenecks in high-concurrency scenarios and improves the write performance of your RDS instance. | Supported | Not supported | Not supported | ||
Stability | The faster DDL feature provides an optimized buffer pool management mechanism. This mechanism reduces the impact of DDL operations on the performance of your RDS instance. This mechanism also increases the number of concurrent DDL operations that are allowed. | Supported | Supported | Supported | |
The concurrency control (CCL) feature allows the system to control the concurrency of statements based on syntax rules. You can install the DBMS_CCL package to use this feature. | Supported | Supported | Not supported | ||
The performance agent feature is provided as an extension for MySQL. This feature is used to calculate and analyze the performance metrics of your RDS instance. | Supported | Supported | Supported | ||
The Purge Large File Asynchronously feature allows the system to asynchronously delete files from your RDS instance. This ensures the stability of your RDS instance. | Supported | Supported | Supported | ||
The performance insight feature supports load monitoring, association analysis, and performance optimization at the instance level. You can evaluate the loads on your RDS instance and resolve performance issues. This increases the stability of your RDS instance. | Supported | Supported | Not supported | ||
The binlog cache free flush feature is supported. This feature optimizes the commitment of large transactions to prevent excessive latencies in writing binary logs, prevents your RDS instance from becoming unresponsive, and ensures that your RDS instance remains stable and writable. | Supported | Not supported | Not supported | ||
High security | The recycle bin feature allows the system to temporarily store deleted tables. It also lets you specify a retention period within which you can retrieve the deleted tables. You can install the DBMS_RECYCLE package to use this feature. | Supported | Not supported | Not supported |