… 1.1. The list of changes in version 1.1 includes: Changelog: XtraBackup is built on a base of MySQL 5.1.44 with InnoDB plugin 1.0… available on http://www.percona.com/percona-builds/XtraBackup/XtraBackup-1.1/. Debian and RPM are available in Percona repository. The project…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb_bug53674. The test is chosen…_innodb.cc:2284) ==9090== by 0x712F17: ha_initialize_handlerton(st_plugin_int*) (handler.cc:435) ==9090== by 0x7A212A: plugin_initialize(st_plugin_int*) (sql_plugin…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… same time. “Norm 1.0.4″: Normal InnoDB Plugin 1.0.4 without XtraDB specific options “xtra p_t 0″: XtraDB 1.0.4-new (no purge_thread) “xtra p_t 1… based on InnoDB Plugin and we can set XtraDB same to InnoDB Plugin at least. The following graphs are results of XtraDB and Plugin with…
Post: MySQL and plugin binaries
April 20, 2008 By 5 Comments
…-party plugins. I personally found and there is confirmation from InnoDB team that current InnoDB-plugin binaries do not work with lastest 5.1.24… incompatible binary on the second day after the announce of InnoDB plugin. I do not think it was intentional, but still looks… current API “versioning binds a plugin binary to specific server release”. That simply means that InnoDB has to release binary for each…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
…. There is Innodb Plugin which has significant architectural changes such as new storage format, compression and fast index build. Innodb plugin 1.0.3 got some Google changes for CPU scalability but not IO patches. I expected Innodb to announce plugin is now…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor… virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2… the result grows up to 16 connections, but after that InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better…
Comment: Great work Innodb Team
December 1, 2009 By 8 Comments
… information about InnoDB Plugin, but the Plugin manual is not merged into the MySQL manual. InnoDB Plugin has indeed replaced the built-in InnoDB in MySQL….5.0 also has InnoDB Plugin as the built-in InnoDB, and it will have InnoDB Plugin 1.0.5. (5.4.x has 1.0.4).
Comment: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 22, 2012 By 10 Comments
… 5.1, you may consider using the Innodb plugin, which has some of these variables: http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-parameters-new.html http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-plugin-installation-overview.html
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… 5.1. To refresh, the most interesting patches are: Performance patches for InnoDB ®. Although many patches are present in XtraDB / InnoDB-plugin, the RC status of plugin does not allow to…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could… convert customer’s data to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I’ve tried was…) 0.01 sec average lookup time by primary key (from 1-20 sec before the conversion) These interesting performance results obviously…
