Minor version | Community version | Description | Version expiration date |
20251031 | 8.0.36 | | |
20250731 | 8.0.36 | | — |
20250531 | 8.0.36 | | — |
20241231 | 8.0.36 | | — |
20241130 | 8.0.36 | | — |
20241031 | 8.0.36 | | — |
20240930 | 8.0.36 | New features Bug fixes Fixed an instance crash issue caused by performing an `Update` operation on a column added by an Instant DDL statement. Fixed an instance crash issue caused by performing a `Delete` or `Update` operation on a column deleted by an Instant DDL statement.
| — |
20240731 | 8.0.36 | | — |
20240630 | 8.0.36 | Bug fixes Fixed an unexpected behavior in the internal permission management of system tables. User accounts can now perform `TRUNCATE` operations on tables under Performance Schema. Fixed a potential memory leak issue when recording redo logs for tables that have undergone an INSTANT DDL operation.
| — |
20240615 | 8.0.36 | | —— |
20240531 | 8.0.36 | | — |
20240522 | 8.0.34 | | — |
20240229 | 8.0.34 | New features Upgraded the OpenSSL version to 3.0.12. Added a feature to record DDL statements in diagnostic logs. Added the Confidential database (public preview) feature, which implements end-to-end data encryption to protect data security.
Bug fixes
| — |
20240131 | 8.0.34 | Bug fixes Fixed an issue where memory counts in the `performance_schema.memory_summary_by_thread_by_event_name` table were inflated when the thread pool was enabled. Fixed an issue where duplicate entry errors frequently occurred in auto-increment columns after an X-Engine instance restart. Fixed an issue that caused the “ERROR 1878 (HY000): Temporary file write failure.” error when you created a full-text index with innodb_disable_sort_file_cache set to ON. Fixed an issue where the parser for a full-text index did not take effect when rebuilt using an INPLACE DDL statement. For more information, see Community Bug #110976. Fixed an issue where the automatic cleanup logic on read-only instances did not meet expectations after the `recycle_bin` parameter was modified. Fixed an instance crash issue caused by executing `create sequence` in a prepared statement.
| — |
20230930 | 8.0.34 |
Important In versions prior to the official 8.0.34, the implementation of the skip_scan feature had a defect (Community Bug #107460) that could lead to incorrect query results. We recommend that you disable skip_scan on your instances with older versions or upgrade your instances to a later version. After you upgrade OpenSSL to 3.0.10, TLS 1.0 and TLS 1.1 are automatically disabled. For compatibility purposes, RDS MySQL restores support for TLS 1.0 and TLS 1.1 by changing the default value of the ssl_cipher parameter to "ALL:@SECLEVEL=0" . If your business uses only TLS 1.2 or later, we recommend that you set the ssl_cipher parameter to "" (an empty string) in the RDS console for a higher level of security.
| — |
20230914 | 8.0.31 |
Important Minor versions 20230630 and 20230914 have been unpublished. We recommend that you upgrade instances of these versions to version 20230930 as soon as possible. This bug fix is a temporary fix and is limited to version 20230914.
| — |
20230630 | 8.0.31 | | — |
20230620 | 8.0.28 | Bug fixes Introduced a delayed start for MySQL Group Replication to avoid issues where cluster operations cannot be executed when an instance restarts quickly and reconnects to the cluster. Fixed an issue where transactions could not be committed when Binlog in Redo and Binlog Parallel Flush were running under high load for a long time.
| — |
20230610 | 8.0.28 | Bug fixes Fixed a deadlock issue (manifesting as the instance being unreachable) caused by executing `COM_STATISTICS`, `COM_CHANGE_USER` commands, and the `SHOW PROCESSLIST` statement. For more information, see Community Bug #110494. Fixed an issue where backup jobs could not be executed due to an abnormal exit of a background cleanup task in the X-Engine.
| — |
20230324 | 8.0.28 | | — |
20221231 | 8.0.28 | | — |
20221121 | 8.0.28 | | — |
20220830 | 8.0.28 | | — |
20220730 | 8.0.25 | | — |
20220530 | 8.0.25 | | — |
20220523 | 8.0.25 | BUG fixes Fixed an issue where SELECT COUNT(*) statements without a WHERE clause executed too slowly. Fixed an issue where a stored procedure that uses the WITH ROLLUP syntax crashed when it was called multiple times.
| — |
20220331 | 8.0.25 | New features Removed the restriction that when innodb_buffer_pool_size is less than 1 GB, innodb_buffer_pool_instances cannot be greater than 1. Reduced the performance impact on the instance when the Native Flashback feature is enabled.
Bug fixes Fixed an issue where the Unknown thread id error occurred when you kill a session. Fixed an issue where the rds_expose_priv_list parameter did not take effect after a restart. Fixed an issue where the Binlog in Redo feature blocked the advancement of the CheckPoint offset. Merged bug fixes from the official MySQL community for version 8.0.25 (Bug#33341080, Bug#32962511).
| — |
20210930 | 8.0.25 |
Important The `derived_condition_pushdown` feature was introduced in the official 8.0.22 version. This feature effectively reduces the amount of data scanned within derived tables and improves query speed. However, because this feature ignores User Variables, queries that use user variables return null values and cannot be completed normally. For more information, see the official documentation. Solution: Connect to the MySQL database and execute the set optimizer_switch="derived_condition_pushdown=off"; command to disable the feature. New features Merged changes from official version 8.0.25. Introduced a recovery_apply_binlog mechanism to enable Crash Safe for XA transactions. Audit logs now support V3, adding a separate column for transaction ID and an `ext` field to indicate if an SQL statement was truncated. Allowed new SEQUENCE types to be defined as TIMESTAMP SEQUENCE, which has a different format compared to the original DIGITAL SEQUENCE. Syntax: CREATE SEQUENCE seq CACHE [cache_size] TIMESTAMP; Grants the truncate permission on the mysql.slow_log and mysql.general_log tables to privileged accounts. Added the Native Flashback Query feature, which supports rollback queries and data restoration directly through SQL statements. Added the self-developed X-Tree as an index for the X-Engine MemTable, supporting high-performance writes, point queries, and range queries. Added support for freely adjusting the Buffer Pool size and optimized the adjustment process to avoid affecting instance performance. Multiple blocks can be asynchronously read at a time. You can add the /*+ MULTI_BLOCKS(n) */ hint to an SQL statement to pre-read multiple data pages. Optimized the logic for scanning the Buffer Pool LRU list to get free pages. UPDATE and DELETE statements with a primary key or a unique key automatically enter the CCL queue.
Added TCP write wait time to the `performance_schema.events_statements_summary_by_digest_supplement` table. Allowed DDL statements to record redo logs when executed in In Place mode. The disabled_storage_engines parameter now includes MyISAM by default. This means that you can no longer create tables that use the MyISAM engine.
Bug fixes Fixed an issue where the execution result of SHOW GLOBAL STATUS was abnormal. Fixed an issue where enabling the Jemalloc Profiling feature prevented the instance from starting. Fixed an issue where using a SEQUENCE in an INSERT INTO SELECT statement caused the instance to crash. Revoke the dbms_recycle.restore_table permission. The I_S.INDEX_STATISTICS table now includes the index scan count. The I_S.PERF_STATISTICS table now includes more performance data metrics. Optimized the call performance of user-defined functions (nextval and currval) when they conflict with the SEQUENCE system function. X-Engine supports immediate responses to user-initiated KILL SESSION requests. Fixed an issue in X-Engine where some DDL operations failed and were left in an inconsistent state in extreme scenarios. Added stack overflow protection. Fixed an issue where mysqld failed to start when both persist_binlog_to_redo and X-Engine were enabled. Fixed a memory leak caused by pthread_getattr_np. Automatically clears the Page Cache generated by Performance Agent files. Fixed an internal error in the Statement Outline feature. Fixed an issue where the session tracker was reset when a statement execution failed. Changed the ccl_wait_timeout variable name.
Note ccl_wait_timeout specifies the maximum wait time for throttled statements, in seconds.
Fixed a restart failure issue caused by not cleaning up the socket file when the process exited. Adjusted the priority of user-defined functions (nextval or currval). Fixed the 251 error returned by net_length_size.
| — |
20201031 | 8.0.18 | | 20240601 |
20200831 | 8.0.18 | | 20240601 |
20200630 | 8.0.18 | | 20240601 |
20200430 | 8.0.18 | | 20240601 |
20200331 | 8.0.18 | | 20240601 |
20200229 | 8.0.16 | | 20240601 |
20200110 | 8.0.16 | | 20240601 |
20191225 | 8.0.16 | | 20240601 |
20191115 | 8.0.16 | | 20240601 |
20191101 | 8.0.16 | | 20240601 |
20191015 | 8.0.16 | New features TDE: Added support for transparent data encryption (TDE), which performs real-time I/O encryption and decryption of 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 easy use. Forced conversion of the table engine from MyISAM or MEMORY to InnoDB: If the global variable force_mysiam_to_innodb or force_memory_to_innodb is set to ON, the table engine is automatically converted from MyISAM or MEMORY to InnoDB when you create or modify tables. Prohibited 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 a file rotation method to retain the most recent second-level performance data. Configurable Innodb mutex timeout: You can configure the global variable innodb_fatal_semaphore_wait_threshold, which has a default value of 600. Ignore index hint errors: You can configure the global variable ignore_index_hint_error. The default value is 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 Merged AIO requests before triggering a linear read-ahead in Linux systems that support native AIO. Optimized table/index statistics information. Directly accessed the primary index if a primary key is specified.
| 20240601 |
20190915 | 8.0.16 | | 20240601 |
20190816 | 8.0.16 | New features Thread Pool: Separates threads from sessions, allowing a small number of threads to handle tasks for many active sessions. Statement Concurrency Control: Controls concurrency to handle sudden database request traffic, high resource-consuming statement access, and changes in SQL access models, ensuring the continuous stability of the MySQL instance. Statement Outline: Uses Optimizer Hint and Index Hint to stabilize MySQL execution plans. Sequence Engine: Simplifies the complexity of obtaining sequence values. Purge Large File Asynchronously: When deleting a single tablespace, the tablespace file is renamed to a temporary file, and an asynchronous cleanup process cleans up the temporary file. Performance Insight: A powerful tool for instance load monitoring, association analysis, and performance tuning. It helps you quickly assess database load, find the source of performance issues, and improve database stability. Optimized instance lock state: Tables can be dropped or truncated when the instance is in a locked state.
Bug fixes Fixed a file size calculation error. Fixed an issue where memory was occasionally reused after being freed. Fixed a crash issue when the host cache size was 0. Fixed a conflict between implicit primary keys and CTS statements. Fixed an `slog` error caused by a slow query.
| 20240601 |
20190601 | 8.0.16 | | 20240601 |