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

Diagnostics

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 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.

See also

MySQL Documentation: Statement Histogram Summary Tables
https://dev.mysql.com/doc/refman/8.0/en/statement-histogram-summary-tables.html
Removed System variables

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 professional services, contact Percona Sales.