Skip to content
Percona Documentation

Percona Server for MySQL 8.3.0-1 (2024-04-16)

Get started with Quickstart Guide for Percona Server for MySQL.

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

Release highlights

This release merges the MySQL 8.3 code base.

Within this merge, Percona updates the Binary Log UDFs to make them compatible with new tagged GTIDs (Global Transaction Identifiers).

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

  • Implements tagged GTIDs to group related transactions. This helps enhance replication management and simplify tracking transaction dependencies.

  • Adds the explain_json_format_version server system variable. This variable allows selection between two JSON output formats for EXPLAIN FORMAT=JSON statements. Version 1, the default, offers the linear format used in prior versions. Version 2 provides an access path-based format, ensuring better future MySQL Optimizer compatibility.

Deprecation or removal

A future release may remove deprecated features, variables and options. The usage of these deprecated items may cause a warning. We recommend migrating from deprecated variables and options as soon as possible.

This release removes the following features, variables and options:

  • The FLUSH HOSTS statement was deprecated in MySQL 8.0.23 and has been removed. To clear the host cache, use TRUNCATE TABLE performance_schema.host_cache or mysqladmin flush-hosts.

  • The --skip-host-cache server option has been removed. Start the server with the --host-cache-size=0 option instead.

  • The --character-set-client-handshake and --old-style-user-limits server options.

  • The usage of writesets for conflict checks when the row-based logging is in effect is restricted. If binlog_transaction_dependency_tracking is set to WRITESET or WRITESET_SESSION, the binlog_format must be ROW. The MIXED value is no longer supported.

  • The Multi-threaded LRU flusher feature is no longer supported.

  • The innodb_parallel_doublewrite_path and innodb_parallel_dblwr_encrypt server options were deprecated in Percona Server 8.0.23 and have had no effect since that time. These options have now been removed.

Review the MySQL 8.3 Release Notes for detailed information and explore the new features!

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-9117: The server exited after setting the innodb_interpreter_output system variable.

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

PS-9125: The printed value of the gtid_next variable contained additional symbols.

PS-9083: The server exited when the slow query log was enabled with additional variables.

PS-9044: Added the following variables to MyRocks:

Changed the default values for the following variables:

The rocksdb_large_prefix is deprecated.

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-05-02