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 :
-
in source code from Launchpad, the version 1.0.2-2 you can get as bzr branch lp:percona-xtradb -r tag:release-1.0.2-2 percona-xtradb-1.0.2-2
-
as binaries, percona xtradb is compiled in into MySQL-5.1.30 RPM
-
as separated shared library, to use as drop-in plugin for existing MySQL-5.1.30 installation
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 the Author
Evgeniy StepchenkoEvgeniy is a former Percona employee. He used to lead Percona's development team and collaborate with the engineering team on building Percona Server and XtraBackup. He lives in Novosibirsk, Russia.
thanks for information
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?
Richard,
Yes, it replaces InnoDB as default storage engine
Thanks for that information i think i’ll try this in a vm.
Thanks you
so can we use the xtra plugin in a 5.0 percona build to take advantage of > 1024 innodb txns?
Laine,
No, XtraDB plugin is available only for 5.1, but we can port patch for 5.0 for percona builds.
Vadim, I have a client who is in need of this for 5.0 and we’d consider sponsoring. Please email me at [email protected] to discuss further.
Thank you,
Laine
Yes, it replaces InnoDB as default storage engine
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
I wish you continued success sharing, thank you.
Yes, it replaces InnoDB as default storage engine
Thanks for that information i think i’ll try this in a vm.
very usefull article. Thanks For sharing your knowledge.
sharing is very beatiful and high quality
zebra perdezebra perde
The subject is too interesting, thanks for sharing
Sharing is very beautiful and high quality
shares a very nice, wish the continuity
sharing high-quality and beautiful.
thx 😀
hi sir, it is very nice to learn from you… thank you so much
Notebook Servis çok güzel bir site ellerinize sağlık