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

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
  • Utility user
  • 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

See also

MySQL Documentation: Performance Schema Table Description
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-descriptions.html

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