… is glad to announce the release of Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade…form of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs 1090145…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… full documentation for setting up the plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As a quick…/start memcached, stop/start plugin). As expected, there is a slowdown for write operations when using the InnoDB version. But there is… ms range per/cmd Fetching [1,000,000] items: 288257 ms total 0.288257 ms per/cmd 0.2843 ms min per/cmd…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… – the online backup in MySQL 6.0, it’s to ship in commercial version only. An Innodb Plugin is announced and will be separate from MySQL Server, providing a more scalable Innodb version with more features… as improved and extended Innodb Plugin version, MySQL 5.1 is FA with 5.1.34 and MySQL 5.4.0 is in a nonGA…
Comment: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
April 11, 2013 By 2 Comments
…xtrabackup-2.0.6/bin/xtrabackup lrwxrwxrwx root/root 0 2013-03-19 17:29:37 percona-xtrabackup-2.0.6/bin/innobackupex-1.5.1 -> …correct binary # MySQL 5.0.* – xtrabackup_51 # MySQL 5.1.* – xtrabackup_51 # MySQL 5.1.* with InnoDB plugin – xtrabackup # MariaDB 5.1.* – xtrabackup # MariaDB 5.2…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /var/log/playback.log 2>&1 & Our… work better for this use case. You will need version 0.6 or later to get these features. Be aware that playback… in order to use innodb_fake_changes. Thread pool Percona Playback added a connection pool option via –dispatcher-plugin-thread-pool that…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 13 Comments
… result: InnoDB 9439.316 NOTPM InnoDB-plugin-1.0.6 15299.333 NOTPM XtraDB-1.0.6-9 26160.551 NOTPM InnoDB-plugin is 1.6x times better InnoDB, and XtraDB is 1.7x times better InnoDB-plugin. Now…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very recent… compared to MySQL 5.1 with 2 cores and about 6% slower with 8 cores, meaning regression from plugin increases with number of… execution path. Another thing to note – if you’re using Innodb Plugin consider using new Barracuda format, though do this only after…
Post: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
… 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… crash recovery (disabled by default) Patch to dump and restore innodb_buffer_pool Fixed bugs: Bug#488315: rename columns and add… 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…
Post: xtrabackup-1.1
March 24, 2010 By 5 Comments
… 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.6 Added… available on http://www.percona.com/percona-builds/XtraBackup/XtraBackup-1.1/. Debian and RPM are available in Percona repository. The project…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins… you see XtraDB is somewhat 1.5x better than InnoDB in standard 5.1.30 and even more than InnoDB-plugin-1.0.2 And there is…. And it is important to remember as Linux kernels 2.6.18+ (which are used on CentOS / RedHat 5.2) are…
