Skip to content

For help, click the link below to get free database assistance or contact our experts for personalized support.

Percona Server for MySQL 8.0.20-11 (2020-07-21)

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

As of 8.0.20-11, the Percona Parallel Doublewrite buffer implementation has been removed and has been replaced with the Oracle MySQL implementation.

New Features

  • PS-7128: Add RocksDB variables: rocksdb_max_background_compactions, rocksdb_max_background_flushes, and rocksdb_max_bottom_pri_background_compactions

  • PS-7039: Add RocksDB variable: rocksdb_validate_tables

  • PS-6951: Add RocksDB variables: rocksdb_delete_cf, rocksdb_enable_iterate_bounds, and rocksdb_enable_remove_orphaned_dropped_cfs

  • PS-6926: Add RocksDB variables: rocksdb_table_stats_recalc_threshold_pct, rocksdb_table_stats_recalc_threshold_count, rocksdb_table_stats_background_thread_nice_value, rocksdb_table_stats_max_num_rows_scanned, rocksdb_table_stats_use_table_scan.

  • PS-6910: Add RocksDB variable: rocksdb_stats_level.

  • PS-6902: Add RocksDB variable: rocksdb_enable_insert_with_update_caching.

  • PS-6901: Add RocksDB variable: rocksdb_read_free_rpl.

  • PS-6891: Add RocksDB variable: rocksdb_master_skip_tx_api.

  • PS-6890: Add RocksDB variable: rocksdb_blind_delete_primary_key.

  • PS-6886: Add RocksDB variable: rocksdb_cache_dump.

  • PS-6885: Add RocksDB variable: rocksdb_rollback_on_timeout.

Improvements

  • PS-6994: Implement rocksdb_validate_tables functionality in Percona Server 8.X

  • PS-6984: Update the zstd submodule to v1.4.4.

  • PS-5764: Introduce SEQUENCE_TABLE() table-level SQL function

Bugs Fixed

  • PS-7019: Correct query results for LEFT JOIN with GROUP BY (Upstream #99398)

  • PS-6979: Modify the processing to call clean up functions to remove CREATE USER statement from the processlist after the statement has completed (Upstream #99200)

  • PS-6860: Merge innodb_buffer_pool_pages_LRU_flushed into buf_get_total_stat()

  • PS-7038: Set innodb-parallel-read_threads=1 to prevent kill process from hanging (Thanks to user wavelet123 for reporting this issue)

  • PS-6945: Correct tokubackup plugin process exported API to allow large file backups. (Thanks to user prohaska7 for reporting this issue)

  • PS-7000: Fix newer collations for proper space padding in MyRocks

  • PS-6991: Modify package to include missing development files (Thanks to user larrabee for reporting this issue)

  • PS-6946: Correct tokubackup processing to free memory use from the address and thread sanitizers (Thanks to user prohaska7 for reporting this issue)

  • PS-5893: Add support for running multiple instances with systemD on Debian. (Thanks to user sasha for reporting this issue)

  • PS-5620: Modify Docker image to support supplying custom TLS certificates (Thanks to user agarner for reporting this issue)

  • PS-7168: Determine if file per tablespace using table flags to prevent assertion

  • PS-7161: Fixed ‘CreateTempFile’ gunit test to support both ‘HAVE_O_TMPFILE’-style

  • PS-7142: Set ‘KEYRING_VAULT_PLUGIN_OPT’ value when required

  • PS-7138: Correct file reference for ps-admin broken in tar.gz package

  • PS-7127: Provide mechanism to grant dynamic privilege to the utility user.

  • PS-7118: Add ability to set LOWER_CASE_TABLE_NAMES option before initializing data directory

  • PS-7116: Port MyRocks fix of Index Condition Pushdown (ICP)

  • PS-7075: Provide binary tarball with shared libs and glibc suffix

  • PS-6974: Correct instability in the rocksdb.drop_cf_* tests

  • PS-6969: Correct instability in the rocksdb.index_stats_large_table

  • PS-6105: Modify innodb.mysqld_core_dump_without_buffer_pool_dynamic test to move assertion to correct location

  • PS-5735: Correct package to install the charsets on CentOS 7

  • PS-4757: Remove CHECK_IF_CURL_DEPENDS_ON_RTMP to build keyring_vault for unconditional test

  • PS-7131: Improve resume_encryption_cond conditional variable handling to avoid missed signals

  • PS-7100: Fix rocksdb_read_free_rpl test to properly count rows corresponding to broken index entries

  • PS-7082: Correct link displayed on help client command

  • PS-7169: Set rocksdb_validate_tables to disabled RocksDB while upgrading the server from 5.7 to 8.0.20


Last update: 2022-09-22