Beyond MySQL GA: patches, storage engines, forks, and pre-releases – FOSDEM 2010

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

Comments

  1. Andy says

    Is there any more info on the ebay patches? I’ve never heard of them.

    The thread pool feature sounds very interesting.

  2. Kristian Nielsen says

    Regarding eBay patches:

    The information about the patch for variable length data in MEMORY tables is here:

    http://code.google.com/p/mysql-heap-dynamic-rows/

    I think their work on thread pool has been superseeded/taken over by others since. There was an implementation of thread pool in the MySQL 6.0 tree (now dropped), which has been incorporated into MariaDB. And there is work on a new/improved thread pool for a future MySQL version:

    http://mikaelronstrom.blogspot.com/2009/12/new-threadpool-design.html

  3. says

    Xtrabackup isn’t just for XtraDB, and it actually isn’t part of XtraDB. It’s a broadly useful hot backup solution for InnoDB tables.

Trackbacks

  1. […] Continuing in the context of Oracle’s acquisition and Ken’s resignation, Bridget Bothelo’s article MySQL users hope for the best, prep for the worst speculates about what is in the mind of those who run MySQL in production. If you are interested in the different releases and branches, you’ll find plenty of blogs this week starting with Jay Jensen’s question When should we expect the next stable MySQL release beyond 5.1? and Ronald Bradford’s FOSDEM 2010 presentation Beyond MySQL GA: patches, storage engines, forks, and pre-releases – FOSDEM 2010. […]