Percona Server for MySQL 8.0.20-11 (2020-07-21)¶
- Installation Installing Percona Server for MySQL
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