# Percona Server for MySQL 8.0.33-25 (2023-06-15)

<style>
    table {
        width=50%’;
        font-family: Poppins;
    }
    table td {
        border: 0px;
        padding: 8px;
    }
</style>

| Release date | June 15, 2023 |
|--- | --- |
| Install instructions | [Install Percona Server for MySQL](https://docs.percona.com/percona-server/8.0/installation.html) |
| Upgrade instructions | [Percona Server for MySQL in-place upgrading guide: from 5.7 to 8.0](https://docs.percona.com/percona-server/8.0/upgrade.html) |

[Percona Server for MySQL 8.0.33-25](https://www.percona.com/software/mysql-database/percona-server) includes all the features and bug fixes available in the
[MySQL 8.0.33 Community Edition](https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-33.html) in addition to enterprise-grade features developed by Percona.

Percona Server for MySQL is a freely available, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior and optimized performance, greater scalability, and availability, enhanced backups, increased visibility and instrumentation.

Percona Server for MySQL is trusted by thousands of enterprises to provide better performance and concurrency for their most demanding workloads.

## Release highlights

* This release adds the following MyRocks variables:

  * `rocksdb_bulk_load_use_sst_partitioner`

  * `rocksdb_use_hyper_clock_cache`

  * `rocksdb_converter_record_cached_length`

  * `rocksdb_alter_table_comment_inplace`

  * `rocksdb_charge_memory`

  * `rocksdb_column_default_value_as_expression`

  * `rocksdb_corrupt_data_action`

  * `rocksdb_disable_instant_ddl`

  * `rocksdb_enable_delete_range_for_drop_index`

  * `rocksdb_partial_index_blind_delete`

  * `rocksdb_protection_bytes_per_key`

  * `rocksdb_use_write_buffer_manager`

* This release adds a new MyRocks Information Schema Table `ROCKSDB_LIVE_FILES_METADATA`.

* This release removes `rocksdb_instant_ddl` variable. Use `rocksdb_disable_instant_ddl` instead. 

* This merge fixes the following issues:
  
  * [PS-8477](https://jira.percona.com/browse/PS-8477): The offline-mode persisted when doing `dba.rebootClusterFromCompleteOutage`. 

  * [PS-8699](https://jira.percona.com/browse/PS-8699): `ALTER INSTANCE RELOAD TLS` hung with many concurrent connection attempts. We have included the upstream fix and added our fix for this issue, which significantly reduces the chances that the issue will reoccur.

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

* The `INSTALL COMPONENT` includes the `SET` clause. The `SET` clause sets the values of component system variables when installing one or several components. This reduces the inconvenience and limitations associated with assigning variable values in other ways.

* The mysqlbinlog `--start-position` accepts values up to `18446744073709551615`. If the `--read-from-remote-server` or `--read-from-remote-source` option is used, the maximum is `4294967295`. (Bug #77818, Bug #21498994)

* Using a generated column with `DEFAULT(col_name)` to specify the default value for a named column is not allowed and throws an error message. (Bug #34463652, Bug #34369580)

* Not all possible error states were reported during the binary log recovery process. (Bug #33658850)

* User-defined collations are deprecated. The usage of the following user-defined collations causes a warning that is written to the log:

  * When `COLLATE` is followed by the name of a user-defined collation in an SQL statement.

  * When the name of a user-defined collation is used as the value of `collation_server`, `collation_database`, or `collation_connection`.

The support for user-defined collations will be removed in a future releases of MySQL.

Find the full list of bug fixes and changes in the [MySQL 8.0.33 Release Notes](https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-33.html).

## New features

* [PS-8188](https://jira.percona.com/browse/PS-8188): Adds the `clone_exclude_plugins_list` variable. By default, the list of installed plugins on the donor and recipient must match. The `clone_exclude_plugins_list` variable allows for specifying the list of plugin exceptions.

## Bug fixes

* [PS-8647](https://jira.percona.com/browse/PS-8647): `tmp_table_size=51200` caused server exit.

* [PS-8683](https://jira.percona.com/browse/PS-8683): Concurrent execution of `FLUSH STATUS`, `COM_CHANGE_USER`, and `SELECT FROM I_S.PROCESSLIST` led to deadlock. The deadlock affected connections executing the mentioned commands and other connections and made it impossible to shut down the server properly.

* [PS-8713](https://jira.percona.com/browse/PS-8713): `mysql_binlog_xxx()` symbols were not exported in `lybmysqlclient.so`.

* [PS-8719](https://jira.percona.com/browse/PS-8719): Audit log plugin stalled on flush.

* [PS-8747](https://jira.percona.com/browse/PS-8747): When Federated SE internal proxy-server connection timeout occured, `Got an error writing communication packets` was reported back to the user while the actual operation was successful.

## Useful links

The [Percona Server for MySQL GitHub location](https://github.com/percona/percona-server)

Download product binaries, packages, and tarballs at [Percona Product Downloads](https://www.percona.com/downloads)

[Contribute to the documentation](https://github.com/percona/psmysql-docs/blob/8.0/contributing.md)

For [training](https://www.percona.com/training), contact [Percona Training - Start learning now](https://learn.percona.com/contact-me)