Changed in Percona Server 8.0 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_infosystem variable
Performance¶
Flexibility¶
Management¶
Reliability¶
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
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 BACKUPstatement due to the introduction of thelog_statustable in Performance Schema of MySQL 8.0.
Removed Plugins¶
SCALABILITY_METRICSQUERY_RESPONSE_TIMEplugins
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_trxsystem variable - The max_binlog_files system variable
