January 13, 2010

XtraDB storage engine release 1.0.6-9

Posted by Aleksandr Kuzminsky |

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

CODE:
  1. yum update MySQL-server-percona MySQL-client-percona

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

Related posts: :XtraDB storage engine release 1.0.3-5::XtraDB storage engine release 1.0.4-8::XtraDB storage engine release 1.0.3-7:
 

9 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

    Comment :: January 13, 2010 @ 11:02 pm

  2. 2. Aleksandr Kuzminsky

    Fixed. Could you please try again?

    Comment :: January 14, 2010 @ 1:14 am

  3. Have the compile bug fixed?

    Comment :: January 14, 2010 @ 11:59 pm

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

    Comment :: January 15, 2010 @ 12:00 am

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

    Comment :: January 15, 2010 @ 8:57 am

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

    Comment :: January 15, 2010 @ 12:48 pm

  7. 7. Vojtech Kurka

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

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

    Comment :: January 18, 2010 @ 10:15 am

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

    Comment :: February 24, 2010 @ 2:24 am

  9. 9. 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!

    Comment :: February 24, 2010 @ 2:33 am

 

Subscribe without commenting

Trackbacks/Pingbacks