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 enterprise-grade backup and restoration, thread pools, and parallel queries. 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.

Note
  • 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 AliSQL versions of their RDS instances on a regular basis or 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 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
20201031
  • New features:
    • Tables can be restored from the recycle bin. For more information, see Recycle bin.
    • Slow query log files can be automatically restored for an RDS instance when the instance is initialized.
  • Performance improvements:

    If X-Engine is used, the Binlog in Redo feature cannot be enabled. For more information, see Binlog in Redo.

  • Bug fixes:
    • The bug that causes errors during the execution of the ASSERT statement when the value of the key for the unique index is abnormally large is fixed.
    • The bug that prevents the COM_DAEMON process from stopping is fixed.
    • The bug that causes a cache overflow when Full-Text Search (FTS)-based queries are run is fixed.
    • The bug that errors in a rollback when instant DDL operations become abnormal is fixed.
20200831
  • New features:
    • The innodb_parallel_read_threads parameter is added to specify whether to allow the count(*) function to run scans in parallel. If this parameter is set to 0, this function cannot run scans in parallel. For more information, see Reconfigure the parameters of an ApsaraDB RDS for MySQL instance.
    • Start global transaction identifiers (GTIDs) and end GTIDs are supported by the mysqlbinlog plug-in.
    • Log sequence numbers (LSNs) are supported in the redo log.
      • innodb_lsn: the LSN of each record in the redo log.
      • innodb_log_checkpoint_lsn: the LSN of the last checkpoint.
      • innodb_log_write_lsn: the LSN of each record that is written to the redo log.
      • innodb_log_ready_for_write_lsn: the LSN of the last record that is written to the log buffer.
      • innodb_log_flush_lsn: the LSN of each record that is flushed from the redo log to the disk.
      • innodb_log_dirty_pages_added_up_to_lsn: the LSN of each record that logs a page as dirty.
      • innodb_log_oldest_lsn: the LSN of each record that logs an update to a page.
  • Performance improvements:
    • The CCL feature is optimized to schedule and concurrently run transactions in a more efficient manner.
    • The CCL feature is optimized to prioritize stored procedures in a more efficient manner.
  • Bug fixes:
    • The bug that prevents the recursively called interpreter from checking the memory size is fixed.
    • The bug that prevents table definitions from being modified when Transparent Data Encryption (TDE) is enabled is fixed.
    • The bug that causes memory leaks for the event scheduler is fixed.
20200630
  • New features:
    • The faster DDL feature is supported. This feature provides an optimized buffer pool management mechanism to reduce the impact of DDL operations on database performance and increase the number of online DDL operations that can be concurrently run. For more information, see Faster DDL.
    • The maximum number of connections that are allowed is increased to 500,000.
  • Performance improvements:
    • The thread pool feature is optimized.
    • The memory allocation mechanism is optimized. Users can specify the maximum memory consumption that is allowed for PERFORMANCE SCHEMA based on the instance type.
    • Audit log files are no longer analyzed.
    • TDE is optimized to cache the keys that are provided by Key Management Service (KMS).
    • The statuses of threads that are managed by the CCL feature are modified. For more information, see Statement concurrency control.
  • Bug fixes:
    • The bug due to which ApsaraDB RDS considers semicolons (;) as part of the statements that are used to create database outlines is fixed.
    • The bug due to which an RDS instance unexpectedly exits when tables are modified is fixed.
    • The bug due to which earlier versions do not support the keywords memory and array that are supported in later versions is fixed.
    • The bug due to which ApsaraDB RDS incorrectly counts the number of waits when commands are read from a database client is fixed.
    • The bug that causes failures in the updates of minor engine versions is fixed.
20200430
  • New features:
    • The Binlog in Redo feature is supported. This feature allows ApsaraDB RDS to write binary log records to the redo log before the binary log records are flushed to the disk. This way, this feature helps reduce the consumption of I/O resources and improve database performance. For more information, see Binlog in Redo.
    • A restructured row caching mechanism is supported for X-Engine.
    • The XA_RECOVER_ADMIN permission is provided.
  • Performance improvements:
    • The code that is used to scan data when operations are performed on a temporary InnoDB table is optimized. This allows ApsaraDB RDS to scan only dirty pages rather than all pages in the buffer pool.
    • The global parameter opt_readonly_trans_implicit_commit is renamed as rds_disable_explicit_trans to ensure compatibility with MySQL 5.6.
    • The upgrades to an RDS instance are no longer logged.
    • The memory resources that are consumed by the DDL operations on X-Engine tables are reduced.
  • Bug fixes:
    • The bug due to which the sizes of X-Engine tables on the disk are inconsistent with the statistics in the INFORMATION_SCHEMA database is fixed.
    • The bug due to which ApsaraDB RDS initializes X-Engine logs when the error log file is re-opened is fixed.
20200331
  • New features:

    The TRUNCATE TABLE statement is supported. After the statement is executed on a table, the table is moved to a dedicated directory that is used for the recycle bin. Then, a table that uses the same schema as the truncated table is created. For more information, see Recycle bin.

  • Performance improvements:
    • The output of TCP errors is disabled by default.
    • The thread pool feature is optimized to provide higher performance when the default configurations are used.
  • Bug fixes:
    • The bug that causes invalid databases and tables is fixed. This bug is triggered when the names of partitioned tables are separated by the combination of a pound key and a letter p (#p).
    • The bug due to which the CCL-managed statements are case-sensitive is fixed.
  • The changes to the features in open source MySQL 8.0.17 and MySQL 8.0.18 are incorporated. For more information, see Changes in MySQL 8.0.17 and Changes in MySQL 8.0.18.
20200229
  • New features:
    • The performance agent feature is supported. For more information, see Performance Agent. This feature is provided as a MySQL plug-in. This feature allows ApsaraDB RDS to compute and analyze the metrics that are used to measure the performance of an RDS instance.
    • A metric is provided to measure the round trip time over the network. This metric helps users monitor the performance of an RDS instance that runs in semi-synchronous mode.
    • Online DDL operations are supported by X-Engine.
  • Performance improvements:
    • The CCL feature is optimized to control the concurrency of statements on read-only RDS instances.
    • The database outline feature is optimized to support database outlines on secondary RDS instances.
    • The database proxy feature is enhanced to optimize short-lived connections.
    • The amount of time that is required to execute the PAUSE statement is reduced in various CPU architectures.
    • A memory summary table is added to provide the statuses of thread pools.
  • Bug fixes:
    • The bug due to which ApsaraDB RDS forbids the ppoll function and replaces the ppoll function with the poll function is fixed. This bug is found in Linux kernels whose versions are earlier than 4.9.
    • The bug that causes errors when the wrap_sm4_encrypt function is invoked is fixed.
    • The bug due to which ApsaraDB RDS locks global variables during the rotation of audit logs is fixed.
    • The bug that causes errors during restoration inconsistency checks is fixed.
    • The bug that causes inaccurate time values in the io_statistics table is fixed.
    • The bug due to which an RDS instance unexpectedly exits when invalid compression algorithms are used is fixed.
    • The bug that causes user columns in MySQL 8.0 and MySQL 5.6 to be incompatible is fixed.
  • Optimized programs:
    • The faster DDL feature is supported. This feature provides an optimized buffer pool management mechanism to reduce the impact of DDL operations on database performance and increase the number of online DDL operations that can be concurrently run. For more information, see Faster DDL.
    • The thread pool feature is optimized to improve database performance.
    • The mechanism that is used for reference counting is optimized to prevent memory leaks in buffers.
20200110
  • New features:

    Three hints are added. These hints can be used in the following statements to commit transactions and roll transactions back at high speeds: SELECT, UPDATE, INSERT, and DELETE. This increases the throughput of applications. For more information, see Inventory Hint.

  • Performance improvements:
    • The CCL feature is optimized. When an RDS instance starts, CCL queue structures are initialized before CCL rules are initialized.
    • The file deletion mechanism is optimized. When ApsaraDB RDS asynchronously deletes files, the links to small files are removed.
    • The thread pool feature is optimized. For more information, see Thread Pool.
    • The restoration inconsistency check feature is disabled by default.
    • The permissions that are required to configure variables are changed.
      • The permissions to configure the following variables are changed to the permissions of standard accounts:
        • auto_increment_increment
        • auto_increment_offset
        • bulk_insert_buffer_size
        • binlog_rows_query_log_events
      • The permissions to configure the following variables are changed to the permissions of superuser accounts or system variable administrators:
        • binlog_format
        • binlog_row_image
        • binlog_direct
        • sql_log_off
        • sql_log_bin
20191225
  • New features:

    The recycle bin feature is supported. All tables that users delete are moved to the recycle bin. Users can specify a retention period within which they can retrieve tables from the recycle bin. For more information, see Recycle bin.

  • Performance improvements:
    • The mechanism that is used to process short-lived connections is optimized.
    • A dedicated thread is used for the maintain_user variable. This prevents high-availability failures.
    • The locking mechanism is optimized. If an error occurs when the redo mechanism is used to flush binary log records, ApsaraDB RDS can explicitly release the locks that are triggered by file synchronization.
    • Unnecessary TCP error logs can be deleted.
    • The thread pool feature is enabled by default.
  • Bug fixes:
    • The bug that causes errors during the updates of slow query logs is fixed.
    • The bug that causes an inappropriate lock scope is fixed.
    • The bug that causes errors in core dumps when the select() function is invoked for TDE is fixed.
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 possible conflicts. For more information, see Statement Queue.

20191101
  • New features:
    • The SM4 encryption algorithm is supported for TDE. For more information, see Configure TDE for an ApsaraDB RDS for MySQL instance.
    • Data protection is supported for secondary RDS instances. Only the accounts that have the SUPER role or the REPLICATION_SLAVE_ADMIN role are granted the permissions to insert, delete, and modify data in the slave_master_info, slave_relay_log_info, and slave_worker_info tables.
    • A mechanism is provided to increase the priorities of auto-increment keys. If a table does not have a primary key or the table does not have a unique key without a null value, the auto-increment key without a null value is assigned the highest priority.
    • A mechanism is provided to prevent the automatic conversion of tables from the MEMORY storage engine to the MyISAM storage engine. These tables include system tables. These tables also include tables that are called by threads in the initializing state.
    • A mechanism is provided to flush binary log records to the disk before redo log records.
    • A mechanism is provided to stop the creation of temporary tables on an RDS instance when the RDS instance is locked.
    • X-Engine is provided to store transactions based on a log-structured merge (LSM) tree.
  • Performance improvements:
    • The thread pool feature is optimized to reduce mutual exclusions (mutexes). For more information, see Thread Pool.
    • The performance insight feature is optimized to monitor thread pools. For more information, see Performance Insight.
    • Adjusted parameters:
      • primary_fast_lookup: a session parameter. Default value: true.
      • thread_pool_enabled: a global parameter. Default value: true.
20191015
  • New features:
    • The TDE feature is provided to support real-time I/O encryption and decryption of data files. This feature encrypts data before the data is written to the disk and decrypts data before the data is read from the disk to the memory. For more information, see Configure TDE for an ApsaraDB RDS for MySQL instance.
    • The returning feature is provided. This feature allows DML statements to return result sets. The DBMS_TRANS package is provided for users to use this feature with ease. For more information, see Returning.
    • The forced conversion from the MyISAM or MEMORY storage engine to the InnoDB storage engine is supported. If the global variable force_mysiam_to_innodb or force_memory_to_innodb is set to ON, tables are automatically converted from the MyISAM or MEMORY storage engine to the InnoDB storage engine when the tables are created or modified.
    • A mechanism is provided to prevent standard accounts from performing primary/secondary switchovers. Only privileged accounts are granted the permissions to perform primary/secondary switchovers.
    • A performance proxy plug-in is provided. This plug-in obtains performance data and saves the data as TXT files to on-premises computers. A round-robin algorithm is used to ensure that only the most recent files at the single-digit second level are retained.
    • A timeout period can be configured for mutexes in InnoDB. Users can change the timeout period by using the global variable innodb_fatal_semaphore_wait_threshold. The default value of the global variable is 600.
    • Index hint errors can be ignored. Users can configure an RDS instance to ignore index hint errors by using the global variable ignore_index_hint_error. The default value of the global variable is false.
    • The SSL encryption feature can be disabled. For more information, see Configure SSL encryption for an ApsaraDB RDS for MySQL instance.
    • The output of TCP errors is supported. TCP read, read-wait, and write-wait errors are returned together with error codes in end_connection events. Log records that contain the information about the errors are also generated.
  • Bug fixes:
    • The bug due to which a Linux operating system cannot merge local asynchronous I/O (AIO) requests before linear Read Ahead is triggered is fixed.
    • The bug due to which ApsaraDB RDS cannot accurately collect table statistics and index statistics is fixed.
    • The bug that prevents direct access to the primary key index of a table when a primary key is specified for the table is fixed.
20190915

Bug fixes:

The bug that causes memory leaks when the Cmd_set_current_connection process runs is fixed.

20190816
  • 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.
    • The CCL feature is supported. Users can specify the maximum number of concurrent requests that are allowed for an RDS instance. This way, the RDS instance can handle traffic bursts, process statements that consume an excessive number of resources, and adapt to the changes in SQL models. The CCL feature helps ensure the continuity and stability of RDS instances. For more information, see Statement concurrency control.
    • The statement outline feature is provided to support optimizer hints and index hints. These hints are used to ensure that ApsaraDB RDS can run query plans in a stable manner. For more information, see Statement outline.
    • The Sequence engine is provided to generate sequence values in a simplified manner. For more information, see Sequence Engine.
    • The Purge Large File Asynchronously feature is provided to asynchronously delete files. Before a tablespace is deleted, ApsaraDB RDS renames the files in the tablespace as temporary files. Then, ApsaraDB RDS starts background threads to asynchronously delete the temporary files. For more information, see Purge Large File Asynchronously.
    • The performance insight feature is provided to support load monitoring, association analysis, and performance optimization at the instance level. This feature allows users to evaluate the loads on an RDS instance and troubleshoot performance issues. This way, the stability of the RDS instance can be ensured. For more information, see Performance Insight.
    • 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.
  • Bug fixes:
    • The bug due to which ApsaraDB RDS incorrectly calculates file sizes is fixed.
    • The bug that allows irrelevant processes to reuse idle memory resources is fixed.
    • The bug due to which a host unexpectedly exits when the available cache size on the host is 0 is fixed.
    • The bug that causes conflicts between implicit primary keys and CTS statements is fixed.
    • The bug due to which ApsaraDB RDS incorrectly generate logs for slow queries is fixed.
20190601
  • Performance improvements:
    • Metadata locking on logging tables is reduced.
    • The code for termination options is restructured.
  • Bug fixes:
    • The bug due to which precompiled statements are not recorded in audit logs is fixed.
    • The bug due to which ApsaraDB RDS cannot mask error log records in logging tables when the names of the logging tables are invalid is fixed.

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
  • New features:

    The TRUNCATE TABLE statement is supported. After the statement is executed on a table, the table is moved to a dedicated directory that is used for the recycle bin. Then, a table that uses the same schema as the truncated table is created. For more information, see Recycle bin.

  • Performance improvements:
    • The output of TCP errors is disabled by default.
    • The thread pool feature is optimized to provide higher performance when the default configurations are used.
  • Bug fixes:
    • The bug that causes invalid databases and tables is fixed. This bug is triggered when the names of partitioned tables are separated by the combination of a pound key and a letter p (#p).
    • The bug due to which the CCL-managed statements are case-sensitive is fixed.
  • The changes to the features in open source MySQL 8.0.17 and MySQL 8.0.18 are incorporated. For more information, see Changes in MySQL 8.0.17 and Changes in MySQL 8.0.18.
20200317
  • New features:
    • The performance agent feature is supported. For more information, see Performance Agent. This feature is provided as a MySQL plug-in. This feature allows ApsaraDB RDS to compute and analyze the metrics that are used to measure the performance of an RDS instance.
    • A metric is provided to measure the round trip time over the network. This metric helps users monitor the performance of an RDS instance that runs in semi-synchronous mode.
  • Performance improvements:
    • The CCL feature is optimized to control the concurrency of statements on read-only RDS instances.
    • The database outline feature is optimized to support database outlines on secondary RDS instances.
    • The database proxy feature is enhanced to optimize short-lived connections.
    • The amount of time that is required to execute the PAUSE statement is reduced in various CPU architectures.
    • A memory summary table is added to provide the statuses of thread pools.
  • Bug fixes:
    • The bug due to which ApsaraDB RDS forbids the ppoll function and replaces the ppoll function with the poll function is fixed. This bug is found in Linux kernels whose versions are earlier than 4.9.
    • The bug that causes errors when the wrap_sm4_encrypt function is invoked is fixed.
    • The bug due to which ApsaraDB RDS locks global variables during the rotation of audit logs is fixed.
    • The bug that causes errors during restoration inconsistency checks is fixed.
    • The bug that causes inaccurate time values in the io_statistics table is fixed.
    • The bug due to which an RDS instance unexpectedly exits when invalid compression algorithms are used is fixed.
    • The bug that causes user columns in MySQL 8.0 and MySQL 5.6 to be incompatible is fixed.
  • Optimized programs:
    • The faster DDL feature is supported. This feature provides an optimized buffer pool management mechanism to reduce the impact of DDL operations on database performance and increase the number of online DDL operations that can be concurrently run. For more information, see Faster DDL.
    • The thread pool feature is optimized to improve database performance.
    • The mechanism that is used for reference counting is optimized to prevent memory leaks in buffers.

MySQL 5.7 on RDS Basic Edition or RDS High-availability Edition

Minor AliSQL version Description
20210630
  • New features:
    • The audit log format MYSQL_V3 is supported.
    • Slow query logs and general logs can be truncated.
    • A mechanism is provided to detect out of memory (OOM) exceptions in the thread stack.
    • The thread_pool_strict_mode parameter is supported. This parameter is used to limit the maximum number of worker threads.
  • Bug fixes:
    • The bug that causes the deletion of outdated socket lock files when the mysqld_safe script is run to start the mysqld process is fixed.
    • The bug that causes memory leaks in the recycle bin is fixed.
Note This minor AliSQL version is not supported by RDS instances that use standard SSDs or enhanced SSDs (ESSDs).
20210430
  • New features:
    • The recycle bin feature is supported. For more information, see Recycle bin
    • The Sequence engine feature is supported. For more information, see Sequence Engine
  • Performance improvements:
    • More metrics that are used to measure the performance of an RDS instance are added to the I_S.PERF_STATISTICS table.
    • The number of index scans is added to the I_S.INDEX_STATISTICS table.
    • The TDE feature is optimized to improve database performance.
  • Bug fixes:

    The bug that causes column generation exceptions during a rollback is fixed. This bug is found in MySQL Community Edition.

20201031

Bug fixes:

  • The bug due to which the ROW_SEARCH_MVCC function unexpectedly exits when concurrent updates are performed is fixed.
  • The bug due to which an RDS instance cannot start when the innodb_undo_tablespaces parameter is reconfigured for the RDS instance is fixed.
  • The bug that causes a cache overflow when FTS-based queries are run is fixed.
20200831
  • New features:
    • The changes to the features in open source MySQL 5.7.30 are incorporated. For more information, visit GitHub.
    • The CCL feature is optimized to schedule and concurrently run transactions in a more efficient manner.
    • Start GTIDs and end GTIDs are supported by the mysqlbinlog plug-in.
    • LSNs are supported in the redo log.
      • innodb_lsn: the LSN of each record in the redo log.
      • innodb_log_write_lsn: the LSN of each record that is written to the redo log.
      • innodb_log_checkpoint_lsn: the LSN of the last checkpoint.
      • innodb_log_flushed_lsn: the LSN of each record that is flushed from the redo log to the disk.
      • innodb_log_Pages_flushed: the LSN of each record that logs an update to a page.
  • Performance improvements:

    The CCL feature is optimized to prioritize stored procedures in a more efficient manner.

  • Bug fixes:

    The bug due to which an RDS instance may incorrectly count the number of pages that are referenced from temporary tables is fixed. This bug may cause inefficient flushing of dirty blocks from the buffer pool to the disk. As a result, no idle pages are available in the buffer pool, and database performance deteriorates. For more information, see the official MySQL documentation.

20200630
  • New features:
    • Three hints are added. These hints can be used in the following statements to commit transactions and roll transactions back at high speeds: SELECT, UPDATE, INSERT, and DELETE. This increases the throughput of applications. For more information, see Inventory Hint.
    • The CCL feature is supported. Users can specify the maximum number of concurrent requests that are allowed for an RDS instance. This way, the RDS instance can handle traffic bursts, process statements that consume an excessive number of resources, and adapt to the changes in SQL models. The CCL feature helps ensure the continuity and stability of RDS instances. For more information, see Statement concurrency control.
    • 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 possible conflicts. For more information, see Statement Queue.
    • The statement outline feature is provided to support optimizer hints and index hints. These hints are used to ensure that ApsaraDB RDS can run query plans in a stable manner. For more information, see Statement outline.
    • The faster DDL feature is supported. This feature provides an optimized buffer pool management mechanism to reduce the impact of DDL operations on database performance and increase the number of online DDL operations that can be concurrently run. For more information, see Faster DDL.
    • The maximum number of connections that are allowed is increased to 500,000.
  • Performance improvements:
    • The call dbms_admin.show_native_procedure(); command is provided to display all procedures of an RDS instance.
    • A function is provided to delete orphan tables.
    • The thread pool feature is optimized.
    • Query caching is optimized.
    • The memory allocation mechanism is optimized. Users can specify the maximum memory consumption that is allowed for PERFORMANCE SCHEMA based on the instance type.
  • Bug fixes:

    The bug due to which an audit update thread enters an infinite loop is fixed.

20200430
  • Performance improvements:

    Read-write locks are no longer supported in the query cache. The default hash function is changed from LF_hash to murmur3 hash.

  • Bug fixes:

    Two bugs that occur when ApsaraDB RDS hits the requested data in the query cache are fixed. These bugs are triggered if transactions at the REPEATABLE_READ isolation level are run.

20200331
  • New features:
    • The fast query cache is supported. The fast query cache is developed by Alibaba Cloud based on the native MySQL query cache. The fast query cache uses an updated design and an updated query mechanism to improve query performance. For more information, see Fast query cache.
    • Two metadata locks from Percona Server 5.7 are supported: LOCK TABLES FOR BACKUP (LTFB) and LOCK BINLOG FOR BACKUP (LBFB).
  • Performance improvements:
    • The thread pool feature is optimized to ensure compatibility with earlier MySQL versions.
    • The output of TCP errors is disabled by default.
    • The thread pool feature is optimized to provide higher performance when the default configurations are used.
  • Bug fixes:
    • The bug due to which ApsaraDB RDS deletes temporary files when large files are deleted is fixed.
    • The bug due to which dump threads in thread pools time out is fixed.
    • The bug due to which ApsaraDB RDS incorrectly counts the value of the IPK field in the procedure context is fixed.
    • The bug that causes the leak and release of PFS threads when the rds_change_user command is run is fixed.
  • The changes to the features in open source MySQL 5.7.28 are incorporated. For more information, visit GitHub.
20200229
  • New features:
    • The performance agent feature is supported. For more information, see Performance Agent. This feature is provided as a MySQL plug-in. This feature allows ApsaraDB RDS to compute and analyze the metrics that are used to measure the performance of an RDS instance.
    • A metric is provided to measure the round trip time over the network. This metric helps users monitor the performance of an RDS instance that runs in semi-synchronous mode.
  • Performance improvements:
    • The amount of time that is required to execute the PAUSE statement is reduced in various CPU architectures.
    • The database proxy feature is enhanced to optimize short-lived connections.
    • A memory summary table is added to provide the statuses of thread pools.
  • Bug fixes:
    • The bug that compromises the security of DDL-related redo log records is fixed.
    • The bug that causes inaccurate time values in the io_statistics table is fixed.
    • The bug due to which an RDS instance unexpectedly exits when tables are modified is fixed.
    • The bugs in MySQL test cases are fixed.
20200110

Performance improvements:

  • The file deletion mechanism is optimized. When ApsaraDB RDS asynchronously deletes files, the links to small files are removed.
  • The thread pool feature is optimized. For more information, see Thread Pool.
  • The default value of the thread_pool_enabled parameter is changed to OFF.
20191225
  • New features:

    The management of internal accounts is supported. This allows users to manage permissions and protect data in a more efficient manner.

  • Performance improvements:
    • The mechanism that is used to process short-lived connections is optimized.
    • A dedicated thread is used for the maintain_user variable. This prevents high-availability failures.
    • Unnecessary TCP error logs can be deleted.
    • The thread pool feature is optimized.
  • Bug fixes:
    • The bug due to which the mysqld process unexpectedly exits when the read/write splitting feature is enabled is fixed.
    • The bug that causes errors in core dumps when a keyring is used is fixed.
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
  • New features:
    • The SM4 encryption algorithm is supported by TDE. For more information, see Configure TDE for an ApsaraDB RDS for MySQL instance.
    • The bug that prevents direct access to the primary key index of a table when a primary key is specified for the table is fixed.
    • A mechanism is provided to prevent the automatic conversion of tables from the MEMORY storage engine to the MyISAM storage engine. These tables include system tables. These tables also include tables that are called by threads in the initializing state.
  • Performance improvements:
    • The thread pool feature is optimized to reduce mutexes. For more information, see Thread Pool.
    • An audit log caching mechanism is provided to improve logging performance.
    • The performance insight feature is optimized to monitor thread pools. For more information, see Performance Insight.
    • The thread pool feature is enabled by default. For more information, see Thread Pool.
  • Bug fixes:
    • The bug that causes the release of locks on user tables when the user tables are being managed or maintained is fixed.
    • More TCP errors are added.
20191015
  • New features:
    • The rotation of slow query logs is supported. Each CSV slow query log file is assigned a unique name and saved as a new file. This prevents data loss during the collection of slow query logs. Users can run the show variables like '%rotate_log_table%'; command to check whether the rotation of slow query logs is enabled.
    • A performance proxy plug-in is provided. This plug-in obtains performance data and saves the data as TXT files to on-premises computers. A round-robin algorithm is used to ensure that only the most recent files at the single-digit second level are retained.
    • The forced conversion from the MEMORY storage engine to the InnoDB storage engine is supported. If the global variable rds_force_memory_to_innodb is set to ON, tables are automatically converted from the MEMORY storage engine to the InnoDB storage engine when the tables are created or modified.
    • The keyring-rds plug-in is supported for TDE. This plug-in allows ApsaraDB RDS to communicate with the administration system or KMS.
    • The output of TCP errors is supported. TCP read, read-wait, and write-wait errors are returned together with error codes in end_connection events. Log records that contain the information about the errors are also generated.
  • Bug fixes:

    The bug that causes error 1290 in DDL operations is fixed.

20190925

Adjusted parameters:

  • The default value of the system variable auto_generate_certs is changed from true to false.
  • The global read-only variable auto_detact_certs is supported. Valid values: true and false. Default value: false. This variable is supported for an RDS instance only when OpenSSL is used to compile code on the RDS instance. This variable specifies whether the RDS instance automatically searches for SSL certificate files and key files in the data directory of the host on which the RDS instance resides.
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
  • New features:
    • The Purge Large File Asynchronously feature is provided to asynchronously delete files. Before a tablespace is deleted, ApsaraDB RDS renames the files in the tablespace as temporary files. Then, ApsaraDB RDS starts background threads to asynchronously delete the temporary files. For more information, see Purge Large File Asynchronously.
    • The performance insight feature is provided to support load monitoring, association analysis, and performance optimization at the instance level. This feature helps users evaluate the loads on an RDS instance and troubleshoot performance issues. This way, the stability of the RDS instance can be ensured. For more information, see Performance Insight.
    • 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.
  • Bug fixes:
    • The bug that allows users to set the rds_prepare_begin_id parameter in the set rds_current_connection command is fixed.
    • The bug due to which ApsaraDB RDS cannot update the information about locked accounts is fixed.
    • The bug due to which actual can be used as a keyword in table names is fixed.
    • The bug that causes an overflow of timestamps in slow query logs is fixed.
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
  • Performance improvements:
    • The upgrade to MySQL 5.7.25 is supported.
    • JeMalloc that is used for memory management is disabled.
  • Bug fixes:

    The bug due to which ApsaraDB RDS incorrectly calculates the value of the internal variable net_lenth_size is fixed.

20181226
  • New features:

    Dynamic modifications to the system variable binlog-row-event-max-size are supported. This accelerates the replication of tables that do not have a primary key.

  • Bug fixes:

    The bug due to which the proxy instances of an RDS instance cannot apply for memory resources is fixed.

20181010

Performance improvements:

  • Implicit primary keys are supported.
  • The replication of tables that do not have a primary key between a primary RDS instance and its secondary RDS instance is accelerated.
  • Native AIO is provided to improve I/O performance.
20180431

New features:

  • RDS High-availability Edition is supported.
  • The SQL Audit feature is supported. For more information, see SQL audit.
  • The protection for RDS instances on which snapshot backups are being created is enhanced.

MySQL 5.7 on RDS Enterprise Edition

Minor AliSQL version Description
20201229 Bug fixes:
  • The bug due to which an RDS instance unexpectedly exits or is unexpectedly stuck is fixed.
  • The bug due to which prefix indexes are considered as invisible indexes is fixed.
  • The bug due to which a logger RDS instance is in an abnormal state based on the consensus protocol is fixed. If this bug persists, ApsaraDB RDS may fail to correctly elect an RDS instance as the primary RDS instance.
20191128
  • New features:

    The read/write splitting feature is supported.

  • Bug fixes:
    • The bug due to which ApsaraDB RDS incorrectly calculates the value of the Second_Behind_Master metric for a follower is fixed.
    • The bug that causes deadlocks when users run specific table-level parallel replication transactions again is fixed.
    • XA-related bugs are fixed.
20191016
  • New features:
    • The upgrade from RDS High-availability Edition to RDS Enterprise Edition is supported for RDS instances that use local SSDs.
    • GTIDs that are provided by open source MySQL are supported. GTIDs are disabled by default.
    • All proprietary AliSQL features that are released by Alibaba Cloud for RDS Basic Edition and RDS High-availability Edition in 20190915 and earlier minor engine versions are incorporated.
  • Bug fixes:

    The bug due to which binary logs are disabled for a primary RDS instance when the secondary RDS instance of the primary RDS instance is reset is fixed.

20190909
  • New features:
    • A mechanism is provided to ensure that large transactions are run at high speeds. This mechanism is supported when data is replicated between a primary RDS instance and its secondary RDS instance in synchronous mode.
    • Binary log records can be dumped from a leader or a follower.
    • Read-only RDS instances can be created.
    • The InnoDB storage engine is used for system tables by default.
  • Bug fixes:
    • The bug that invalidates the commands that are run by a follower to delete logs is fixed.
    • The bug due to which slave threads unexpectedly exit is fixed. This bug is triggered when the slave_sql_verify_checksum parameter is set to OFF and the binlog_checksum parameter is set to crc32.
20190709

New features:

  • RDS Enterprise Edition is supported.
  • The semi-sync plug-in can be disabled.
  • Table-level parallel replication and write set-level parallel replication are supported.
  • The pk_access module is provided to accelerate queries that are run based on primary keys.
  • The thread pool feature is supported.
  • All proprietary AliSQL features that are released by Alibaba Cloud for RDS Basic Edition and RDS High-availability Edition in 20190510 and earlier minor engine versions are incorporated.

MySQL 5.6

Minor AliSQL version Description
20210630
  • New features:

    A mechanism is provided to detect OOM exceptions in the thread stack.

  • Bug fixes:
    • The bugs in MySQL 5.6 Community Edition are fixed.
    • The operation limits on the SHOW CREATE statement in the mysql system database are removed.
20210430
  • Performance improvements:

    More metrics that are used to measure the performance of an RDS instance are added to the I_S.PERF_STATISTICS table.

  • Bug fixes:

    The bugs that cause memory leaks in MySQL Community Edition are fixed.

20201031 Bug fixes:
  • The bug that invalidates the subqueries that are nested in IN clauses is fixed.
  • The bug that causes errors in the permissions on processes is fixed.
  • The bug that causes errors in the permissions of users in the kill_user_list table is fixed.
  • The bug that causes errors during the execution of the DROP DATABASE statement is fixed.
  • The bug due to which ApsaraDB RDS incorrectly calculates the value of the SECONDS_BEHIND_MASTER parameter due to PREVIOUS_GTID events is fixed.
20200831
  • New features:

    LSNs are supported in the redo log.

    • innodb_lsn: the LSN of each record in the redo log.
    • innodb_log_write_lsn: the LSN of each record that is written to the redo log.
    • innodb_log_checkpoint_lsn: the LSN of the last checkpoint.
    • innodb_log_flushed_lsn: the LSN of each record that is flushed from the redo log to the disk.
    • innodb_log_Pages_flushed: the LSN of each record that logs an update to a page.
  • Bug fixes:
    • The bug due to which the SHOW_HA_ROWS statement returns invalid enumeration types is fixed.
    • The bug due to which ApsaraDB RDS incorrectly counts the value of the IPK field in the procedure context is fixed.
    • The bug due to which an RDS instance unexpectedly exits when data is queried from the INFORMATION_SCHEMA database is fixed.
    • The bug due to which an audit update thread enters an infinite loop is fixed.
    • The bug due to which secondary RDS instances cannot report data replication latencies is fixed.
20200630
  • New features:
    • The performance agent feature is supported. For more information, see Performance Agent. This feature is provided as a MySQL plug-in. This feature allows ApsaraDB RDS to compute and analyze the metrics that are used to measure the performance of an RDS instance.
    • The maximum number of connections that are allowed is increased to 500,000.
    • The faster DDL feature is supported. This feature provides an optimized buffer pool management mechanism to reduce the impact of DDL operations on database performance and increase the number of online DDL operations that can be concurrently run. For more information, see Faster DDL.
  • Performance improvements:
    • The global parameter max_execution_time is supported. If the amount of time that is required to execute an SQL statement exceeds the value of this parameter, the SQL statement is paused.
    • The thread pool feature is optimized.
  • Bug fixes:
    • The bug due to which ApsaraDB RDS incorrectly counts the number of waits when commands are read from a database client is fixed.
    • The bug due to which standard accounts cannot be granted the permissions to execute the DROP DATABASE statement is fixed.
20200430
  • New features:

    The mdl_info table is provided to store the information about metadata locks.

  • Bug fixes:

    The bug that causes conflicts between the thread pool feature and the ic_reduce feature is fixed.

20200331

Performance improvements:

  • The thread pool feature is optimized to provide higher performance when the default configurations are used.
  • The output of TCP errors is disabled by default.
20200229
  • New features:

    The read/write splitting feature is supported for database proxies.

  • Performance improvements:
    • The thread pool feature is optimized.
    • The amount of time that is required to execute the PAUSE statement is reduced in various CPU architectures.
  • Bug fixes:

    The bug due to which ApsaraDB RDS partially commits XA transactions is fixed.

20200110
  • 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.

  • Performance improvements:

    The file deletion mechanism is optimized. When ApsaraDB RDS asynchronously deletes files, the links to small files are removed.

  • Bug fixes:
    • The bug due to which ApsaraDB RDS incorrectly calculates the sleep time of the page cleaner is fixed.
    • The bug due to which the SELECT @@global.gtid_executed statement triggers failover failures is fixed.
    • The bug that causes the "IF CLIENT KILLED AFTER ROLLBACK TO SAVEPOINT PREVIOUS STMTS COMMITTED" error is fixed. For more information, see IF CLIENT KILLED AFTER ROLLBACK TO SAVEPOINT PREVIOUS STMTS COMMITTED.
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:
  • The bug due to which ApsaraDB RDS rotates slow query logs when common logs are updated is fixed.
  • Some display-related bugs are fixed.
20191015
  • New features:
    • The rotation of slow query logs is supported. Each CSV slow query log file is assigned a unique name and saved as a new file. This prevents data loss during the collection of slow query logs. Users can run the show variables like '%rotate_log_table%'; command to check whether the rotation of slow query logs is enabled.
    • A new SM4 encryption algorithm is provided to replace the previously used SM4 encryption algorithm.
    • The Purge Large File Asynchronously feature is provided to asynchronously delete files. Before a tablespace is deleted, ApsaraDB RDS renames the files in the tablespace as temporary files. Then, ApsaraDB RDS starts background threads to asynchronously delete the temporary files. For more information, see Purge Large File Asynchronously.
    • The output of TCP errors is supported. TCP read, read-wait, and write-wait errors are returned together with error codes in end_connection events. Log records that contain the information about the errors are also generated.
    • An audit log caching mechanism is provided to improve logging performance.
  • Bug fixes:
    • The bug that prevents responses to the pstack command when a large number of connections are established is fixed after the pstack command is disabled.
    • The bug that causes conflicts between implicit primary keys and the CREATE TABLE AS SELECT statement is fixed.
    • The bug due to which ApsaraDB RDS cannot delete temporary files is fixed. These temporary files are created from binary log files.
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
  • New features:

    Invisible indexes are supported. For more information, see AliSQL 5.6.32 Release Notes (2017-07-16).

  • Bug fixes:
    • The bug due to which ApsaraDB RDS applies threads on secondary RDS instances is fixed.
    • The bug that compromises database performance when the updates to partitioned tables are applied on secondary RDS instances is fixed.
    • The bug due to which TokuDB rebuilds tables when the ALTER TABLE COMMENT statement is executed on these tables is fixed. For more information, see AliSQL 5.6.32 Release Note (2018-05-01).
    • The bug that causes deadlocks when the SHOW SLAVE STATUS statement or the SHOW STATUS statement is executed is fixed.
20171205 Bug fixes:
  • The bug that causes deadlocks when the OPTIMIZE TABLE statement and the ONLINE ALTER TABLE statement are executed at the same time is fixed.
  • The bug that causes conflicts between sequences and implicit primary keys is fixed.
  • The bug due to which ApsaraDB RDS cannot execute the SHOW CREATE SEQUENCE statement with no errors is fixed.
  • The bug due to which ApsaraDB RDS cannot accurately collect statistics about TokuDB tables is fixed.
  • The bug that causes deadlocks when the OPTIMIZE statement is executed on multiple tables in parallel is fixed.
  • The bug due to which ApsaraDB RDS cannot accurately record character sets in QUERY_LOG_EVENT is fixed.
  • The bug due to which an RDS instance cannot stop if signal processing errors occur is fixed. For more information, see AliSQL 5.6.32 Release Notes (2017-10-10).
  • The bug that is caused by the RESET MASTER statement is fixed.
  • The bug due to which secondary RDS instances are stuck in the waiting state is fixed.
  • The bug due to which the statuses of a primary RDS instance and its secondary RDS instance are incorrect after a primary/secondary switchover when these instances run RDS Enterprise Edition is fixed.
  • The bug due to which the database process may unexpectedly exit when the SHOW CREATE TABLE statement is executed is fixed.
20170927 Bug fixes:

The bug due to which ApsaraDB RDS queries TokuDB tables based on inappropriate indexes is fixed.

20170901
  • New features:
  • Bug fixes:

    The bug due to which ApsaraDB RDS returns an inaccurate result set for a NOT IN query is fixed.

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 gettimeofday(2) function returns an inaccurate time value is fixed. The returned time value is used to calculate the timeout period. If the time value that is returned is inaccurate, some operations never time out.