Percona Server 5.6 - Documentation Percona Server 5.6 - Documentation¶
Percona Server for MySQL is an enhanced drop-in replacement for MySQL. With Percona Server for MySQL,
- Your queries will run faster and more consistently.
- You will consolidate servers on powerful hardware.
- You will delay sharding, or avoid it entirely.
- You will save money on hosting fees and power.
- You will spend less time tuning and administering.
- You will achieve higher uptime.
- You will troubleshoot without guesswork.
Does this sound too good to be true? It’s not. Percona Server for MySQL offers breakthrough performance, scalability, features, and instrumentation. Its self-tuning algorithms and support for extremely high-performance hardware make it the clear choice for companies who demand the utmost performance and reliability from their database server.
Introduction¶
Installation¶
- Installing Percona Server for MySQL 5.6
- Installing Percona Server for MySQL from Repositories
- Installing Percona Server for MySQL from a Binary Tarball
- Installing Percona Server for MySQL from a Source Tarball
- Installing Percona Server for MySQL from the Git Source Tree
- Compiling Percona Server for MySQL from Source
- Building Percona Server for MySQL Debian/Ubuntu packages
- Percona Server In-Place Upgrading Guide: From 5.5 to 5.6
Scalability Improvements¶
Performance Improvements¶
- Multiple page asynchronous I/O requests
- Atomic write support for Fusion-io devices
- Query Cache Enhancements
- Improved
NUMAsupport - HandlerSocket
- Fixed Size for the Read Ahead Area
- Thread Pool
- Page cleaner thread tuning
- XtraDB Performance Improvements for I/O-Bound Highly-Concurrent Workloads
- Prefix Index Queries Optimization
Flexibility Improvements¶
- Suppress Warning Messages
Improved MEMORYStorage Engine- Restricting the number of binlog files
- Extended
mysqldump - Extended
SELECT INTO OUTFILE/DUMPFILE - Per-query variable statement
- Extended
mysqlbinlog - Slow Query Log Rotation and Expiration
- Ability to change database for mysqlbinlog
- CSV engine mode for standard-compliant quote and comma parsing
- Online GTID deployment
- Support for PROXY protocol
- Per-session server-id
- Support for TLS v1.1 and v1.2
- Compressed columns with dictionaries
- Binlogging and replication improvements
Reliability Improvements¶
Management Improvements¶
- Percona Toolkit UDFs
- Support for Fake Changes
- Kill Idle Transactions
- Enforcing Storage Engine
- Utility user
- Extending the
secure-file-privserver option - Expanded Program Option Modifiers
- XtraDB changed page tracking
- PAM Authentication Plugin
- Expanded Fast Index Creation
- Log Archiving for XtraDB
- Statement Timeout
- Backup Locks
- Audit Log Plugin
- Start transaction with consistent snapshot
super-read-onlyoption- Extended
SHOW GRANTS - SSL Improvements
Diagnostics Improvements¶
- User Statistics
- Slow Query Log
- Extended Show Engine InnoDB Status
- Count InnoDB Deadlocks
- Log All Client Commands (
syslog) - Show Storage Engines
- Show Lock Names
- Process List
- Misc. INFORMATION_SCHEMA Tables
- Thread Based Profiling
- Metrics for scalability measurement
- Response Time Distribution
- InnoDB Page Fragmentation Counters
TokuDB¶
- TokuDB Introduction
- TokuDB Installation
- Using TokuDB
- TokuDB files and file types
- TokuDB file management
- TokuDB Background ANALYZE TABLE
- TokuDB Variables
- TokuDB Status Variables
- TokuDB Troubleshooting
- TokuDB Performance Schema Integration
- Percona TokuBackup
- Frequently Asked Questions
- Removing TokuDB storage engine
Reference¶
- List of upstream MySQL bugs fixed in Percona Server for MySQL 5.6
- List of variables introduced in Percona Server 5.6
- Development of Percona Server
- Trademark Policy
- Index of
INFORMATION_SCHEMATables - Frequently Asked Questions
- Copyright and Licensing Information
- Percona Server for MySQL 5.6 Release notes
- Glossary
