This topic describes the release notes for AliSQL. AliSQL is a MySQL branch that is developed by Alibaba Cloud. AliSQL provides all features of MySQL Community Edition. AliSQL also provides features that are similar to the features of MySQL Enterprise Edition. These similar features include the enterprise-grade backup and restoration, thread pool, and parallel query. ApsaraDB RDS for MySQL together with AliSQL provides a wide range of advanced features, such as security control, backup, restoration, monitoring, performance optimization, and read-only instances. This topic describes the release notes for AliSQL and provides links to the relevant references.
- For more information about how to update the minor AliSQL version of an RDS instance, see Update the minor engine version of an ApsaraDB RDS for MySQL instance.
- If the minor AliSQL version of an RDS instance is outdated, the workloads that are run on the RDS instance may be interrupted. We recommend that users update the minor engine versions of their RDS instances on a regular basis or immediately after they receive O&M notifications from Alibaba Cloud.
- This topic describes all minor AliSQL versions that are released. When a minor AliSQL version is in maintenance, the minor AliSQL version may be unavailable in the ApsaraDB RDS console. Users can select only the minor AliSQL versions that are displayed in the ApsaraDB RDS console.
- For more information about the dedicated database proxy versions of ApsaraDB RDS for MySQL, see Release notes of dedicated proxy versions.
MySQL 8.0 on RDS Basic Edition or RDS High-availability Edition
Minor AliSQL version | Description |
---|---|
20220331 |
|
20210930 |
Note Open source MySQL 8.0.22 provides the derived_condition_pushdown feature. The feature
can reduce the amount of data scanned in derived tables and accelerate queries. However,
the feature ignores user variables. As a result, null values are returned for user
variables, and queries cannot be completed. For more information, see the open source MySQL documentation.
To resolve this issue, users must connect to their RDS instance and run the |
20201031 |
|
20200831 |
|
20200630 |
|
20200430 |
|
20200331 |
|
20200229 |
|
20200110 |
|
20191225 |
|
20191115 |
New features: The statement queue feature is supported. This feature allows statements to be queued in the same bucket. These statements can be executed on the same resources. For example, these statements can be executed on the same row of a table. This feature helps reduce the overhead that is caused by conflicts. For more information, see Statement Queue. |
20191101 |
|
20191015 |
|
20190915 |
Bug fixes: The bug that causes memory leaks when the Cmd_set_current_connection process runs is fixed. |
20190816 |
|
20190601 |
|
MySQL 8.0 on RDS Enterprise Edition
Minor AliSQL version | Description |
---|---|
20210305 | Bug fixes:
The bug that causes memory leaks for PERFORMANCE SCHEMA is fixed. |
20200918 | New features:
SSL encryption can be enabled for the dedicated proxy of an RDS instance. |
20200805 | Bug fixes:
A metadata-related bug is fixed. |
20200608 |
|
20200317 |
|
MySQL 5.7 on RDS Basic Edition or RDS High-availability Edition
Minor AliSQL version | Description |
---|---|
20220430 |
|
20211231 |
|
20210630 |
|
20210430 |
|
20201031 |
Bug fixes:
|
20200831 |
|
20200630 |
|
20200430 |
|
20200331 |
|
20200229 |
|
20200110 |
Performance improvements:
|
20191225 |
|
20191115 |
Bug fixes: The bug due to which ApsaraDB RDS displays variables in audit logs when a primary/secondary switchover is performed is fixed. |
20191101 |
|
20191015 |
|
20190925 |
Adjusted parameters:
|
20190915 |
New features: The thread pool feature is provided to separate threads from sessions. If a large number of sessions are created, ApsaraDB RDS can run a small number of threads to complete the tasks in active sessions. For more information, see Thread Pool. |
20190815 |
|
20190510 |
New features: The creation of temporary tables in transactions is supported. |
20190319 |
New features: The configuration of thread IDs for proxies in handshake packets is supported. |
20190131 |
|
20181226 |
|
20181010 |
Performance improvements:
|
20180431 |
New features:
|
MySQL 5.7 on RDS Enterprise Edition
Minor AliSQL version | Description |
---|---|
20201229 | Bug fixes:
|
20191128 |
|
20191016 |
|
20190909 |
|
20190709 |
New features:
|
MySQL 5.6
Minor AliSQL version | Description |
---|---|
20210630 |
|
20210430 |
|
20201031 | Bug fixes:
|
20200831 |
|
20200630 |
|
20200430 |
|
20200331 |
Performance improvements:
|
20200229 |
|
20200110 |
|
20191212 | Performance improvements:
Unnecessary TCP error logs can be deleted. |
20191115 | Bug fixes:
The bug that causes an overflow of timestamps in slow query logs is fixed. |
20191101 | Bug fixes:
|
20191015 |
|
20190815 | Performance improvements:
An optimized instance locking mechanism is provided. This mechanism allows users to drop or truncate tables on an RDS instance even if the RDS instance is locked. |
20190130 | Bug fixes:
The bugs that compromise database stability are fixed. |
20181010 | Performance improvements:
The rocksdb_ddl_commit_in_the_middle parameter is supported by MyRocks. If this parameter is set to on, some DDL statements call the COMMIT operation when they are executed. |
201806** | New features:
Slow query logs can be collected at the microsecond level. |
20180426 |
|
20171205 | Bug fixes:
|
20170927 | Bug fixes:
The bug due to which ApsaraDB RDS queries TokuDB tables based on inappropriate indexes is fixed. |
20170901 |
|
20170530 | New features:
The privileged account of an RDS instance is granted the permissions to close all connections that are established by the standard accounts of the RDS instance. |
20170221 | New features:
The read/write splitting feature is supported. For more information, see Enable the proxy terminal feature for an ApsaraDB RDS for MySQL instance. |
MySQL 5.5
Minor AliSQL version | Description |
---|---|
20181212 | Bug fixes:
The bug due to which the |