Percona Server for MySQL Advantage
summary
Percona Server is an enhanced drop‑in MySQL replacement that claims measurable gains: changing the InnoDB redo log block from 512 to 4KB InnoDB log block improves SSD write throughput, switching to crc32 checksums offloads work to modern CPUs, and O_DIRECT plus multiple hash index partitions and a split global mutex reduce IO and lock contention. NUMA-aware memory allocation and a thread pool enable server consolidation. Visibility features include a microsecond slow query log and extra information_schema tables. Percona XtraBackup already supports InnoDB and MyISAM and plans TokuDB support.
AI-written summary · about
chapters (15)
- 0:00Introduction
- 1:27MySQL distributions overview
- 2:51Why Percona Server
- 3:54Faster query performance
- 7:48Tuning InnoDB I/O
- 9:34Hash index partitions improvements
- 11:43Server consolidation with NUMA
- 13:29Database visibility
- 14:52User statistics access
- 15:13Cost savings features
- 16:59Reducing downtime
- 18:24Replication and backup
- 19:07Sharding delays TokuDB
- 20:20Questions and documentation overview
- 23:26Backup for storage engines
related talks
15mPercona Database Distributions - An Overview
25mPercona Server for MongoDB: Features Overview
54mPercona XtraBackup Advanced Features
09mOpen Software for MongoDB Where Percona Fits
56mOptimization Techniques in MySQL
25mMySQL Performance for DevOps
39mTake Your Percona Server for MongoDB to the Next Level
23mChampioning Open Source Databases