Skip to content
logo
Percona Server for MySQL
Percona Server for MySQL 8.0.21-12 (2020-10-13)
Initializing search
    percona/psmysql-docs
    percona/psmysql-docs
    • Home
      • The Percona XtraDB storage engine
      • List of features available in Percona Server for MySQL releases
      • Percona Server for MySQL feature comparison
      • Changed in Percona Server 8.0
      • Understand version numbers
      • Install Percona Server for MySQL
        • Install using APT repository
        • Files in DEB package
        • Build APT packages
        • Install from downloaded DEB packages
        • Apt pinning
        • Run Percona Server for MySQL
        • Uninstall
        • Install using a RPM repository
        • Files in RPM package
        • Install from downloaded RPM packages
        • Run Percona Server for MySQL
        • Uninstall
        • Install with binary tarballs
        • Binary tarballs available
        • Install Percona Server for MySQL from a source tarball
        • Compile Percona Server for MySQL 8.0 from source
      • Post-installation
      • Percona Server for MySQL in-place upgrading guide: from 5.7 to 8.0
      • Upgrade using the Percona repositories
      • Upgrade from systems that use the MyRocks or TokuDB storage engine and partitioned tables
      • Upgrade using Standalone Packages
      • Running Percona Server for MySQL in a Docker Container
      • Docker environment variables
      • Improved InnoDB I/O scalability
      • Adaptive network buffers
      • Multiple page asynchronous I/O requests
      • Thread pool
      • XtraDB performance improvements for I/O-bound highly-concurrent workloads
      • Prefix index queries optimization
      • Limit the estimation of records in a Query
      • Jemalloc memory allocation profiling
      • The ProcFS plugin
      • Binary logs and replication improvements
      • Compressed columns with dictionaries
      • Extended SELECT INTO OUTFILE/DUMPFILE
      • Extended SET VAR optimizer hint
      • Improved MEMORY storage engine
      • Suppress warning messages
      • Limiting the disk space used by binary log files
      • Support for PROXY protocol
      • SEQUENCE_TABLE(n) function
      • Slow query log rotation and expiration
      • Trigger updates
      • Extended mysqlbinlog
      • Extended mysqldump
      • InnoDB full-text search improvements
      • Too many connections warning
      • Handle corrupted tables
      • Percona Toolkit UDFs
      • Kill idle transactions
      • XtraDB changed page tracking
      • Enforcing storage engine
      • Expanded fast index creation
      • Backup locks
      • Audit log plugin
      • Start transaction with consistent snapshot
      • Extended SHOW GRANTS
      • Utility user
      • Working with SELinux
      • Working with AppArmor
      • PAM authentication plugin
      • Server variables
      • SSL improvements
      • Data masking
        • Using LDAP authentication plugins
        • LDAP authentication plugin system variables
        • Data at Rest Encryption
        • Use the keyring component or keyring plugin
          • Using the Key Management Interoperability Protocol (KMIP)
          • Use the Amazon Key Management Service (AWS KMS)
          • FIDO authentication plugin
        • Encryption functions
        • Encrypt file-per-table tablespace
        • Encrypt a schema or a general tablespace
        • Encrypt the system tablespace
        • Encrypt temporary files
        • Encrypt binary log files and relay log files
        • Encrypting the Redo Log data
        • Encrypt the undo tablespace
        • Rotate the Master key
        • Work with Advanced Encryption Key Rotation
        • Encrypt doublewrite buffers
        • Verify the encryption for tables, tablespaces, and schemas
      • User statistics
      • Slow query log
      • Extended show engine InnoDB status
      • Show storage engines
      • Process list
      • Misc. INFORMATION_SCHEMA tables
      • Thread based profiling
      • InnoDB page fragmentation counters
      • Stacktrace
      • Libcoredumper
      • Manage group replication flow control
      • Group replication system variables
      • Percona MyRocks introduction
      • Percona MyRocks installation guide
      • Updated supported features
      • MyRocks limitations
      • Differences between Percona MyRocks and Facebook MyRocks
      • MyRocks Information Schema tables
      • MyRocks server variables
      • MyRocks status variables
      • Gap locks detection
      • Data loading
      • Installing and configuring Percona Server for MySQL with ZenFS support
      • TokuDB introduction
      • TokuDB installation
      • Use TokuDB
      • Fast updates with TokuDB
      • TokuDB files and file types
      • TokuDB file management
      • TokuDB background ANALYZE TABLE
      • TokuDB variables
      • TokuDB status variables
      • TokuDB fractal tree indexing
      • TokuDB troubleshooting
      • TokuDB Performance Schema integration
      • Frequently asked questions
      • Migrate and removing the TokuDB storage engine
      • Percona TokuBackup
      • Release notes index
      • Percona Server for MySQL 8.0.30-22 Update (2022-11-21)
      • Percona Server for MySQL 8.0.30-22 (2022-11-21)
      • Percona Server for MySQL 8.0.29-21 (2022-08-08)
      • Percona Server for MySQL 8.0.28-20 (2022-06-20)
      • Percona Server for MySQL 8.0.28-19 (2022-05-12)
      • Percona Server for MySQL 8.0.27-18 (2022-03-02)
      • Percona Server for MySQL 8.0.26-17 (2022-01-26)
      • Percona Server for MySQL 8.0.26-16 (2021-10-20)
      • Percona Server for MySQL 8.0.25-15 (2021-07-13)
      • Percona Server for MySQL 8.0.23-14 (2021-05-12)
      • Percona Server for MySQL 8.0.22-13 (2020-12-14)
      • Percona Server for MySQL 8.0.21-12 (2020-10-13)
        • Improvements
        • Bugs Fixed
      • Percona Server for MySQL 8.0.20-11 (2020-07-21)
      • Percona Server for MySQL 8.0.19-10 (2020-03-23)
      • Percona Server for MySQL 8.0.18-9
      • Percona Server for MySQL 8.0.17-8
      • Percona Server for MySQL 8.0.16-7
      • Percona Server for MySQL 8.0.15-6
      • Percona Server for MySQL 8.0.15-5
      • Percona Server for MySQL 8.0.14
      • Percona Server for MySQL 8.0.13-4
      • Percona Server for MySQL 8.0.13-3
      • Percona Server for MySQL 8.0.12-2rc1
      • List of upstream MySQL bugs fixed in Percona Server for MySQL 8.0
      • List of variables introduced in Percona Server for MySQL 8.0
      • Development of Percona Server for MySQL
      • Trademark policy
      • Index of INFORMATION_SCHEMA tables
      • Frequently asked questions
      • Copyright and licensing information
      • Glossary

    • Improvements
    • Bugs Fixed

    Percona Server for MySQL 8.0.21-12 (2020-10-13)¶

    • Installation Installing Percona Server for MySQL

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

    This release fixes the security vulnerability CVE-2020-26542.

    Improvements¶

    • PS-7132: Make default value of rocksdb_wal_recovery_mode compatible with InnoDB

    • PS-7245: Block enable/disable redo log with lock tables for backup

    • PS-5730: Change SELECT rotate_system_key to ALTER INSTANCE for percona system key rotation.

    • PS-7297: Modify MTR test to prevent proxy_protocol_admin_port test failure on 8.0.21

    • PS-7114: Enhance crash artifacts (core dumps and stack traces) to provide additional information to the operator

    • PS-5635: Introduce crypt_schema 2 for better error checking in encryption threads.

    Bugs Fixed¶

    • PS-7203: Fix audit plugin memory leak on replicas when opening tables

    • PS-6067: Provide a fix for upstream bug #97001 in Percona Server (Upstream #97001)

    • PS-7325: Modify SELECT to correct situation when data is missing from MyRocks table when GROUP BY is used

    • PS-7275: Add variable Innodb_checkpoint_max_age

    • PS-7232: Modified Multithreaded Replica to correct the exhausted slave_transaction_retries when replica has slave_preserve_commit_order enabled (Upstream #99440)

    • PS-7231: Modify Slave_transaction::retry_transaction() to call mysql_errno() only when thd->is_error() is true

    • PS-7221: Modify get_int_sort_key_for_item_inline to return UTC string (Upstream #100402)

    • PS-7143: Suppress deadlock check for ACL Cache MDL lock to prevent server freeze

    • PS-7076: Modify to not update Cardinality after setting tokudb_cardinality_scale_percent

    • PS-7025: Fix reading ahead of insert buffer pages by dispatching of buffered AIO transfers (Upstream #100086)

    • PS-7010: Modify to Lock buffer blocks before sanity check in btr_cur_latch_leaves

    • PS-6995: Introduce a new optimizer switch to allow the user to reduce the cost of a range scan to determine best execution plan for Primary Key lookup

    • PS-7279: Modify to notify when BuildID: Not Available in case the server has been compiled with –build-id=none

    • PS-7220: Fix activity counter update in purge coordinator and workers

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

    • PS-5741: Correct format for use of memset_s in keyring_vault

    • PS-5323: Align Keyring encryption with Master Key encryption

    • PS-7363: Modify to release locks on failure to prevent deadlock with LTFB + DROP UNDO TABLESPACE

    • PS-7360: Modify clang-4.0 compilation to correct failure from ‘-Winconsistent-missing-destructor-override’

    • PS-7359: Stabilize innodb.check_ibd_filesize_16k MTR test

    • PS-7353: Modify LDAP connection to server to be static to prevent connection failures which will lock mysqld

    • PS-7352: Correct typo in authentication_ldap_simple_ca_path to correct crash of mysqld

    • PS-7340: Add validation of default_table_encryption to confirm keyring plugin is loaded before changing modes

    • PS-7338: Set set crypt_data based on encryption status of destination table

    • PS-7328: Block create/alter/drop/undo truncation while backup lock is available and hold lock until operation is completed

    • PS-7322: Modify the right mask length calculation to handle up to string length for Data Masking

    • PS-7321: Correct Random Number Generator to create only 15 or 16 digit number in Data Masking

    • PS-7309: Modify gen_range() to support negative numbers in Data Masking

    • PS-7308: Modify limit gen_dictionary_load() to load files only from the secure-file-priv dir when secure-file-priv dir is set in Data Masking

    • PS-7307: Modify Data masking UDFs to display output using Latin1 character set

    • PS-7296: Fix online log tracking initialization to properly process existing bitmap files

    • PS-7289: Restrict innodb encryption threads to 255 and add min/max values

    • PS-7270: Fix admin_port to accept non-proxied connections when proxy_protocol_networks=’*’

    • PS-7234: Modify PS minimal tarballs to remove COPYING.AGPLv3

    • PS-7226: Modify LDAP Plugin to enhance logging and test cases

    • PS-7191: Correct documentation for PS variable default_table_encryption

    • PS-7147: Modified Relay_log_info::cannot_safely_rollback() to handle null pointer

    • PS-7140: Correct processing to apply crypt redo logs

    • PS-7120: Handle doublewrite buffer encryption for keyring key tablespaces

    • PS-7119: Correct Tests of encryption.innodb_encryption_aborted_rotation* to prevent failure

    • PS-6987: Modify to allow value of default_table_encryption to be changed only when encryption_threads are off

    • PS-7284: Fix failing test innodb.percona_changed_page_bmp_requests_debug

    Contact us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.


    Last update: 2022-09-22
    Back to top
    Percona LLC and/or its affiliates, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.