Percona Server - Documentation SPECIAL NOTE: Percona Server 5.5 has reached End of Life and is no longer supported.
For specific information please visit - https://www.percona.com/services/policies/percona-software-platform-lifecycle
For specific information please visit - https://www.percona.com/services/policies/percona-software-platform-lifecycle
Percona Server - Documentation¶
Percona Server is an enhanced drop-in replacement for MySQL. With Percona Server,
- 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 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¶
Scalability Improvements¶
Performance Improvements¶
- Atomic write support for Fusion-io devices
- Drop table performance
- Configuration of the Doublewrite Buffer
- Query Cache Enhancements
- Fast InnoDB Checksum
- Remove Excessive Function Calls (
fcntl) - Reduced Buffer Pool Mutex Contention
- InnoDB timer-based Concurrency Throttling
- Improved
NUMAsupport - HandlerSocket
- Fixed Size for the Read Ahead Area
- Thread Pool
- Binary Log Group Commit
Flexibility Improvements¶
- Support of Multiple Page Sizes
- Suppress Warning Messages
- Handle
BLOBEnd of Line - Fast Shutdown
Improved MEMORYStorage Engine- Restricting the number of binlog files
- Ignoring missing tables in mysqldump
- Extended
SELECT INTO OUTFILE/DUMPFILE - Extended
mysqlbinlog - Ability to change database for mysqlbinlog
- Slow Query Log Rotation and Expiration
- CSV engine mode for standard-compliant quote and comma parsing
- Support for TLS v1.1 and v1.2
- Binlogging and replication improvements
Reliability Improvements¶
Management Improvements¶
- InnoDB Recovery Stats
- InnoDB Data Dictionary Size Limit
- Expand Table Import
- Dump/Restore of the Buffer Pool
- Fast Index Creation
- Expanded Fast Index Creation
- Prevent Caching to FlashCache
- 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
- Audit Log Plugin
- Extended
SHOW GRANTS
Diagnostics Improvements¶
- InnoDB Statistics
- User Statistics
- Slow Query Log
- Extended Show Engine InnoDB Status
- Count InnoDB Deadlocks
- Log All Client Commands (
syslog) - Response Time Distribution
- Show Storage Engines
- Show Lock Names
- Process List
- Misc. INFORMATION_SCHEMA Tables
- Thread Based Profiling
- Metrics for scalability measurement
Obsolete and Removed Features¶
Reference¶
- List of upstream MySQL bugs fixed in Percona Server 5.5
- List of variables introduced in Percona Server 5.5
- Development of Percona Server
- Trademark Policy
- Index of
INFORMATION_SCHEMATables - Frequently Asked Questions
- Copyright and Licensing Information
- Options that make XtraDB tablespaces not compatible with MySQL
- Percona Server 5.5 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.