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
• Parallel doublewrite buffer

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
• Transparent Data 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

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

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