Changed in Percona Server 8.0

Percona Server for MySQL 8.0 is based on MySQL 8.0 and incorporates many of the improvements found in Percona Server for MySQL 5.7.

Features ported to Percona Server for MySQL 8.0 from Percona Server for MySQL 5.7

The features are listed within the following sections:

SHOW ENGINE INNODB STATUS Extensions

• The Redo Log state

• Specifying the InnoDB buffer pool sizes in bytes

• innodb_print_lock_wait_timeout_info system variable

Performance

• Prefix Index Queries Optimization

• Multiple page asynchronous I/O requests

• Thread Pool

• Priority refill for the buffer pool free list

• Multi-threaded LRU flusher

Flexibility

• InnoDB Full-Text Search Improvements

• Improved MEMORY Storage Engine

• Extended mysqldump

• Extended SELECT INTO OUTFILE/DUMPFILE

• Support for PROXY protocol

• Compressed columns with dictionaries

Management

• Percona Toolkit UDFs

• Kill Idle Transactions

• XtraDB changed page tracking

• PAM Authentication Plugin

• Expanded Fast Index Creation

• Backup Locks

• Audit Log Plugin

• Start transaction with consistent snapshot

• Extended SHOW GRANTS

• Data at Rest Encryption

Reliability

• Handle Corrupted Tables

• Too Many Connections Warning

Diagnostics

• User Statistics

• Slow Query Log

• Show Storage Engines

• Process List

• INFORMATION_SCHEMA.[GLOBAL_]TEMP_TABLES

• Thread Based Profiling

• InnoDB Page Fragmentation Counters

Features Removed from Percona Server for MySQL 8.0

Some features, that were present in Percona Server for MySQL 5.7, are removed from Percona Server for MySQL 8.0:

Removed Features

• Slow Query Log Rotation and Expiration

• CSV engine mode for standard-compliant quote and comma parsing

• Expanded program option modifiers

• The ALL_O_DIRECT InnoDB flush method: it is not compatible with the new redo logging implementation

• XTRADB_RSEG table from INFORMATION_SCHEMA

• InnoDB memory size information from SHOW ENGINE INNODB STATUS; the same information is available from Performance Schema memory summary tables

• Query cache enhancements

Removed Syntax

• The SET STATEMENT ... FOR ... statement that enabled setting a variable for a single query. For more information see Replacing SET STATEMENT FOR with the Upstream Equivalent.

• The LOCK BINLOG FOR BACKUP statement due to the introduction of the log_status table in Performance Schema of MySQL 8.0.

Removed plugins

• SCALABILITY_METRICS

• QUERY_RESPONSE_TIME plugins

The QUERY_RESPONSE_TIME plugins have been removed from Percona Server for MySQL 8.0 as the Performance Schema of MySQL 8.0 provides histogram data for statement execution time.

Removed system variables

• The innodb_use_global_flush_log_at_trx_commit system variable which enabled setting the global MySQL variable innodb_flush_log_at_trx_commit

• pseudo_server_id

• max_slowlog_files

• max_slowlog_size

• innodb_show_verbose_locks: showed the records locked in SHOW ENGINE INNODB STATUS

• NUMA support in mysqld_safe

• innodb_kill_idle_trx which was an alias to the kill_idle_trx system variable

• The max_binlog_files system variable

Deprecated storage engine

• The TokuDB Storage Engine was declared as deprecated in Percona Server for MySQL 8.0 and will be disabled in upcoming 8.0 versions.

  We recommend migrating to the MyRocks Storage Engine.

  For more information, see the Percona blog post: Heads-Up: TokuDB Support Changes and Future Removal from Percona Server for MySQL 8.0.

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: 2023-01-12