August 31, 2014

XtraDB storage engine release 1.0.6-9

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 http://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

About Aleksandr Kuzminsky

Aleksandr is a consultant and data recovery specialist.
He is a former Percona employee.

Comments

  1. 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

  2. Aleksandr Kuzminsky says:

    Fixed. Could you please try again?

  3. P.Linux says:

    Have the compile bug fixed?

  4. Imperator says:

    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

  5. 1mp3r4t0r says:

    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.

  6. Aleksandr: thank you, the repository works now.

  7. Vojtech Kurka says:

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

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

  8. miloska says:

    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

  9. miloska says:

    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!

Speak Your Mind

*