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

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

PREVIOUS POST
NEXT POST

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.

PREVIOUS POST
NEXT POST

Share this post

Comments (22)

  • motorlu panjur Reply

    Yes, it replaces InnoDB as default storage engine

    December 29, 2008 at 12:00 am
  • perde Reply

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

    December 29, 2008 at 12:00 am
  • Hurda Reply

    very usefull article. Thanks For sharing your knowledge.

    December 29, 2008 at 12:00 am
  • Emlak Reply

    thanks for information

    January 1, 2009 at 9:39 am
  • Richard Dale Reply

    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?

    January 2, 2009 at 5:23 pm
  • Evgeny Stepchenko Reply

    Richard,

    Yes, it replaces InnoDB as default storage engine

    January 8, 2009 at 9:48 am
  • Zoran Reply

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

    January 12, 2009 at 8:31 am
  • perde Reply

    Thanks you

    March 25, 2009 at 7:05 am
  • Laine Reply

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

    April 8, 2009 at 1:43 pm
  • Vadim Reply

    Laine,

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

    April 8, 2009 at 1:51 pm
  • Laine Reply

    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

    April 8, 2009 at 5:44 pm
  • perde modelleri Reply

    Yes, it replaces InnoDB as default storage engine

    November 4, 2009 at 5:33 am
  • Hurda Reply

    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

    August 20, 2010 at 3:35 am
  • dell destek Reply

    I wish you continued success sharing, thank you.

    August 31, 2010 at 10:55 pm
  • dell servis Reply

    sharing is very beatiful and high quality

    July 19, 2011 at 1:42 am
  • zebra perde Reply

    zebra perdezebra perde

    July 19, 2011 at 2:07 am
  • konteyner Reply

    The subject is too interesting, thanks for sharing

    July 19, 2011 at 2:30 am
  • lahmacun firini Reply

    Sharing is very beautiful and high quality

    July 19, 2011 at 2:38 am
  • tül perde Reply

    shares a very nice, wish the continuity

    July 19, 2011 at 2:45 am
  • simit fırını Reply

    sharing high-quality and beautiful.

    thx 😀

    July 19, 2011 at 2:57 am
  • izmir kocluk Reply

    hi sir, it is very nice to learn from you… thank you so much

    June 13, 2014 at 7:36 pm
  • Can Reply

    Notebook Servis çok güzel bir site ellerinize sağlık

    August 28, 2015 at 9:59 am

Leave a Reply