May 24, 2012

Post: Percona welcomes Drizzle 7.1

… stable release, Drizzle 7.0. I plan to write …plugin and auth_schema JS plugin: execute JavaScript code as a Drizzle function HTTP JSON API (experimental) Some of the Percona InnoDB…of code. Installing Drizzle 7.1.33-stable The source …in the Drizzle manual. CentOS 6 packages are available from …

Post: ext4 vs xfs on SSD

… but that option is not available on my CentOS 6.2, so I could not test it. At this… the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous”…(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js…

Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage

… 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

… 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

… 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

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

… 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…

Post: Great work Innodb Team

… which is Performance And Scalability. Innodb Plugin 1.0.4 had a lot of great performance improvements and 1.0.5/1.0.6 gets even further with long… Percona were reworked and included in the plugin during latest months. We can also see Innodb Plugin 1.0.5 is named Release Candidate which…

Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB

… storage engine is 1.0.2-1, which is forked from InnoDB-plugin-1.0.2. Percona XtraDB is released under GPL v2, as is InnoDB-plugin base source…-in plugin for existing MySQL-5.1.30 installation http://www.percona.com/mysql/5.1.30/binary/percona-xtradb-1.0.2-1-5.1.30…/percona-dev for development related questions. We are looking for 6-month release cycle of XtraDB. First several releases may come…

Post: My "hot" list for next InnoDB features

Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 cores boxes for many…://bugs.mysql.com/bug.php?id=29847, with ETA MySQL-6.0 Preload table / index into buffer_pool. You can use custom… our current plans about XtraDB with recent InnoDB-pluging release, as performance improvements in plugin may make XtraDB out of game – so…