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