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 ported to Percona Server for MySQL 8.0 from Percona Server for MySQL 5.7¶
The following features have been ported to Percona Server for MySQL 8.0 from Percona Server for MySQL 5.7:
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¶
Flexibility¶
Management¶
Reliability¶
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 thelog_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¶
- 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