April 17, 2014

XtraDB storage engine release 1.0.2-2 (New Year edition)

Today we announce release 1.0.2-2 of our XtraDB storage engine.

Here is a list of enhancements:

  • split-buffer_pool_mutex

The patch splits global InnoDB buffer_pool mutex into several and eliminates waitings on flush IO and mutex when there is no enough free buffers. It helps if you have performance drops when data does not fit in memory.

InnoDB has a concurrent transaction limit of 1024 because in the standard InnoDB the number of undo slots is fixed value. This patch expands the maximum number of undo slots to 4072 and allows better utilizing modern hardware. (Thank SmugMug for this feature!)

ATTENTION: If the option was enabled and the expanded slots are used, you cannot use the datafile with system tablespace for the software which assume 1024 slots (e.g. the other mysqld or innodb hotbackup). See documentation for details.

Percona XtraDB 1.0.2-2 available :

XtraDB is compatible with existing InnoDB tables (Warning: unless you used innodb_extra_undoslots ) and we are going to keep compatibility in further releases. We are open for features requests for new engine and ready to accept community patches. You can monitor Percona’s current tasks and further plans on the Percona XtraDB Launchpad project. You can also request features and report bugs there. Also we have setup two maillists for General discussions and for Development related questions.

About Evgeniy Stepchenko

Evgeniy leads Percona's development team and collaborates with the engineering team on building Percona Server and XtraBackup. He lives in Novosibirsk, Russia.

Comments

  1. motorlu panjur says:

    Yes, it replaces InnoDB as default storage engine

  2. perde says:

    Thanks for that information i think i’ll try this in a vm.

  3. Hurda says:

    very usefull article. Thanks For sharing your knowledge.

  4. Emlak says:

    thanks for information

  5. Regarding “as binaries, percona xtradb is compiled in into MySQL-5.1.30 RPM” – does this mean that XtraDB is the default InnoDB storage engine in the server RPM file or does it still need to be enabled via the loadable modules method?

  6. Richard,

    Yes, it replaces InnoDB as default storage engine

  7. Zoran says:

    Thanks for that information i think i’ll try this in a vm.

  8. perde says:

    Thanks you

  9. Laine says:

    so can we use the xtra plugin in a 5.0 percona build to take advantage of > 1024 innodb txns?

  10. Vadim says:

    Laine,

    No, XtraDB plugin is available only for 5.1, but we can port patch for 5.0 for percona builds.

  11. Laine says:

    Vadim, I have a client who is in need of this for 5.0 and we’d consider sponsoring. Please email me at laine@palominodb.com to discuss further.

    Thank you,
    Laine

  12. Yes, it replaces InnoDB as default storage engine

  13. Hurda says:

    I think type of site that is useful in sharing information and it is important to shar.Web proliferation of new developments in the field of design and entrepreneurial spirit of people who have very beautiful and pleasing to be professional

  14. I wish you continued success sharing, thank you.

  15. sharing is very beatiful and high quality

  16. zebra perdezebra perde

  17. konteyner says:

    The subject is too interesting, thanks for sharing

  18. Sharing is very beautiful and high quality

  19. tül perde says:

    shares a very nice, wish the continuity

  20. sharing high-quality and beautiful.

    thx :D

Speak Your Mind

*