May 24, 2012

Comment: Version 1.0 of Percona Monitoring Plugins Released

Hi Baron, I see that the pmp-check-mysql-innodb plugin for Nagios leaves a lot of files (e.g. pmp-check-mysql-innodb.1196) in /tmp. Is that a desired feature? Thanks Daysen

Comment: MariaDB 5.3 is released as GA!

Unfortunately that’s not true Henrik. Take for example the InnoDB plugin that has changed frequently throughout a release. http://www.chriscalender… even within MySQL 5.5 GA we’ve gone from InnoDB plugin version 1.1.4->1.1.8. Also, take a…

Post: ext4 vs xfs on SSD

… MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO… asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems it is…

Post: Percona welcomes Drizzle 7.1

… log plugin and auth_schema JS plugin: execute JavaScript code as a Drizzle function HTTP JSON API (experimental) Some of the Percona InnoDB… DATA_DICTIONARY tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to…

Post: MariaDB 5.3 is released as GA!

… offers pluggable authentication; you just have to pay for the plugin if you want the official Oracle one; or you can use Percona’s PAM plugin. MariaDB 5.3 isn’t the only exciting thing, however…, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be…

Comment: InnoDB in self-compiled MySQL 5.1

I tried this: ./configure \ –with-plugins=innobase \ –prefix=/home/stephane/programs/install \ –localstatedir=/home/stephane/programs/mysql/data on MySql 5.1.61 But I still get stephane@stephane-ThinkPad-X60:install> mysqladmin variables | grep have_innodb | have_innodb | NO

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

… library, version 2.x, a generic Synchronous Multi-Master replication plugin for transactional applications. The Galera library is developed by Codership….1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc=’cecece’;bbc=’3F79D5…

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

… results for InnoDB vs InnoDB-plugin during runs (values are in new order transactions per minute, more is better) : As you see InnoDB-plugin is… for InnoDB-plugin. Here we observe innodb_adaptive_flushing in action (which is ON by default), and I think innodb_adaptive_flushing in InnoDB-plugin is…-9 26160.551 NOTPM InnoDB-plugin is 1.6x times better InnoDB, and XtraDB is 1.7x times better InnoDB-plugin. Now on CPU usage…

Post: Innodb plugin 1.0.4 released - great job Innobase

… exactly 5 months after release of Innodb Plugin 1.0.3 (I honestly expected to see Innodb Plugin 1.0.4 to be released… adopter” version of a plugin which is a bit of disappointment as we can’t wait for Innodb plugin to become stable/GA… fun part starts – we need to evaluate/benchmark/stress test Innodb Plugin 1.0.4 to integrate it with next XtraDB release.

Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency

… so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very recent… regression from plugin increases with number of cores. If you would not only run MySQL plugin but also use new “Barracuda” Innodb format… execution path. Another thing to note – if you’re using Innodb Plugin consider using new Barracuda format, though do this only after…