Percona Server for MySQL 8.0.42-33 (2025-05-19)

Get started with Quickstart Guide for Percona Server for MySQL.

Percona Server for MySQL 8.0.42-33 includes all the features and bug fixes available in the MySQL 8.0.42 Community Edition and enterprise-grade features developed by Percona.

Release highlights

Percona Server for MySQL 8.0.42-33

• Improves the audit_log_filter_set_user() UDF to accept account names with wildcard characters ('%' and '_') in the host part. For example, you can use ‘usr1@%', ‘usr2%192.168.0.%’, or 'usr3@%.mycorp.com'.

• Updates the C++ level of the KMPI library to enhance error handling capabilities.

• Improves optimizer behavior by restoring correct handling of const tables in test_quick_select(). A MySQL Upstream refactor (commit 9a13c1c) removed the QEP_TAB dependency, causing get_quick_record_count() to no longer pass const table information. This could lead to suboptimal range scan boundaries. The applied patch resolves the issue by explicitly passing const_tables to test_quick_select(), ensuring consistent behavior with the pre-refactor logic.

The latest MyRocks storage engine incorporates code based on RocksDB version 9.3.1. Percona has applied minor modifications to the original RocksDB codebase. Check the list of modifications at https://github.com/percona/rocksdb/.

This release adds the following changes to the list of MyRocks variables.

Adds new MyRocks variables

• --rocksdb_bulk_load_compression_parallel_threads
• --rocksdb_bulk_load_enable_unique_key_check
• --rocksdb_debug_skip_bloom_filter_check_on_iterator_bounds
• --rocksdb_enable_udt_in_mem
• --rocksdb_invalid_create_option_action
• --rocksdb_io_error_action
• --rocksdb_table_stats_skip_system_cf
• --rocksdb_use_io_uring
• --rocksdb_enable_instant_ddl
• --rocksdb_enable_instant_ddl_for_append_column
• --rocksdb_enable_instant_ddl_for_column_default_changes
• --rocksdb_enable_instant_ddl_for_drop_index_changes
• --rocksdb_enable_instant_ddl_for_table_comment_changes
• --rocksdb-bulk-load-compression-parallel-threads
• --rocksdb-bulk-load-enable-unique-key-check
• --rocksdb-debug-skip-bloom-filter-check-on-iterator-bounds

Changes default values of MyRocks variables

• --rocksdb_disable_instant_ddl - the default value is changed from ON to OFF.

• --rocksdb_file_checksums - the data type is changed from Boolean to ENUM. Also, the default value is changed from OFF to CHECKSUMS_OFF.

• --rocksdb_compaction_readahead_size - the default value is changed from 0 (zero) to 2097152.

Deprecates MyRocks variable

• --rocksdb_disable_instant_ddl - this variable is being deprecated and is expected to be removed in a future release.

Removes MyRocks variables

• --rocksdb-access-hint-on-compaction-start
• --rocksdb_large_prefix
• --rocksdb_strict_collation_check
• --rocksdb_strict_collation_exceptions

MySQL 8.0.42

Improvements and bug fixes provided by Oracle for MySQL 8.0.42 and included in Percona Server for MySQL are the following:

• Fixed an issue where CHECK TABLE sometimes incorrectly reported that spatial indexes were corrupted. (Bug #37286473)

• Fixed an issue in InnoDB redo log recovery to improve data safety after a crash. (Bug #37061960)

• Fixed an issue where reading index_id values could lead to incorrect behavior with indexes. (Bug #36993445, Bug #37709706)

• Fixed a bug related to the lower_case_table_names setting that caused inconsistent behavior with table names on different systems. (Bug #32288105)

• Fixed a bug where mysqldump did not properly escape certain special characters in its output. (Bug #37540722, Bug #37709163)

• The fprintf_string() function in mysqldump did not use the correct quote character for escaping strings. (Bug #37607195)

Find the complete list of bug fixes and changes in the MySQL 8.0.42 Release Notes.

Improvements

• PS-9024: Improves the audit_log_filter_set_user() UDF to accept account names with wildcard characters ('%' and '_') in the host part.

• PS-9561: Updates the C++ level of the KMPI library to enhance error handling capabilities.

• PS-9765: Updates the list of MyRocks variables. You can find the list of variables in MyRocks server variables.

Bug Fixes

• PS-9033: The audit_log_filter plugin did not register remote accesses.

• PS-9390: In some cases, using JSON_TABLE inside an IN or EXISTS subquery caused incorrect results. This happened when the subquery referred to a table from the main query, and a semijoin optimization was applied. Percona merged the fix from MySQL.

• PS-9609: The audit_log_filter plugin could not be installed when Percona Server was using component_keyring_kmip.

• PS-9628: The binlog_encryption did not work with component_keyring_kmip.

• PS-9703: In-place ALTER TABLE operations that internally rebuilt tables sometimes resulted in lost rows if a concurrent purge happened.

• PS-9719: When binlog_transaction_dependency_tracking was changed during a high-load workload, MySQL encountered a segmentation fault.

• PS-9723: MySQL server exited in xpl::Ssl_context::~Ssl_context() under heavy load of ALTER INSTANCE RELOAD TLS queries.

• PS-9753: Applied an optimizer patch from Enhanced MySQL to restore correct handling of const tables in test_quick_select().

• PS-9764: Added clang-20 to Azure Pipelines and fixed clang-20 compilation issues.

• PS-9777: The binlog_utils_udf plugin did not handle binlog.index entries the same as the Percona Server code did.

• PS-9780: The maximum size of audit_log_filter rule was increased from 1024 characters to 16 000 characters.

• PS-9661: The encryption of system tablespaces using component_keyring_kmip failed.

Useful links

Install Percona Server for MySQL 8.0

Upgrade Percona Server for MySQL from 5.7 to 8.0

The Percona Server for MySQL GitHub repository

Download product binaries, packages, and tarballs at Percona Product Downloads

Contribute to the documentation

For training, contact Percona Training - Start learning now