Skip to content

Percona Server for MySQL 8.0.30-22 (2022-11-21)

Release date November 21, 2022
Install instructions Install Percona Server for MySQL
Download this version Percona Server for MySQL

Percona Server for MySQL 8.0.30-22 includes all the features and bug fixes available in the MySQL 8.0.30 Community Edition in addition to enterprise-grade features developed by Percona.

Percona Server for MySQL is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation.

Percona Server for MySQL is trusted by thousands of enterprises to provide better performance and concurrency for their most demanding workloads. It delivers more value to MySQL server users with optimized performance, greater performance scalability and availability, enhanced backups, and increased visibility.

For training, contact Percona Training - Start learning now

Release highlights

The following features are Generally Available (GA):

The following features, variables, or options are available only in tech preview:

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

  • Supports Generated Invisible Primary Keys(GIPK). This feature automatically adds a primary key to InnoDB tables without a primary key. The generated key is always named my_row_id. The GIPK feature is not enabled by default. Enable the feature by setting sql_generate_invisible_primary_key to ON.

  • The InnoDB_doublewrite system has two new settings:

  • DETECT_ONLY. This setting allows only metadata to be written to the doublewrite buffer. Database page content is not written to the buffer. Recovery does not use the buffer to fix incomplete page writes. Use this setting only when you need to detect incomplete page writes.

  • DETECT_AND_RECOVER. This setting is equivalent to the current ON setting. The doublewrite buffer is enabled. Database page content is written to the buffer and the buffer is accessed to fix incomplete page writes during recovery.

  • The -skip_host_cache server option is deprecated and will be removed in a future release. Use SET GLOBAL host_cache_size= 0 or set host_cache_size = 0.

Find the full list of bug fixes and changes in the MySQL 8.0.30 Release Notes.

New features

Improvements

Bug fixes

  • PS-8204: A fix for when the audit_log_format was set to XML and the logged queries were truncated after a newline character.

  • PS-8246: Adapted the Encryption UDF MTR test cases to OpenSL 3.0.x. The tests failed because OpenSSL 3.0.x has a different default set of hash functions and PEM reading and writing routines generate different error messages.

  • PS-8351: The SHOW ENGINE INNODB STATUS would output unreadable UTF characters.

  • PS-8364: When using Docker, the data directory for ICU regular expressions was missing.

  • PS-8175: While a thread executes fil_io_set_encryption(), another thread may change the space->encryption_type. If this happens, an assertion in fil_io_set_encryption() caused an unexpected server exit.

  • PS-8428: A fix for an unexpected server exit when --innodb_encrypt_online_alter_logs=ON and ALTER TABLE <tablename> ADD FULLTEXT was executed.

Platform support

  • Percona Server for MySQL 8.0.30 supports Oracle Linux/Red Hat Enterprise Linux 9.

  • Percona Server for MySQL 8.0.30 supports Ubuntu 22.04.

The Percona Server for MySQL GitHub location

Contribute to the documentation

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.


Last update: 2023-09-27