Percona Server for MySQL 8.0.36-28 (2024-03-04)

Get started with Quickstart Guide for Percona Server for MySQL.

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

Release highlights

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

• The hashing algorithm employed yielded poor performance when using a HASH field to check for uniqueness. (Bug #109548, Bug #34959356)

• All statement instrument elements that begin with statement/sp/%, except statement/sp/stmt, are disabled by default.

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

Bug fixes

PS-9018: The replica stalls when log_slave_updates=0 and a Data Definition Language (DDL) operation is executed against a non-replicated database on that replica.

PS-9048: In the Debug build, assets with OPTIMIZE table and fulltext indexes failed.

PS-9083: A fix for a server exit when the slow query log is on with additional variables.

PS-9075: ALTER TABLE ... ALGORITHM=INPLACE failed for table which is no longer encrypted.

PS-9044: Added the following variables to MyRocks:

• rocksdb_block_cache_numshardbits

• rocksdb_check_iterate_bounds

• rocksdb_compact_lzero_now

• rocksdb_file_checksums

• rocksdb_max_file_opening_threads

• rocksdb_partial_index_ignore_killed

Changed the default values for the following variables:

• rocksdb_compaction_sequential_deletes from 0 to 14999

• rocksdb_compaction_sequential_deletes_count_sd from OFF to ON

• rocksdb_compaction_sequential_deletes_window from 0 to 15000

• rocksdb_force_flush_memtable_now from ON to OFF

• rocksdb_large_prefix from OFF to ON

The rocksdb_large_prefix is deprecated.

Known issues

• PS-9078: An upgrade on Ubuntu 20.04 from the following releases does not restart the MySQL service automatically. You must start the service manually.

  • Percona Server for MySQL 8.0.x to Percona Server for MySQL 8.1

  • Percona Server for MySQL 8.0.x to Percona Server for MySQL 8.2

  • Percona Server for MySQL 8.1 to Percona Server for MySQL 8.2

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

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.

Community Forum Get a Percona Expert

---

Last update: 2024-11-15