ApsaraDB RDS:AliSQL kernel minor version release notes

Minor version

Community version

Description

Expiration date

20251130

8.0.36

• New features

  • Updates jemalloc to version 5.3.

  • Adds a CPU time consumption metric to audit logs.

• Performance optimizations

  • Optimizes the transmission efficiency of I/O threads. This improves the performance of semi-synchronous replication and the replication efficiency of secondary databases in high-concurrency scenarios.

  • Optimizes the application efficiency of SQL threads. This improves the replication efficiency of secondary databases when medium and small transactions are combined.

• Bug fixes

  • Fixes issues in vector indexes, such as memory leaks and DDL deadlocks.

  • Fixes a crash issue that occurs during data archiving operations.

--

20251031

8.0.36

• New features

  • Adds vector capabilities. This includes a new vector column type, vector operation functions, and support for creating vector indexes on vector columns.

  • Supports instantly changing the length of INT, VARCHAR, and CHAR data types (instant column modification).

  • Supports the DDL throttling feature.

  • Supports `optimize table` for real-time DDL application.

  • Supports setting `require_row_format` for real-time transmission.

  • Adds the `cost_threshold_for_duckdb` parameter. If the cost estimation of an SQL command by the optimizer exceeds this threshold, an error is reported.

• Performance optimizations

  • Optimizes the transmission efficiency of I/O threads. This improves the performance of semi-synchronous replication and the replication efficiency of secondary databases in high-concurrency scenarios.

  • Supports redo compression for BLOB fields to improve BLOB write performance.

• Bug fixes

  • Fixes an issue that causes single-statement transaction SBM spikes.

  • Fixes an issue where purging relay logs slows down acknowledgments in semi-synchronous replication.

  • Fixes a crash issue that may occur when you concurrently execute a DDL statement while updating a table with foreign keys.

  • Fixes a replication interruption issue in native replication scenarios that is caused by granting the SUPER permission. After the fix, only the permissions owned by the replication thread are granted.

  • Fixes an issue where a NULL value in a JSON column causes a prepared statement to report an unexpected error.

  • Fixes a performance issue caused by clearing the writeset.

--

20250731

8.0.36

• New features

  • Adds the real-time DDL application feature.

  • Supports online extension of the length of INT, VARCHAR, and CHAR data types.

• Performance optimizations

  • Optimizes the write performance for large objects.

• Bug fixes

  • Fixes an issue where implicit primary keys cannot be queried from `information_schema.columns` after an upgrade from an earlier version.

  • Fixes an issue where log records are unexpected when `innodb_log_optimize_ddl` is set to OFF during index creation.

  • Fixes community Bug #118476. This resolves an issue where partitions cannot be created with certain identifiers.

  • Fixes community Bug #118872. This resolves an issue where the `Innodb_data_written` statistic is inaccurate.

  • Fixes community Bug #105652. This resolves an abnormal issue during the crash recovery process for large tables that exceed 32 TB.

  • Fixes community Bug #117275. This resolves an issue where using a descending primary key index with `index_merge` might lead to incorrect query results.

--

20250531

8.0.36

• New features

  • Updates the CURL version to 8.14.1.

  • Supports real-time transmission to secondary databases during the execution of large transactions. This avoids performance fluctuations caused by committing large transactions on semi-synchronous replication instances.

  • Supports new hint syntax (WAIT N and NO_WAIT). You can use hints to set the metadata lock wait time for DML and DDL statements.

  • Supports nonblocking DDL statements to prevent DML statements from being blocked due to a timeout in acquiring a metadata lock during DDL execution.

  • Supports viewing the execution status of DDL statements and the status of metadata locks through a lightweight performance_schema.

  • Supports fast parsing of row records for tables that have not undergone an INSTANT DDL operation.

  • Supports enabling Binlog in redo and Binlog Parallel Flush in semi-synchronous replication mode.

  • Supports recording the end time of an SQL statement in the start_time field of the slow query log.

  • Adds a performance optimization feature for updating hot rows.

  • Optimizes the issue where a DDL statement fails due to a unique key conflict during its execution.

  • Adds the number of active transactions and the average transaction execution time to Innodb status.

• Performance optimizations

  • Improves the performance of scanning primary keys, sorting, and index building during DDL execution.

  • Improves the parsing performance of the utf8mb3 character set.

• Bug fixes

  • Fixes an issue where the reset slave all command executes slowly.

  • Fixes an issue where the binlog_transaction_compression_level_zstd parameter does not take effect.

  • Fixes a crash issue caused by updating a table with an instant drop column.

  • Fixed an issue where a replication interruption could occur in the writeset foreign key feature when an INSERT statement does not specify a value for an auto-increment column.

  • Fixes an issue where a major version upgrade takes a long time when the general log is enabled.

  • Fixes an issue where Hash Anti Join may produce incorrect results if the join_buffer_size is small.

  • Fixes an issue where optimize table does not update the table status.

  • Fixes an issue where the statement id overflows.

  • Fixes a crash issue with the SEQUENCE engine.

--

20241231

8.0.36

• New features

  • Updates the CURL version to 8.11.1.

  • The column encryption feature now supports key management through Key Management Service (KMS).

  • The column encryption feature now supports the AES 256 algorithm.

• Performance optimizations

  • Supports enabling multi-threaded parallel replay of Redo Logs during instance crash recovery to speed up instance startup.

• Bug fixes

  • Fixes an issue where a rename operation causes an incorrect table status.

  • Corrects an issue where the server ID is incorrect in the error log.

  • Fixes an issue where the start_time field is inaccurate when a stored procedure call is recorded in the slow query log.

  • Resolves an issue where undo tablespace information is displayed inaccurately in information_schema.files after a MySQL restart.

  • Fixes an issue where automatic truncation of the undo tablespace fails upon MySQL restart.

  • Fixes an issue where error logs related to routines, events, and triggers are missing during a major version upgrade.

  • Resolves a memory leak issue that exists during a major version upgrade.

  • Fixes an issue where garbled characters are not checked when creating or modifying events and triggers.

--

20241130

8.0.36

• New features

  • Updates the OpenSSL version to 3.0.15.

  • Updates the curl version to 8.9.1.

• Performance optimizations

  • Optimizes the slow automatic repair of the General Query Log to reduce instance RTO.

  • Optimizes the Double Write recovery process to reduce instance RTO. For more information, see Community Bug #116209.

• Bug fixes

  • Fixes a crash issue caused by OSS archived tables.

  • Fixes a ciphertext collision issue in EncDB column encryption.

  • Fixes an issue where a binary log is recorded even if an `Optimize` operation fails.

  • Fixes Community Bug #96236. This resolves an issue where an internal temporary table exhausts the buffer pool, causing the instance to become unavailable.

  • Fixes a potential instance crash issue when canceling a buffer pool scale-in.

  • Fixes a crash or incorrect query result issue caused by referencing a CTE column in multiple query blocks and materializing the CTE table.

  • Fixes a crash issue that occurs when a view definition contains a subquery and the definer does not exist or has insufficient permissions.

  • Fixes a potential crash issue when using multi-valued indexes.

  • Fixes a crash issue when calculating ranking in fts.

--

20241031

8.0.36

• Bug fixes

  • Fixes Community Bug#115608. This resolves a data loss issue that occurs during an INPLACE DDL process.

--

20240930

8.0.36

• New features

  • Adds the innodb_instant_ddl_enabled parameter to control whether to enable instant DDL.

• Bug fixes

  • Resolves an instance crash issue caused by an Update operation on a column added by an Instant DDL statement.

  • Resolves an instance crash issue caused by a Delete or Update operation on a column deleted by an Instant DDL statement.

--

20240731

8.0.36

• New features

  • Allows user Binlog Dump threads to skip Empty Events generated by the Binlog Cache Free Flush feature.

• Performance optimizations

  • Optimizes the GTID allocation process to improve performance in high-concurrency scenarios.

  • Fixes a performance issue with MD5 calculation in high-concurrency scenarios.

  • Optimizes an issue where automatic repair of the General Query Log makes the instance unreachable.

  • Optimizes the retrieval and validation of tablespace metadata during instance startup to improve the startup speed for instances with many tables.

  • Optimizes the lock holding time for `DROP TABLE` and `TRUNCATE TABLE`. Adds the `innodb_rds_drop_ahi_ahead` parameter. When enabled, this parameter deletes the adaptive hash index built for a table before dropping or truncating the InnoDB table. This shortens the holding time of the InnoDB metadata lock during the execution of `DROP TABLE` and `TRUNCATE TABLE` statements, preventing other SQL statements from being blocked.

• Bug fixes

  • Fixes a crash issue when creating a full-text index with a parser.

  • Fixes a crash issue when a plugin receives a NULL parameter after EncDB is enabled.

  • Fixes a crash issue with OSS archived tables.

  • Fixes an issue where the DDL process consumes page cache.

  • Fixes an issue where the number of updated rows is inaccurate in audit logs when INSERT and UPDATE statements fail.

  • Fixes a crash issue caused using `ALTER TABLE` to add an auto-increment column as a primary key in descending order.

  • Fixes an issue where a binary log is recorded even if an `Optimize TABLE` operation fails.

--

20240630

8.0.36

• Bug fixes

  • Fixes an unexpected behavior in the internal permission management of system tables. This allows user accounts to perform TRUNCATE operations on tables under Performance Schema.

  • Fixes a potential memory leak issue when recording Redo Logs for a table that has undergone an INSTANT DDL operation.

--

20240615

8.0.36

• Bug fixes

  • Fixes a crash issue when writing Redo Logs caused by changing the order of non-instant columns within an Instant DDL operation.

--

20240531

8.0.36

• New features

  • Merges changes from official versions 8.0.35 and 8.0.36.

  • Supports automatic release of NET::buff memory on persistent connections. This reduces memory resource usage and lowers the risk of out-of-memory (OOM) errors.

• Performance optimizations

  • Buffer Pool Extension supports asynchronous I/O reads.

  • Optimizes the scanning and validation of data files during instance startup. This improves the startup speed for instances with many tables.

• Bug fixes

  • Fixes an issue where the timestamp of a GTID Log Event generated by Binlog Cache Free Flush is incorrect.

  • Fixes an issue where a major version upgrade from 5.7 to 8.0 fails because a column named FTS_DOC_ID was explicitly created in an InnoDB table.

  • Fixes an issue where EncDB returns incorrect data types.

  • Fixes an issue where table recycling is triggered on a read-only instance even after the `recycle_bin` parameter is disabled.

  • Fixes an issue where innodb_activity_count could become negative. For more information, see Community Bug #114180.

  • Fixes an issue where parallel reads of partitioned tables lead to a parallel thread count leak, causing parallel reads to fail. For more information, see Community Bug #114154.

--

20240522

8.0.34

• Bug fixes

  • Fixes a Redo log corruption issue caused by changing the order of non-instant columns within an Instant DDL operation.

--

20240229

8.0.34

• New features

  • Updates the OpenSSL version to 3.0.12.

  • Adds a DDL logging feature to the fault diagnosis log.

  • Adds the Confidential database (public preview) feature. This feature encrypts data throughout link to protect data security.

• Bug fixes

  • Fixes a semi-synchronous replication failure issue caused by an incorrect binary log filename comparison.

  • Fixes a backup set compatibility issue caused by IPK.

--

20240131

8.0.34

• Bug fixes

  • Fixes an issue where the memory count in the `performance_schema.memory_summary_by_thread_by_event_name` table is excessively high when the thread pool is enabled.

  • Fixes an issue where an X-Engine instance frequently reports a duplicate entry error for an auto-increment column after a restart.

  • Fixes an issue where creating a full-text index with `innodb_disable_sort_file_cache=ON` reports the error "ERROR 1878 (HY000): Temporary file write failure.".

  • Fixes an issue where the parser does not take effect when rebuilding a full-text index using an INPLACE DDL statement in a single statement. For more information, see Community Bug #110976.

  • Fixes an issue where the automatic cleanup logic on a read-only instance does not meet expectations after the `recycle_bin` parameter is modified.

  • Fixes an instance crash issue when executing `create sequence` in a prepared statement.

--

20230930

8.0.34

• New features

  • Merges changes from official versions 8.0.32, 8.0.33, and 8.0.34.

  • Upgrades the OpenSSL version from 1.1.1u to 3.0.10.

  • Adds the built-in function SM3().

  • Buffer Pool Extension supports Online Resize.

  • Changes the default value of the `ssl_cipher` parameter to "ALL:@SECLEVEL=0".

• Performance optimizations

  • Supports the Binlog cache free flush feature.

    This feature directly converts the temporary file of a large transaction's Binlog cache into a Binlog file during the transaction commit phase. This can reduce the time a global Binlog lock is held when committing large transactions and alleviate I/O pressure on the instance. This prevents HA failovers caused by the instance being unable to write to the Binlog for a long time or by an I/O hang.

  • Optimizes the 1-second replication delay issue.

  • Optimizes the memory usage of the Buffer Pool Extension.

  • Optimizes I/O efficiency for parallel reads when `innodb_use_native_aio=off`. For more information, see Community Bug #112137.

• Bug fixes

  • Fixes an issue where pfs memory monitoring items do not count the Buffer Pool and Buffer Pool Extension.

  • Fixes a major version upgrade failure issue caused by case inconsistencies of a field included in an index between the server layer and the InnoDB layer.

--

20230914

8.0.31

• Bug fixes

  • Uses the INPLACE method by default instead of the INSTANT method when adding or deleting fields to avoid stability issues with the INSTANT method.

--

20230630

8.0.31

• New features

  • Merges changes from official version 8.0.31.

  • Supports canceling a running Buffer Pool Online Resize.

  • The Statement Concurrency Control feature adds template-level concurrency control, which can limit the execution of SQL statements with the same template. For more information, see SQL throttling.

  • Updates the zlib version to 1.2.13.

  • Updates the OpenSSL version to 1.1.1u.

  • Adds the status item `Innodb_redo_file_used_ratio` to show the used ratio of redo files.

  • X-Engine supports deployment in Arm environments.

• Performance optimizations

  • Optimizes mysqld_safe.sh to speed up instance startup.

• Bug fixes

  • Fixes an issue where XA transactions cannot be correctly recovered after an instance restart. For more information, see Community Bug #110533.

  • Fixes an unexpected instance restart caused by an `sql_type` error in the thread pool.

  • Fixes an issue where debug information is lost in the installation package. For more information, see Community Bug #109560.

  • Fixes an issue where a temporary table created in MySQL 5.6 causes an upgrade from MySQL 5.7 to MySQL 8.0 to fail.

  • Fixes a probabilistic transaction loss issue in X-Engine in deadlock scenarios.

  • Fixes an issue where transactions cannot be committed when Binlog in Redo and Binlog Parallel Flush run under high load for a long time.

--

20230620

8.0.28

• Bug fixes

  • Introduces a delayed start feature for MySQL Group Replication to avoid issues where cluster operations cannot be executed when an instance restarts quickly and reconnects to the cluster.

  • Fixes an issue where transactions cannot be committed when Binlog in Redo and Binlog Parallel Flush run under high load for a long time.

--

20230610

8.0.28

• Bug fixes

  • Fixes a deadlock issue (manifested as the instance being unreachable) caused by executing `COM_STATISTICS`, `COM_CHANGE_USER` commands, and `SHOW PROCESSLIST` statements. For more information, see Community Bug #110494.

  • Fixes an issue where a backup job cannot be executed due to an abnormal exit of a background recycling task in the X-Engine engine.

--

20230324

8.0.28

• Bug fixes

  • Fixes an issue where the Binlog In Redo feature is unexpectedly enabled in a semi-synchronous replication setup.

--

20221231

8.0.28

• New features

  • Supports enabling parallel binary logging when `sync_binlog` is not set to 1. After enabling, this feature improves the write performance of the binary log in high-concurrency business models, significantly boosting the instance's write performance.

  • Supports a feature to forcibly clear authentication information in MGR in single leader mode (enabled by default, can be manually disabled). By forcibly clearing authentication information, this feature resolves periodic performance fluctuations, high memory usage, and performance drops to zero when a new node joins the cluster under high business pressure and high latency scenarios.

  • When an active primary node selection command is initiated in MGR, if a transaction's execution time exceeds the timeout configured in the SQL statement, the transaction is forcibly rolled back. This prevents blocking the primary node selection operation and increases the success rate of the selection.

  • Updates the OpenSSL version to 1.1.1s.

• Performance optimizations

  • Enhances the asynchronous purge data file feature for RDS for MySQL. For tables with many dirty pages, this can improve the execution speed of `DROP TABLE` and `TRUNCATE TABLE` statements.

  • The performance agent adds purge statistics, including the following:

    • INNODB_UNDO_SIZE_USED: The size of the used Undo log.

    • INNODB_PURGE_LIMIT_TRX_NO: The purge offset, which is the maximum transaction number that has been purged.

    • INNODB_PURGE_ITER_TRX_NO: The maximum transaction number that can be purged.

• Bug fixes

  • Fixes a potential instance crash issue when using EXPLAIN UPDATE involving a subquery-derived table. For more information, see Community Bug#31884434.

  • Fixes an issue where `SELECT COUNT(*)` returns an inaccurate result when using a multi-valued index. For more information, see Community Bug #104898.

  • Fixes an issue where a query returns only a partial result set after adding a multi-valued index to a table with a JSON column. For more information, see Community Bug #106621.

  • Fixes a memory leak issue in the `Clone_persist_gtid` thread. For more information, see Community Bug #107991.

  • Fixes an issue where the number of updated rows in audit logs is inaccurate for `UPDATE` and `INSERT` statements when the `CLIENT_FOUND_ROWS` capability bit (disabled by default) is enabled.

  • Fixes an upgrade failure from MySQL 5.7 to MySQL 8.0 caused by a case mismatch of column names between the server layer and the InnoDB layer.

  • Fixes an upgrade failure from MySQL 5.7 to MySQL 8.0 caused by invalid strings in table, field, and index comments.

--

20221121

8.0.28

• Bug fixes

  • Fixes an error where a reference to a temporary table was not correctly assigned to a CTE in certain scenarios when executing a query with Common Table Expression (CTE) syntax.

--

20220830

8.0.28

• New features

  • Merges changes from official versions 8.0.26, 8.0.27, and 8.0.28.

  • Adds the json_document_max_depth parameter, which supports configuring the JSON nesting depth.

• Performance optimizations

  • Optimizes the parallel initialization performance of the buffer pool.

• Bug fixes

  • Fixes an issue with Redo log recording for the temporary tablespace.

--

20220730

8.0.25

• Performance optimizations

  • Optimizes the performance of Buffer Pool Free Resize.

--

20220530

8.0.25

• New features

  • For standalone instances with disks, adds the feature to perform incremental backups and point-in-time recovery using Redo logs.

  • Adds the Persist Binlog Into Redo V2 feature, which is optimized for high concurrency and offers better performance under such conditions.

  • Optimizes the SSL encryption feature and fixes some internal errors.

  • Revokes the operation permissions of standard accounts on the `sys` and `performance_schema` databases.

  • Adds FLUSH TABLES WITH READ LOCK and UNLOCK TABLES log records to the error log for easier online troubleshooting.

• Performance optimizations

  • Improves the performance of buffer pool initialization.

  • During Crash Recovery, the rollback of in-doubt transactions is optimized from synchronous to asynchronous, improving the Recovery Time Objective (RTO).

  • Optimizes the memory usage and update speed of the Adaptive Hash Index (AHI).

  • Optimizes bidirectional replication. When a secondary instance sends a binary log to the primary instance, it skips transactions belonging to the primary instance, reducing network traffic for circular replication.

  • Speeds up the restart process after an instance crash.

• Bug fixes

  • Fixes an issue where the `mysql.events` table fails to migrate during a major version upgrade from MySQL 5.7 to MySQL 8.0.

  • Fixes a potential crash issue when deleting a full-text index table during a progressive major version upgrade from a MySQL 5.6 instance to MySQL 8.0.

  • Fixes a potential instance crash issue in business scenarios with high metadata lock contention.

  • Fixes a parsing error in `xengine_record`.

  • Fixes a compression failure issue during index building in X-Engine.

  • Corrects the data in the `start_time` column of the `slow_log` table.

  • Optimizes compilation speed and fixes compilation warnings.

--

20220523

8.0.25

• BUG fixes

  • Fixes an issue where the SELECT COUNT(*) statement without a WHERE clause executes too slowly.

  • Fixes a crash issue caused by multiple calls to a stored procedure with WITH ROLLUP syntax.

--

20220331

8.0.25

• New features

  • Removes the restriction that innodb_buffer_pool_instances cannot be greater than 1 when innodb_buffer_pool_size is less than 1 GB.

  • Reduces the performance impact on the instance when the Native Flashback feature is enabled.

• Bug fixes

  • Fixes an Unknown thread id issue when killing a session.

  • Fixes an issue where the rds_expose_priv_list parameter does not take effect after a restart.

  • Fixes an issue where the Binlog in Redo feature blocks the advancement of the CheckPoint offset.

  • Merges bug fixes from MySQL community version 8.0.25 (Bug#33341080, Bug#32962511).

--

20210930

8.0.25

• New features

  • Merges changes from official version 8.0.25.

  • Introduces the recovery_apply_binlog mechanism to make XA transactions crash-safe.

  • Supports V3 format for audit logs, adds a separate column for transaction ID, and adds an `ext` field to store the identifier for truncated SQL.

  • Allows a new SEQUENCE type to be defined as a TIMESTAMP SEQUENCE, which has a different format compared to the original DIGITAL SEQUENCE.

    Syntax: CREATE SEQUENCE seq CACHE [cache_size] TIMESTAMP;

  • Grants truncate permission on the mysql.slow_log and mysql.general_log tables to privileged accounts.

  • Adds the Native Flashback Query feature, which supports rollback queries and data restoration directly through SQL statements.

  • Adds the self-developed X-Tree as an index for X-Engine MemTable, supporting high-performance writes, point queries, and range queries.

  • Supports freely adjusting the Buffer Pool size and optimizes the adjustment process to avoid affecting instance performance.

  • Supports the Multi Blocks Read feature. Add the HINT /*+ MULTI_BLOCKS(n) */ to an SQL statement to pre-read multiple data pages.

  • Optimizes the logic for scanning the Buffer Pool LRU linked list to get free pages.

  • Supports automatic entry into the CCL queue for UPDATE and DELETE statements with a primary key or unique key.

  • Adds TCP write wait time to the `performance_schema.events_statements_summary_by_digest_supplement` table.

  • Allows DDL statements to record redo logs when executed in In Place mode.

  • Adds MyISAM to the disabled_storage_engines parameter by default, meaning that creating tables with the MyISAM engine is no longer supported.

• Bug fixes

  • Fixes an issue where the execution result of SHOW GLOBAL STATUS is abnormal.

  • Fixes an issue where the instance fails to start when Jemalloc Profiling is enabled.

  • Fixes an instance crash issue when using SEQUENCE in an INSERT INTO SELECT statement.

  • Revokes the dbms_recycle.restore_table permission.

  • The I_S.INDEX_STATISTICS table now includes the number of index scans.

  • The I_S.PERF_STATISTICS table now includes more performance data metrics.

  • Optimizes the call performance when user-defined functions (nextval and currval) conflict with the SEQUENCE system function.

  • X-Engine now supports immediate response to user-initiated KILL SESSION requests.

  • X-Engine fixes an issue where some DDL operations fail and enter an inconsistent state in extreme scenarios.

  • Adds a stack overflow protection mechanism.

  • Fixes an issue where mysqld fails to start when persist_binlog_to_redo and X-Engine are enabled simultaneously.

  • Fixes a memory leak issue caused by pthread_getattr_np.

  • Automatically cleans up the Page Cache generated by Performance Agent files.

  • Fixes an internal error in the Statement Outline feature.

  • Fixes an issue where the session tracker resets when a statement execution error occurs.

  • Adjusts the ccl_wait_timeout variable name.

    Note

    ccl_wait_timeout refers to the maximum wait time (in seconds) for a throttled statement.

  • Fixes a restart failure issue caused by not cleaning up the socket file when the process exits.

  • Adjusts the priority of user-defined functions (nextval or currval).

  • Fixes the 251 error returned by net_length_size.

--

20201031

8.0.18

• New features

  • Supports restoring tables from the Recycle Bin.

  • Automatically recovers Slow Log files during instance initialization.

• Performance optimizations

  • Does not support enabling Binlog in Redo when using the X-Engine engine.

• Bug fixes

  • Fixes an ASSERT exception issue caused by an excessively large unique index key value.

  • Fixes an issue where the COM_DAEMON daemon process cannot be terminated.

  • Fixes a cache overflow issue caused by an FTS query.

  • Fixes a rollback error after an Instant-DDL crash.

20240601

20200831

8.0.18

• New features

  • Adds an option to allow the count(*) function to perform a parallel scan. Set the innodb_parallel_read_threads parameter to 0 to disable parallel scanning for this function. For more information, see Set instance parameters.

  • The MySQL Binlog tool adds `start gtid` and `stop gtid` functions.

  • Supports outputting various LSN values of the Redo Log:

    • innodb_lsn: The LSN number of the redo log.

    • innodb_log_checkpoint_lsn: The LSN of the last checkpoint.

    • innodb_log_write_lsn: The LSN of the log write.

    • innodb_log_ready_for_write_lsn: The LSN of the log buffer completion time.

    • innodb_log_flush_lsn: The LSN of the redo log flushed to disk.

    • innodb_log_dirty_pages_added_up_to_lsn: The LSN of the added dirty page.

    • innodb_log_oldest_lsn: The LSN of the page flush.

• Performance optimizations

  • Optimizes the wait and concurrency mechanism of Concurrency Control (CCL).

  • Adjusts the execution priority of Concurrency Control in stored procedures.

• Bug fixes

  • Fixes an issue where the parser lacks a heap memory size check during recursion.

  • Fixes an issue where table definitions cannot be modified when transparent data encryption (TDE) is enabled.

  • Fixes a memory leak issue in the event scheduler.

20240601

20200630

8.0.18

• New features

  • Faster DDL: Optimizes the buffer pool management mechanism during DDL operations, reducing the performance impact of DDL operations and increasing the concurrency of Online DDL operations.

  • Increases the upper limit of connections to a maximum of 500,000.

• Performance optimizations

  • Internal optimizations for the thread pool.

  • Sets the upper limit of memory occupied by Performance Schema based on the instance type.

  • No longer checks audit log files.

  • TDE caches keys provided by the KMS service.

  • Modifies the thread state running in SQL throttling.

• Bug fixes

  • Fixes an issue where Outline calculation treats a semicolon (;) as part of the input query.

  • Fixes an issue where altering a table causes the server to crash.

  • Fixes an incompatibility issue with the keywords `member` and `array` from older versions.

  • Fixes an issue where the wait count for reading client commands is incorrect.

  • Fixes a minor engine version update failure.

20240601

20200430

8.0.18

• New features

  • Binlog in Redo: Optimizes the transaction commit mechanism by writing the binary log to the Redo Log, improving database performance.

  • Refactors the row cache code of the X-Engine engine.

  • Opens the `XA_RECOVER_ADMIN` permission.

• Performance optimizations

  • Scans only the dirty page list when operating on InnoDB temporary tables, instead of scanning the entire Buffer Pool list.

  • For compatibility with MySQL 5.6, renames the global parameter `opt_readonly_trans_implicit_commit` to `rds_disable_explicit_trans`.

  • Does not record upgrade-related logs to the audit log during an instance upgrade.

  • Reduces the memory consumed by DDL operations on X-Engine engine tables.

• Bug fixes

  • Fixes an inconsistency between the actual X-Engine engine table size on disk and the statistics in the IS table.

  • Fixes an issue where reopening the error log causes X-Engine log initialization.

20240601

20200331

8.0.18

• New features

  • Merges changes from official versions 8.0.17 and 8.0.18.

  • Recycle Bin: Adds support for the TRUNCATE TABLE command. When executed, it moves the original table to a dedicated recycle bin folder and creates a new table with the same structure.

• Performance optimizations

  • Disables the output of TCP errors by default.

  • Improves the performance of the thread pool with default configurations.

• Bug fixes

  • Fixes an issue where databases and tables become invalid due to partitioning filenames with #p.

  • Fixes a case-sensitive matching issue in CCL, making it case-insensitive.

20240601

20200229

8.0.16

• New features

  • Performance Agent: A more convenient performance data statistics solution. It collects and counts various internal performance data of a MySQL instance through a MySQL plugin.

  • Adds network round trip time in semi-synchronous mode and records it to performance data.

  • The X-Engine engine supports the Online DDL feature.

• Performance optimizations

  • Allows statement concurrency control (CCL) operations on read-only instances.

  • Secondary instances support Outline.

  • Optimizes proxy short-lived connections.

  • Optimizes the execution time of the `pause` instruction on different CPU architectures.

  • Adds a memory table to view the running status of the thread pool.

  • Optimizes thread pool performance.

• Bug fixes

  • Disables `ppoll` in Linux kernels earlier than 4.9 and uses `poll` instead.

  • Fixes a `wrap_sm4_encrypt` function call error.

  • Fixes an issue of holding a global variable lock when scrolling audit logs.

  • Fixes a recovery inconsistency check issue.

  • Fixes an issue where the `io_statistics` table shows an incorrect time value.

  • Fixes a crash issue caused by an invalid compression algorithm.

  • Fixes an issue where a user column is incompatible with version 5.6.

  • Fixes a buffer count leak issue.

20240601

20200110

8.0.16

• New features

  • Inventory Hint: Adds three hints that support SELECT, UPDATE, INSERT, and DELETE statements to quickly commit or roll back transactions, improving business throughput capacity.

• Performance optimizations

  • When starting an instance, initializes the Concurrency Control queue structure before initializing the Concurrency Control rules.

  • Cancels the linking of small files during asynchronous file cleanup.

  • Optimizes Thread Pool performance.

  • Disables recovery inconsistency checks by default.

  • Changes the permissions required to set variables:

    • The permission required to set the following variables has been changed to regular user permission:

      • auto_increment_increment

      • auto_increment_offset

      • bulk_insert_buffer_size

      • binlog_rows_query_log_events

    • The permission required to set the following variables has been changed to superuser or system variable management user permission:

      • binlog_format

      • binlog_row_image

      • binlog_direct

      • sql_log_off

      • sql_log_bin

20240601

20191225

8.0.16

• New features

  • Recycle Bin: Temporarily moves deleted tables to the recycle bin and lets you set a retention period, making it easy to retrieve data.

• Performance optimizations

  • Improves short-lived connection handling performance.

  • Uses a dedicated thread to serve the `maintain user` to avoid HA failures.

  • Explicitly releases the file synchronization lock when an error occurs while flushing the binary log through Redo.

  • Deletes unnecessary TCP error logs.

  • Enables the thread pool by default.

• Bug fixes

  • Fixes a slow query log refresh issue.

  • Fixes an incorrect locking range issue.

  • Fixes a core dump issue caused by the TDE Select function.

20240601

20191115

8.0.16

• New features

  • Statement Queue: A queuing mechanism for statements that uses bucket queuing to place statements with potentially the same conflicts in the same bucket, reducing the overhead of conflicts.

20240601

20191101

8.0.16

• New features

  • Adds the SM4 encryption algorithm for TDE.

  • Protects secondary instance information: Only users with SUPER or REPLICATION_SLAVE_ADMIN permissions can insert, delete, or modify the tables `slave_master_info`, `slave_relay_log_info`, and `slave_worker_info`.

  • Increases the priority of auto-increment keys: If a table has no primary key or non-null unique key, a non-null key with auto-increment will be the first candidate.

  • Prevents automatic conversion from the Memory engine to the MyISAM engine for system tables and tables used by threads in an initialization state.

  • Flushes the binary log file to disk before flushing the Redo Log to disk.

  • Temporary tables are also affected when the instance is locked.

  • Adds a new LSM tree-based transactional storage engine, X-Engine.

• Performance optimizations

  • Thread Pool: Mutex optimization.

  • Performance Insight: Performance points support the thread pool.

  • Parameter adjustments:

    • primary_fast_lookup: Session parameter, default value is `true`.

    • thread_pool_enabled: Global parameter, default value is `true`.

20240601

20191015

8.0.16

• New features

  • TDE: Supports the transparent data encryption (TDE) feature, which performs real-time I/O encryption and decryption on data files. Data is encrypted before being written to disk and decrypted when read from disk into memory.

  • Returning: The Returning feature supports DML statements returning a result set and provides a toolkit (DBMS_TRANS) for quick use.

  • Force conversion of engine from MyISAM or MEMORY to InnoDB: If the global variable force_mysiam_to_innodb or force_memory_to_innodb is ON, the table engine is converted from MyISAM or MEMORY to InnoDB when creating or modifying a table.

  • Prohibits non-privileged accounts from switching between primary and secondary instances.

  • Performance agent plugin: Collects performance data and saves it to a local formatted text file. It uses file rotation to retain recent second-level performance data.

  • Innodb mutex timeout configurable: The global variable innodb_fatal_semaphore_wait_threshold can be configured. Default value: 600.

  • Ignore index hint error: The global variable ignore_index_hint_error can be configured. Default value: false.

  • The SSL encryption feature can be disabled.

  • TCP error message: Returns TCP direction (read, read wait, write wait) errors and error codes to the `end_connection` event, and outputs error messages to the error log.

• Bug fixes

  • Merges AIO requests before triggering a linear read-ahead in Linux systems that support native AIO.

  • Optimizes table/index statistics.

  • Directly accesses the primary index if a primary key is specified.

20240601

20190915

8.0.16

• Bug fixes

  • Fixes a memory leak issue in `Cmd_set_current_connection`.

20240601

20190816

8.0.16

• New features

  • Thread Pool: Separates threads from sessions, allowing a small number of threads to complete tasks for many active sessions.

  • SQL throttling: Controls concurrency to handle sudden database request traffic, high resource-consuming statement access, and changes in SQL access models, ensuring the continuous and stable operation of the MySQL instance.

  • Statement Outline: Uses Optimizer Hints and Index Hints to stabilize MySQL execution plans.

  • Sequence Engine: Simplifies the complexity of obtaining sequence values.

  • Purge Large File Asynchronously: When deleting a single tablespace, renames the tablespace file to a temporary file and waits for an asynchronous cleanup process to clean up the temporary file.

  • Performance Insight: A powerful tool for instance load monitoring, association analysis, and performance tuning, helping you quickly assess database load, find the source of performance issues, and improve database stability.

  • Optimizes instance lock state: Allows `DROP` or `TRUNCATE` table operations when the instance is in a locked state.

• Bug fixes

  • Fixes a file size calculation error.

  • Fixes an issue where memory is occasionally reused after being freed.

  • Fixes a crash issue when the host cache size is 0.

  • Fixes a conflict between implicit primary keys and CTS statements.

  • Fixes an `slog` error caused by a slow query.

20240601

20190601

8.0.16

• Performance optimizations

  • Shortens the MDL range for log tables to reduce the possibility of MDL blocking.

  • Refactors the code for the terminate option.

• Bug fixes

  • Fixes an issue where precompiled statements are not recorded in the audit log.

  • Masks error logs for invalid table names.

20240601

Minor version

Note

20230415

• Bug fixes

  • Fixes stability bugs related to large transaction scenarios.

  • Fixes a bug where `Seconds_Behind_Master` on a secondary database is not 0 when there is no traffic.

20230406

• Performance optimizations

  • Optimizes Faster DDL performance. When a session exits, if the user's operation or the optimizer has generated a temporary table, the default page eviction process is optimized from traversing the entire buffer pool to traversing only the pages related to the temporary table. This reduces the wait time for evicting temporary tables from the buffer pool, minimizes conflicts, and improves overall performance.

20210305

• Bug fixes

  • Fixes a memory leak bug in performance schema.

20200918

• New features

  • Supports enabling SSL encryption for dedicated proxies.

20200805

• Bug fixes

  • Fixes a metadata bug.

20200608

• New features

  • Merges changes from official versions 8.0.17 and 8.0.18.

  • Recycle Bin: Adds support for the TRUNCATE TABLE command. When executed, it moves the original table to a dedicated recycle bin folder and creates a new table with the same structure.

• Performance optimizations

  • Disables the output of TCP errors by default.

  • Improves the performance of the thread pool with default configurations.

• Bug fixes

  • Fixes an issue where databases and tables become invalid due to partitioning filenames with #p.

  • Fixes a case-sensitive matching issue in CCL, making it case-insensitive.

20200317

• New features

  • Performance Agent: A more convenient performance data statistics solution. It collects and counts various internal performance data of a MySQL instance through a MySQL plugin.

  • Faster DDL: Optimizes the buffer pool management mechanism during DDL operations, reducing the performance impact of DDL operations and increasing the concurrency of Online DDL operations.

  • Adds network round trip time in semi-synchronous mode and records it to performance data.

• Performance optimizations

  • Allows statement concurrency control (CCL) operations on read-only instances.

  • Secondary instances support Outline.

  • Optimizes proxy short-lived connections.

  • Optimizes the execution time of the `pause` instruction on different CPU architectures.

  • Adds a memory table to view the running status of the thread pool.

  • Optimizes thread pool performance.

• Bug fixes

  • Disables `ppoll` in Linux kernels earlier than 4.9 and uses `poll` instead.

  • Fixes a `wrap_sm4_encrypt` function call error.

  • Fixes an issue of holding a global variable lock when scrolling audit logs.

  • Fixes a recovery inconsistency check issue.

  • Fixes an issue where the `io_statistics` table shows an incorrect time value.

  • Fixes a crash issue caused by an invalid compression algorithm.

  • Fixes an issue where a user column is incompatible with version 5.6.

  • Fixes a buffer count leak issue.

Minor version

Community version

Description

Expiration date

20251220

5.7.44

• New features

  • Adds a CPU time consumption metric to audit logs.

• Bug fixes

  1. Fixes an instance restart issue caused by the Sequence engine when recording a binary log and rotating the binary log.

  2. Fixes an issue where a major version upgrade takes a long time when the general log is enabled.

  3. Fixes a performance issue caused by trx_sys lock waits under high concurrency.

20251031

5.7.44

• New features

  • Supports online extension of the length of INT, VARCHAR, and CHAR data types.

  • Supports instantly changing a column character set.

  • Supports automatic release of NET::buff memory on persistent connections. This reduces memory resource usage and lowers the risk of OOM errors.

  • Adds the built-in functions `statement_digest` and `statement_digest_text`.

• Bug fixes

  • Fixes a replication interruption issue in native replication scenarios that is caused by granting the SUPER permission. After the fix, only the permissions owned by the replication thread are granted.

  • Fixes community Bug #105652. This resolves an abnormal issue during the crash recovery process for large tables that exceed 32 TB.

  • Fixes a crash issue that may occur when you concurrently execute a DDL statement while updating a table with foreign keys.

  • Fixes an issue that causes single-statement transaction SBM spikes.

  • Fixes an issue where purging relay logs slows down acknowledgments in semi-synchronous replication.

  • Fixes a performance issue caused by clearing the writeset.

  • Fixes community Bug #118476. This resolves an issue where partitions cannot be created with certain identifiers.

--

20250831

5.7.44

• Bug fixes

  • Fixes an abnormal query issue caused by the innodb_max_mtr_records_for_tmp_table parameter.

--

20250430

5.7.44

• New features

  • Supports Visible Index and Invisible Index features.

  • Supports recording the end time of an SQL statement in the start_time field of the slow query log.

• Performance optimizations

  • Improves the execution efficiency of the `REPLACE` function.

  • Enables GTID auto-positioning, allowing the secondary database to automatically skip gap transactions when starting replication.

• Bug fixes

  • Fixes an issue where the start_time field is incorrect in the slow query log for `CALL PROCEDURE`.

--

20250331

5.7.44

• New features

  • Supports the instant column addition feature. For more information, see Instant column addition.

• Performance optimizations

  • Fixes a replication interruption issue that occurs with the Writeset feature in scenarios involving unique indexes on string prefixes.

--

20241231

5.7.44

• New features

  • Adds template-level Statement Concurrency control to limit the execution of SQL statements with the same template.

  • The column encryption feature now supports key management through KMS.

  • Column encryption now supports the AES 256 algorithm.

--

20241130

5.7.44

• New features

  • Upgrades the OpenSSL version to 3.0.15.

• Performance optimizations

  • Optimizes the automatic repair process of the General Query Log during crash recovery to reduce time consumption.

• Bug fixes

  • Fixes Community Bug#96236. This resolves an issue where an internal temporary table exhausts the buffer pool, causing the instance to become unavailable.

  • Fixes a potential instance crash issue when canceling a buffer pool scale-in.

  • Fixes Community Bug#99643. This resolves an issue where a transaction is suspended and cannot be killed due to an invalid trx->in_innodb value.

  • Fixes an issue where a binary log is recorded even if an `Optimize Table` operation fails.

  • Fixes a ciphertext collision issue in EncDB column encryption.

--

20240930

5.7.44

• New features

  • MySQL 5.7 Basic Edition supports MySQL native replication.

--

20240731

5.7.44

• New features

  • Allows user Binlog Dump threads to skip Ignorable Log Events generated by the Binlog Cache Free Flush feature.

  • Supports dynamic modification of `encdb` parameters.

• Performance optimizations

  • Deletes unnecessary Server hooks to reduce unnecessary lock contention during DML processes.

  • Optimizes the lock holding time for `TRUNCATE TABLE`. When the innodb_rds_drop_ahi_ahead parameter is enabled, it deletes the adaptive hash index built for a table before truncating the InnoDB table. This shortens the holding time of the InnoDB metadata lock during statement execution, preventing other SQL statements from being blocked.

  • Optimizes the time taken for the automatic repair process of the General Query Log during crash recovery.

• Bug fixes

  • Fixes an issue where the Crash Recovery process gets stuck at 99%.

  • Fixes an issue where `Analyze Table` may cause many SQL executions to get stuck in the "Waiting for table flush" state.

  • Fixes an issue with the Binlog Cache Free Flush feature where `end_log_pos` is incorrect.

  • Fixes a page checksum error during Crash Recovery writes.

  • Fixes an issue where memory information is not collected by `performance_schema` when initializing the Buffer Pool with multiple threads.

  • Fixes a crash caused by `encdb` timestamp processing.

  • Fixes an issue where a binary log is recorded even if an `Optimize Table` operation fails.

  • Fixes an issue where an unnecessary AUTO_INC lock may be acquired during the execution of an `UPDATE` statement.

--

20240430

5.7.44

• Performance optimizations

  • Optimizes `DROP TABLE` lock holding time. Adds the innodb_rds_drop_ahi_ahead parameter. When enabled, this parameter deletes the adaptive hash index built for a table before deleting the InnoDB table. This shortens the holding time of the InnoDB metadata lock during the execution of the `DROP TABLE` statement, preventing other SQL statements from being blocked.

  • Supports the Binlog Cache Free Flush feature. This feature directly converts the temporary file of a large transaction's Binlog cache into a Binlog file during the transaction commit phase. This can reduce the time a global Binlog lock is held when committing large transactions and alleviate I/O pressure on the instance. This prevents HA failovers caused by the instance being unable to write to the Binlog for a long time or by an I/O hang.

• Bug fixes

  • Fixes an issue where a `REPLACE INTO` statement causes the `AUTO_INCREMENT` value of an InnoDB table on a secondary database to be inconsistent with the actual data.

  • Fixed an issue where INSERT ... SELECT statements allowed the insertion of data of an incompatible GEOMETRY type.

  • Fixed an issue where EncDB returned incorrect data types.

  • Fixed an issue that could cause an "error 1305: savepoint does not exist." error when you create a backup using Percona mysqldump with the --lock-for-backup option.

--

20240229

5.7.44

• New features

  • Merges changes from official version 5.7.44.

  • Adds support for ps-protocol in Statement Outline.

  • Updates the OpenSSL version to 3.0.12.

  • EncDB supports querying encryption rules and users.

• Performance optimizations

  • Optimizes the 1-second replication delay issue.

• Bug fixes

  • Fixes an issue where an irrelevant error is reported after discarding a tablespace.

  • Fixes an issue where table recycling is triggered on a read-only instance even after the `recycle_bin` parameter is disabled.

  • Fixes a potential CRASH issue when querying a standard table and the system table `information_schema.PARAMETERS` or `ROUTINES` simultaneously.

  • Fixes a failure to write to the slow query log due to a missing `slow_log.CSV`.

  • Fixes a potential null pointer access issue when the query cache plugin is quickly unloaded after being loaded.

  • Fixes an issue where the truncation position of multiple statements is recorded inaccurately in V3 of the audit log when they are merged into a single query.

  • Fixes an issue where `drop table force` is ineffective on tables with foreign key dependencies.

  • Fixes an abnormal issue with the `more_result` field in the OK protocol package in multi-statement scenarios. Supports MaxScale to restore session state with multiple statements.

  • Fixes a semi-synchronous replication failure issue caused by an incorrect binary log filename comparison.

  • Fixes an issue where EncDB writes Null as a timestamp when the `explicit_defaults_for_timestamp` parameter is set.

--

20240115

5.7.43

• Bug fixes

  • Fixes an issue where EncDB cannot identify sensitive columns when the SQL contains a table alias.

  • Fixes a system crash issue when the constructor of the `DesensitizationAlgo` class in EncDB encounters invalid input.

  • Fixes an issue where EncDB always outputs logs when the sensitive rule configuration is empty, which could fill up the user's disk.

  • Fixes an issue where EncDB returns an error when processing `noneAcces` type users if the calculated ciphertext size does not match the actual generated ciphertext size.

--

20231215

5.7.43

• Bug fixes

  • Fixes an issue where clients cannot connect to the server using TLSv1.0 or TLSv1.1 after upgrading the MySQL OpenSSL version to 3.0.9.

--

20231031

5.7.43

• Bug fixes

  • Fixes an issue where EncDB parameter settings do not take effect.

--

20230831

5.7.43

• New features

  • Merges changes from official version 5.7.43.

  • Upgrades the OpenSSL version to 3.0.9.

  • Improves the speed of starting MySQL through `mysqld_safe` using the shell's built-in function to parse parameters.

  • Adds the Confidential database feature, which encrypts data throughout link to protect data security.

• Bug fixes

  • Fixes an unexpected instance restart caused by an `sql_type` error in the thread pool.

  • Fixes a self-looping issue caused by `fil_addr` pointing to an incorrect address during the recovery of an UNDO table lock.

  • Fixes an issue where the audit log does not record multi-statement queries.

--

20230531

5.7.42

• New features

  • Merges changes from official versions 5.7.41 and 5.7.42.

  • Upgrades the OpenSSL version to 1.1.1u.

  • Accelerates the revival process of undo tablespace locks during instance crash recovery.

  • Supports canceling Online Buffer Pool Resize to avoid excessively long resize processes.

• Performance optimizations

  • Uses multiple threads to initialize Buffer Pool Instances simultaneously during instance startup to speed up the process.

  • During instance crash recovery, the rollback of in-doubt transactions is optimized from synchronous to asynchronous, improving RTO.

  • Improves the performance of Buffer Pool initialization to speed up startup.

• Bug fixes

  • Fixes an initialization failure issue caused by an out-of-bounds access to the parameter array when initializing Buffer Pool Instances with multiple threads.

--

20230228

5.7.40

• Bug fixes

  • Fixes an issue where enabling `recycle_scheduler` could cause a slow increase in memory in some scenarios.

  • Fixes an issue where a conflict between the `recycle_scheduler` background thread and an active `purge_table` operation prevents the `purge_table` operation from being executed.

--

20221231

5.7.40

• New features

  • Merges changes from official version 5.7.40.

  • Updates the OpenSSL version to 1.1.1s.

• Performance optimizations

  • Optimizes the Adaptive Hash Index (AHI) feature:

    • Cleans up memory occupied by AHI when AHI is disabled.

    • Improves the update speed of AHI.

  • If a transaction modifies a table without a PRIMARY KEY and a non-null UNIQUE KEY, a non-null key with an auto-increment field is used as the first candidate to find the target column when applying changes on the secondary database. This improves the replay efficiency of the table on the secondary database and reduces replication delay.

    Note

    A non-null key with an auto-increment field can be a user-defined key or an implicit primary key created by RDS.

• Bug fixes

  • Fixes an issue where the number of updated rows is inaccurate in MySQL audit logs for `UPDATE` and `INSERT` statements.

  • Fixes an issue where creating a standard table from a temporary table causes the secondary database to report error 13146 because the binary log lacks the character set of the temporary table. After the fix, when creating a standard table from a temporary table, the binary log includes the character set of the temporary table, and the secondary database does not report error 13146.

--

20221031

5.7.39

• New features

  Merges changes from official version 5.7.39.

• Bug fixes

  Removes the primary fast look up feature.

--

20220731

5.7.38

• New features

  Merges changes from official version 5.7.38.

• Bug fixes

  • Fixes a deadlock issue between a `Rename Tablespace` operation and other unfinished I/O operations during a DDL process.

  • Fixes an issue where the Memory/sql/String::value statistic in the `performance_schema.memory_summary_global_by_event_name` table is inaccurate.

  • Fixes a deadlock issue on a Replica node for XA transactions caused by unreasonable locking on a secondary index when inserting data into it.

  • Removes the restriction that innodb_buffer_pool_size must not be less than 1 GB when innodb_buffer_pool_instances is greater than 1.

• Performance optimizations

  Optimizes the strategy for adjusting the Buffer Pool size to make the process smoother.

--

20220430

5.7.37

• New features

  • Merges changes from official version 5.7.37.

  • Optimizes the SSL encryption feature and fixes some internal errors.

  • Revokes the operation permissions of standard accounts on the `sys` and `performance_schema` databases.

• Bug fixes

  Changes the log level of FLUSH TABLES WITH READ LOCK and UNLOCK TABLES log records in the error log to warning for easier online troubleshooting.

--

20211231

5.7.35

• New features

  • Merges changes from official version 5.7.35.

  • Supports Free resize for the RDS InnoDB buffer pool, which has less impact on instance performance during buffer pool adjustment and provides a more user-friendly experience.

  • Optimizes bidirectional replication. It no longer sends unnecessary binary logs and does not generate heartbeat events when skipping an EVENT.

  • No longer requires an instance restart after modifying the log_slave_updates parameter.

  • Adds FLUSH TABLES WITH READ LOCK and UNLOCK TABLES logs to the error log.

  • Adds the parameter innodb_control_index_page_reserve. Setting it to OFF reduces page splits and lowers storage space usage.

• Bug fixes

  • Fixes an issue where the CPU usage collected by the Performance Agent is incorrect in the new Docker architecture.

  • Fixes an issue where the session tracker type number reserved by RDS is incorrect.

  • Fixes a crash recovery failure issue caused by the mtr log exceeding the log parsing buffer size.

  • Supports marking memory pages as `MADV_DONTDUMP`. When the innodb_buffer_pool_in_core_file parameter is disabled, the generated core dump will not include the InnoDB buffer pool, thus reducing the space occupied by the core dump.

  • Fixes an issue where `start_time` in the `mysql.slow_log` table is incorrect. It should be the start time of the SQL, not the end time.

  • Opens `Show_db_priv` permission to regular users.

  • Fixes a potential memory leak issue during `LF_HASH_INSERT` execution.

  • Fixes an issue where `recycle_bin` does not support tables containing virtual columns.

--

20210630

5.7.32

• New features

  • Audit logs support the MYSQL_V3 format.

  • Allows users to perform truncate operations on the slow log and general log.

  • Adds a thread stack memory overflow check.

  • Adds the parameter thread_pool_strict_mode to control the maximum number of worker threads.

• Bug fixes

  • The `mysqld_safe` script now deletes old socket lock files when starting `mysqld`.

  • Fixes a `recycle_bin` memory leak issue.

--

20210430

5.7.32

• New features

  • Supports Recycle Bin. For more information, see Recycle Bin.

  • Supports SEQUENCE Engine. For more information, see Sequence Engine.

• Performance optimizations

  • The I_S.PERF_STATISTICS table now includes more performance data metrics.

  • The I_S.INDEX_STATISTICS table now includes the number of index scans.

  • Optimizes TDE performance.

• Bug fixes

  Fixes a community version bug related to abnormal handling of generated columns during rollback.

--

20201031

5.7.30

• Bug fixes

  • Fixes a `ROW_SEARCH_MVCC` crash issue caused by concurrent updates.

  • Fixes an issue where the instance fails to start after changing `innodb_undo_tablespaces`.

  • Fixes a cache overflow issue caused by an FTS query.

20240601

20200831

5.7.30

• New features

  • Merges changes from official version 5.7.30.

  • Optimizes the wait and concurrency mechanism of Concurrency Control (CCL).

  • The MySQL Binlog tool adds `start gtid` and `stop gtid` functions.

  • Supports outputting various LSN values of the Redo Log:

    • innodb_lsn: The LSN number of the redo log.

    • innodb_log_write_lsn: The LSN of the log write.

    • innodb_log_checkpoint_lsn: The LSN of the last checkpoint.

    • innodb_log_flushed_lsn: The LSN of the redo log flushed to disk.

    • innodb_log_Pages_flushed: The LSN of the page flush.

• Performance optimizations

  • Adjusts the execution priority of Concurrency Control in stored procedures.

• Bug fixes

  • A temporary table page used during SQL execution could have a reference count leak. This could lead to inefficient flushing of dirty blocks in the entire Buffer Pool, causing a lack of available free pages in the Buffer Pool and severely affecting database performance. For more information, see the official documentation.

20240601

20200630

5.7.28

• New features

  • Inventory Hint: Adds three hints that support SELECT, UPDATE, INSERT, and DELETE statements to quickly commit or roll back transactions, improving business throughput capacity.

  • SQL throttling: Controls concurrency to handle sudden database request traffic, high resource-consuming statement access, and changes in SQL access models, ensuring the continuous and stable operation of the MySQL instance.

  • Statement Queue: A queuing mechanism for statements that uses bucket queuing to place statements with potentially the same conflicts in the same bucket, reducing the overhead of conflicts.

  • Statement Outline: Uses Optimizer Hints and Index Hints to stabilize MySQL execution plans.

  • Faster DDL: Optimizes the buffer pool management mechanism during DDL operations, reducing the performance impact of DDL operations and increasing the concurrency of Online DDL operations.

  • Increases the upper limit of connections to a maximum of 500,000.

• Performance optimizations

  • You can view all native procedures by running the call dbms_admin.show_native_procedure(); command.

  • Adds a function to delete orphan tables.

  • Internal optimizations for the thread pool.

  • Optimizes the query cache.

  • Sets the upper limit of memory occupied by Performance Schema based on the instance type.

• Bug fixes

  • Fixes an issue where the audit refresh thread enters an infinite loop.

20240601

20200430

5.7.28

• Performance optimizations

  • Removes `rwlock` from QueryCache and changes the default hash function from `LF_hash` to `murmur3 hash`.

• Bug fixes

  • Fixes two errors when hitting the query cache in transaction isolation (repeatable read level).

20240601

20200331

5.7.28

• New features

  • Merges changes from official version 5.7.28

  • Fast Query Cache: To address the shortcomings of the native MySQL Query Cache, Alibaba Cloud has redesigned and implemented the RDS Query Cache, which effectively improves database query performance.

  • Ports two MDL locks from percona-server 5.7: LOCK TABLES FOR BACKUP (LTFB) and LOCK BINLOG FOR BACKUP (LBFB).

• Performance optimizations

  • Adds compatibility for the thread pool with earlier versions.

  • Disables the output of TCP errors by default.

  • Improves the performance of the thread pool with default configurations.

• Bug fixes

  • Fixes an issue where temporary files are included when cleaning up large files.

  • Fixes a thread pool dump thread timeout issue.

  • Fixes an IPK field count error in the process context.

  • Fixes a pfs thread leak and release issue caused by `rds_change_user`.

20240601

20200229

5.7.26

• New features

  • Performance Agent: A more convenient performance data statistics solution. It collects and counts various internal performance data of a MySQL instance through a MySQL plugin.

  • Adds network round trip time in semi-synchronous mode and records it to performance data.

• Performance optimizations

  • Optimizes the execution time of the `pause` instruction on different CPU architectures.

  • Optimizes proxy short-lived connections.

  • Adds a memory table to view the running status of the thread pool.

• Bug fixes

  • Fixes an issue where DDL redo logs are unsafe.

  • Fixes an issue where the `io_statistics` table shows an incorrect time value.

  • Fixes an issue where altering a table causes the server to crash.

  • Fixes MySQL test cases.

20240601

20200110

5.7.26

• Performance optimizations

  • Cancels the linking of small files during asynchronous file cleanup.

  • Optimizes Thread Pool performance.

  • The default value of the `thread_pool_enabled` parameter is changed to OFF.

20240601

20191225

5.7.26

• New features

  • Internal account management and prevention: Adjusts user permissions to protect data security.

• Performance optimizations

  • Improves short-lived connection handling performance.

  • Uses a dedicated thread to serve the `maintain user` to avoid HA failures.

  • Deletes unnecessary TCP error logs.

  • Optimizes the thread pool.

• Bug fixes

  • Fixes a `mysqld` process crash issue during read/write splitting.

  • Fixes a core dump issue caused by the keyring.

20240601

20191115

5.7.26

• Bug fixes

  • Fixes an issue where audit logs display variables after a primary/secondary switchover.

20240601

20191101

5.7.26

• New features

  • Adds the SM4 encryption algorithm for TDE.

  • Directly accesses the primary index if a primary key is specified.

  • Prevents automatic conversion from the Memory engine to the MyISAM engine for system tables and tables used by threads in an initialization state.

• Performance optimizations

  • Thread Pool: Mutex optimization.

  • Introduces an audit log buffer mechanism to improve audit log performance.

  • Performance Insight: Performance points support the thread pool.

  • Enables Thread Pool by default.

• Bug fixes

  • Releases locks when processing the maintenance user list.

  • Adds more TCP error information.

20240601

20191015

5.7.26

• New features

  • Rotate slow logs: To ensure zero data loss when collecting slow query logs, the log rotation table renames the CSV data file of the slow log table to a unique name and creates a new file. You can use show variables like '%rotate_log_table%'; to check if slow log rotation is enabled.

  • Performance agent plugin: Collects performance data and saves it to a local formatted text file. It uses file rotation to retain recent second-level performance data.

  • Force conversion of engine from MEMORY to InnoDB: If the global variable rds_force_memory_to_innodb is ON, the table engine is converted from MEMORY to InnoDB when creating or modifying a table.

  • TDE mechanism optimization: Adds the `keyring-rds` plugin to interact with the control system/Key Management Service.

  • TCP error message: Returns TCP direction (read, read wait, write wait) errors and error codes to the `end_connection` event, and outputs error messages to the error log.

• Bug fixes

  • Fixes an unexpected error `Error 1290` in DDL.

20240601

20190925

5.7.26

• Parameter modification

  • Changes the default value of the system variable `auto_generate_certs` from `true` to `false`.

  • Adds the global read-only variable `auto_detact_certs` with a default value of `false` and valid values of `[true | false]`. This system variable is available when the server-side is compiled with OpenSSL. It controls whether the server-side automatically searches for SSL encryption certificate and key files in the data directory at startup, i.e., it controls whether to enable the automatic search function for server-side certificates and keys.

20240601

20190915

5.7.26

• New features

  • Thread Pool: Separates threads from sessions, allowing a small number of threads to complete tasks for many active sessions.

20240601

20190815

5.7.26

• New features

  • Purge Large File Asynchronously: When deleting a single tablespace, renames the tablespace file to a temporary file and waits for an asynchronous cleanup process to clean up the temporary file.

  • Performance Insight: A powerful tool for instance load monitoring, association analysis, and performance tuning, helping you quickly assess database load, find the source of performance issues, and improve database stability.

  • Optimizes instance lock state: Allows `drop` or `truncate` table operations when the instance is in a locked state.

• Bug fixes

  • Prohibits setting `rds_prepare_begin_id` in the set rds_current_connection command.

  • Allows changing the information of a locked user.

  • Prohibits using the keyword `actual` as a table name.

  • Fixes a time field overflow issue in the slow query log.

20240601

20190510

5.7.26

• New features

  • Allows creating temporary tables within a transaction.

20240601

20190319

5.7.26

• New features

  • Supports setting `threadID` via proxy in the handshake message.

20240601

20190131

5.7.25

• Performance optimizations

  • Upgrades to official version 5.7.25.

  • Disables the memory management feature `jemalloc`.

• Bug fixes

  • Fixes an internal variable `net_lenth_size` calculation error.

20240601

20181226

--

• New features

  • Supports dynamic modification of `binlog-row-event-max-size` to accelerate replication for tables without primary keys.

• Bug fixes

  • Fixes a memory allocation exception issue in proxy instances.

20240601

20181010

--

• Performance optimizations

  • Supports implicit primary keys.

  • Accelerates primary-secondary replication for tables without primary keys.

  • Supports Native AIO to improve I/O performance.

20240601

20180431

--

• New features

  • Supports high-availability series.

  • Supports SQL Audit.

  • Enhances protection for instances in snapshot backup status.

20240601

Minor version

Description

20230101

• Bug fixes

  • When multiple sessions insert into a table with an auto-increment column, and the unique key constraint uses IODKU, the explicit value of the auto-increment column is not put into the table, and the insert operation may fail due to a unique index conflict. After the fix, when an IODKU insert fails, the auto-increment ID of the failed row is retained for the next insert, and the current operation becomes an update.

20201229

• Bug fixes

  • Fixes unexpected database crashes and hangs.

  • Fixes an issue where a prefix index is judged as an invisible index.

  • Fixes an abnormal state issue of the logger node in the consensus protocol, which could prevent the cluster from correctly electing a primary node.

20191128

• New features

  • Supports read/write splitting.

• Bug fixes

  • Fixes a `Second_Behind_Master` calculation error on the Follower in some scenarios.

  • Fixes a deadlock issue during transaction retry in table-level parallel replication.

  • Fixes XA-related bugs.

20191016

• New features

  • Supports upgrading from MySQL 5.7 High-availability Series (with high-performance local disks) to RDS Enterprise Edition.

  • Compatible with the official MySQL GTID feature, which is disabled by default.

  • Merges self-developed features from AliSQL MySQL 5.7 Basic/High-availability Series versions 20190915 and earlier.

• Bug fixes

  • Fixes an issue where resetting a secondary instance causes the binary log to be disabled.

20190909

• New features

  • Optimizes the execution efficiency of large transactions in a three-node strong consistency state.

  • Supports Binlog dump from Leader/Follower.

  • Supports creating read-only instances.

  • System tables use the InnoDB engine by default.

• Bug fixes

  • Fixes an issue where the Follower log cleanup command fails.

  • Fixes an issue where the Slave thread exits abnormally when `slave_sql_verify_checksum=OFF` and `binlog_checksum=crc32`.

20190709

• New features

  • Supports the three-node feature.

  • Disables the semi-sync plugin.

  • Supports table-level parallel replication and Writeset parallel replication.

  • Supports `pk_access` primary key query acceleration.

  • Supports thread pool.

  • Merges self-developed features from AliSQL MySQL 5.7 Basic/High-availability Series versions 20190510 and earlier.

Minor version

Community version

Description

Expiration date

20250531

5.6.16

• Bug fixes

  • Fixes a memory leak issue on the primary database caused by an incorrect semi-sync offset comparison.

--

20241231

5.6.16

• Bug fixes

  • Fixes an abnormal restart issue in Thread Pool instances caused by an `sql_type` error.

  • Fixes a replication failure issue in semi-synchronous replication caused by an incorrect binary log filename comparison.

--

20221130

5.6.16

• New features

  Supports recording GLOBAL READ LOCK lock and unlock events in the error log.

• Bug fixes

  • Fixes an issue where opening tables consumes excessive memory when there are many InnoDB partitioned tables.

  • Fixes an issue where the InnoDB data dictionary is not updated when column names change case.

  • Fixes a deadlock issue when renaming a tablespace.

  • Fixes a crash recovery failure issue caused by a small recovery parsing buffer.

  • Fixes an issue where the execution result of SHOW GLOBAL STATUS; is inaccurate.

  • Fixes an issue where the `start_time` field in the `mysql.slow_log` table is inaccurate.

--

20221126

5.6.16

• Bug fixes

  • Fixes an issue where InnoDB auto-increment columns (AUTO_INCREMENT) produce duplicates.

--

20210630

5.6.16

• New features

  Adds a thread stack memory overflow check.

• Bug fixes

  • Fixes bugs in MySQL 5.6 community version.

  • Removes operation restrictions on SHOW CREATE statements for tables in the mysql database.

--

20210430

5.6.16

• Performance optimizations

  The I_S.PERF_STATISTICS table now includes more performance data metrics.

• Bug fixes

  Fixes several memory leak bugs in the community version.

--

20201031

5.6.16

• Bug fixes

  • Fixes an issue where subqueries within an IN clause are invalid.

  • Fixes a process permission error.

  • Fixes a user authorization issue in the `kill_user_list` table.

  • Fixes an error with the DROP DATABASE statement.

  • Fixes an issue where the `PREVIOUS_GTID` event causes an incorrect `SECONDS_BEHIND_MASTER` calculation.

20240601

20200831

5.6.16

• New features

  Supports outputting various LSN values of the Redo Log:

  • innodb_lsn: The LSN number of the redo log.

  • innodb_log_write_lsn: The LSN of the log write.

  • innodb_log_checkpoint_lsn: The LSN of the last checkpoint.

  • innodb_log_flushed_lsn: The LSN of the redo log flushed to disk.

  • innodb_log_Pages_flushed: The LSN of the page flush.

• Bug fixes

  • Fixes a `SHOW_HA_ROWS` type error.

  • Fixes an IPK field count error in the process context.

  • Fixes a server crash issue caused by querying INFORMATION_SCHEMA.

  • Fixes an infinite loop issue in the audit refresh thread.

  • Fixes an issue where the secondary instance does not report primary-secondary delay.

20240601

20200630

5.6.16

• New features

  • Performance Agent: A more convenient performance data statistics solution. It collects and counts various internal performance data of a MySQL instance through a MySQL plugin.

  • Increases the upper limit of connections to a maximum of 500,000.

  • Faster DDL: Optimizes the buffer pool management mechanism during DDL operations, reducing the performance impact of DDL operations and increasing the concurrency of Online DDL operations.

• Performance optimizations

  • Adds the global parameter `max_execution_time`. SQL statements that exceed this time limit during execution are interrupted.

  • Internal optimizations for the thread pool.

• Bug fixes

  • Fixes an issue where the wait count for reading client commands is incorrect.

  • Fixes an issue where standard accounts do not have permission to execute the `DROP DATABASE` command.

20240601

20200430

5.6.16

• New features

  • Adds the `mdl_info` table to store MDL lock information.

• Bug fixes

  • Resolves a conflict between enabling the thread pool and the `ic_reduce` (flash sale) feature simultaneously.

20240601

20200331

5.6.16

• Performance optimizations

  • Improves the performance of the thread pool with default configurations.

  • Disables the output of TCP errors by default.

• Bug fixes

  • Fixes an issue where temporary files are included when cleaning up large files.

20240601

20200229

5.6.16

• New features

  • Supports the Proxy read/write splitting feature.

• Performance optimizations

  • Optimizes the thread pool feature.

  • Optimizes the execution time of the `pause` instruction on different CPU architectures.

• Bug fixes

  • Fixes a partial commit issue with XA transactions.

20240601

20200110

5.6.16

• New features

  • Thread Pool: Separates threads from sessions, allowing a small number of threads to complete tasks for many active sessions.

• Performance optimizations

  • Cancels the linking of small files during asynchronous file cleanup.

• Bug fixes

  • Fixes an issue where the sleep time calculation for the page cleaner is incorrect.

  • Fixes a failover failure issue caused by SELECT @@global.gtid_executed.

  • Fixes the IF CLIENT KILLED AFTER ROLLBACK TO SAVEPOINT PREVIOUS STMTS COMMITTED issue.

20240601

20191212

5.6.16

• Performance optimizations

  • Deletes unnecessary tcp error logs.

20240601

20191115

5.6.16

• Bug fixes

  • Fixes a slow query log timestamp overflow issue.

20240601

20191101

5.6.16

• Bug fixes

  • Fixes an issue where switching slow logs occurs during log flushing. Slow logs are switched only when explicitly flushed.

  • Corrects some display errors.

20240601

20191015

5.6.16

• New features

  • Rotate slow logs: To ensure zero data loss when collecting slow query logs, the log rotation table renames the csv data file of the slow log table to a unique name and creates a new file. You can use show variables like '%rotate_log_table%'; to check if slow log rotation is enabled.

  • SM4 encryption algorithm: Adds a new SM4 encryption algorithm to replace the old SM encryption algorithm.

  • Purge Large File Asynchronously: When deleting a single tablespace, renames the tablespace file to a temporary file and waits for an asynchronous cleanup process to clean up the temporary file.

  • TCP error message: Returns TCP direction (read, read wait, write wait) errors and error codes to the `end_connection` event, and outputs error messages to the error log.

  • Introduces an audit log buffer mechanism to improve audit log performance.

• Bug fixes

  • Disables pstack to avoid unresponsiveness when there are many connections.

  • Fixes a conflict between implicit primary keys and the create table as select statement.

  • Automatically cleans up temporary files created by binary logs.

20240601

20190815

5.6.16

• Performance optimizations

  • Optimizes instance lock state: Allows `drop` or `truncate` table operations when the instance is in a locked state.

20240601

20190130

5.6.16

• Bug fixes

  • Fixes some bugs that could cause system instability.

20240601

20181010

5.6.16

• Performance optimizations

  • Adds the parameter `rocksdb_ddl_commit_in_the_middle` (MyRocks). If this parameter is enabled, some DDL operations will perform a commit during execution.

20240601

201806**

5.6.16

• New features

  • Slow log precision is improved to microseconds.

20240601

20180426

5.6.16

• New features

  • Introduces hidden indexes, supporting setting indexes as invisible. For more information, see Reference documentation.

• Bug fixes

  • Fixes a bug in the secondary database apply thread.

  • Fixes a performance degradation issue when updating partitioned tables on the secondary database.

  • Fixes an issue where altering a TokuDB table comment rebuilds the entire engine data. For more information, see Reference documentation.

  • Fixes a potential deadlock issue triggered by `show slave status`/`show status`.

20240601

20171205

5.6.16

• Bug fixes

  • Fixes a deadlock issue triggered when `OPTIMIZE TABLE` and `ONLINE ALTER TABLE` are executed simultaneously.

  • Fixes a conflict issue between SEQUENCE and implicit primary keys.

  • Fixes a `SHOW CREATE SEQUENCE` issue.

  • Fixes an incorrect table statistic issue for TokuDB engine tables.

  • Fixes a deadlock issue introduced by parallel `OPTIMIZE` table operations.

  • Fixes a character set issue recorded in `QUERY_LOG_EVENT`.

  • Fixes a database stop issue caused by signal handling. For more information, see Reference documentation.

  • Fixes an issue introduced by `RESET MASTER`.

  • Fixes an issue where the secondary database gets stuck waiting.

  • Fixes a state maintenance issue after a primary node switchover in the RDS Enterprise Edition.

  • Fixes a potential process crash issue triggered by `SHOW CREATE TABLE`.

20240601

20170927

5.6.16

• Bug fixes

  • Fixes an issue where a TokuDB table query uses the wrong index.

20240601

20170901

5.6.16

• New features

  • Upgrades SSL encryption to TLS 1.2. For more information, see Reference documentation.

  • Supports SEQUENCE.

• Bug fixes

  • Fixes an issue where a NOT IN query returns an incorrect result set in specific scenarios.

20240601

20170530

5.6.16

• New features

  • Supports privileged accounts killing connections under other accounts.

20240601

20170221

5.6.16

• New features

  • Supports enabling proxy terminals.

20240601

Minor version

Description

20181212

• Bug fixes

  • Fixes an issue where the return value of the system function gettimeofday(2) is inaccurate. This system function returns time, which is commonly used to calculate wait timeouts. Inaccurate time leads to incorrect wait timeout calculations.