Percona Server for MySQL 5.7 - Documentation Percona Server for MySQL 5.7 - 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.7
- 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.6 to 5.7
- Post-Installation
Scalability Improvements¶
Performance Improvements¶
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
- CSV engine mode for standard-compliant quote and comma parsing
- Support for PROXY protocol
- Per-session server-id
- Compressed columns with dictionaries
- InnoDB Full-Text Search improvements
- Binlogging and replication improvements
Reliability Improvements¶
Management Improvements¶
- Percona Toolkit UDFs
- Kill Idle Transactions
- Enforcing Storage Engine
- Utility user
- Expanded Program Option Modifiers
- XtraDB changed page tracking
- PAM Authentication Plugin
- Expanded Fast Index Creation
- Backup Locks
- Audit Log Plugin
- Start transaction with consistent snapshot
- Extended
SHOW GRANTS - Data at Rest Encryption
- SSL Improvements
- Utility user
- PS-Admin script
Security Improvements¶
Diagnostics Improvements¶
TokuDB¶
- TokuDB Introduction
- TokuDB Installation
- Using TokuDB
- Fast Updates with TokuDB
- TokuDB files and file types
- TokuDB file management
- TokuDB Background ANALYZE TABLE
- TokuDB Variables
- TokuDB Status Variables
- TokuDB Fractal Tree Indexing
- TokuDB Troubleshooting
- TokuDB Performance Schema Integration
- Percona TokuBackup
- Frequently Asked Questions
- Removing TokuDB storage engine
Percona MyRocks¶
Reference¶
- List of upstream MySQL bugs fixed in Percona Server for MySQL 5.7
- List of variables introduced in Percona Server 5.7
- Development of Percona Server for MySQL
- Trademark Policy
- Index of
INFORMATION_SCHEMATables - Frequently Asked Questions
- Copyright and Licensing Information
- Percona Server for MySQL 5.7 Release notes
- Glossary
Contact Us
For free technical help, visit the Percona Community Forum.To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.