Kristian Nielsen presented “Beyond MySQL GA: patches, storage engines, forks, and pre-releases”.
This included a history of current products:
Google Patches (5.0 & 5.1) included improvements in :
- statistics/monitoring
- lock contention
- binlog
- malloc()
- filesorts
- innodb I/O and wait statistics
- SHOW …STATISTICS statements
- smp scalability
- I/O scalability
- semisync replication
- many more
Percona Patches (5.0) focus on
- statistics/monitoring
- performance/scalability
- buffer pool content/mutexes
- microslow patch
These have been ported to 5.1 and mainly integrated into XtraDB.
EBay Patches (5.0) have included:
- variable length memory storage engine
- pool of threads
- Virtual columns
XtraDB storage engine (5.1) includes
- Percona patches
- Google patches
- Innodb patches
- Has XtraBackup for backup
Other engines/patches discussed included:
- PBXT storage engine – community contribution
- FederatedX – replacement to Federated
- Sphinx storage engine
- Pinba storage engine – Collects PHP statistics
- Others OQGraph/Spider
- Galera – Synchronous replication
- Drizzle
Alternative packaging options for MySQL 5.0 and MySQL 5.1 including Our Delta, Percona and MariaDB.
FOSDEM 2010 MySQL Developer Room Schedule
FOSDEM 2010 Website
Brussels, Belgium
February 7, 2010