Dear Community,

As of today Release 9 of XtraDB storage engine is available.

The release includes following new features:

  • The release is base on 1.0.6 version of InnoDB plugin.
  • MySQL 5.1.42 as a base release
  • Separate purge thread and LRU dump is implemented (this feature was actually added in Release 8, but somehow it was forgotten)
  • New patch innodb_relax_table_creation
  • Added extended statistics to slow log
  • Adjust defaults with performance intention
  • Added parameter to control checkpoint age
  • Added recovery statistics output when crash recovery (disabled by default)
  • Patch to dump and restore innodb_buffer_pool

Fixed bugs:

  • Bug#488315:
    rename columns and add unique index cause serious inconsistent with mysqld
  • Bug #495342: “MySQL 5.1.41 + InnoDB 1.0.6 + XtraDB patches extensions-1.0.6, rev. 127 fails to compile on OpenSolaris”
  • Bug #47621: change the fix of http://bugs.mysql.com/47621 more reasonable

The builds for RedHat 4, 5 , Debian and Ubuntu are located on https://www.percona.com/mysql/xtradb/5.1.42-9/ . Since Release 9 .tar.gz packages are available for FreeBSD.

There is an RPM Percona-release. It installs Percona.repo to /etc/yum.repos.d/ and the public key which we use to sign RPMs. The copy of the key is located on our web-site.

Once you install Percona-release repo the upgrade becomes as easy as

The latest source code of XtraDB, including development branch you can find on LaunchPAD.

Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL.
For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona

9 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
http://figvam.blogspot.com/

Installed percona-release RPM on an RHEL 5.4 x86_64 server, getting this error while running yum:
http://repo.percona.com/centos/5Server/os/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 404: Not Found

0
Aleksandr Kuzminsky

Fixed. Could you please try again?

0
P.Linux

Have the compile bug fixed?

0
Imperator

Hello,

I’m New in XtraDB, i swith from Mysql 5.5.1, i want to know if somebody wants help me about whats is the best configurations for tune innodb.

I have high read and write load. my DB is ~4GB size.

2x Intel Xeon 5520
18GB
500GB
RHEL 5.4 x64

Thanks

0
1mp3r4t0r

Hello

I recenlty swith to XtraDB from Myqsl 5.5.1, i have high Read and Write InnoDB load.

I want to know what is the best configuration for 10GB DDR3, InnoDB Size DB ~5G, with XtraDB.

Thank you very much, and Great work Percona.

I dont want bother anybody.

Thanks.

0
http://figvam.blogspot.com/

Aleksandr: thank you, the repository works now.

0
Vojtech Kurka

Is there anyone, who successfully compiled SphinxSE with this particular version of XtraDB?

http://www.sphinxsearch.com/forum/view.html?id=4980

0
miloska

Hi,

I started to use your repo seems very handy, thank you!

There are Percona-XtraDB-* and MySQL-*-percona packages.

What is the difference? Percona-XtraDB-* is a separated project or it’s a development version or the MySQL-*-percona packages?

Thanks

0
miloska

Answer:

Package MySQL-server-percona is obsoleted by Percona-XtraDB-server-51, trying to install Percona-XtraDB-server-51-5.1.43-9.1.rhel5.x86_64 instead
Package MySQL-client-percona is obsoleted by Percona-XtraDB-client-51, trying to install Percona-XtraDB-client-51-5.1.43-9.1.rhel5.x86_64 instead

Thanks!

0