… the release of Percona Monitoring Plugins 1.0.3 for MySQL — high-quality …plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins…compatible with pt-hearbeat 2.1.8+ (bug 1103364) * Added 1-second granularity to pmp…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb… #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root…
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…/start memcached, stop/start plugin). As expected, there is a slowdown for write operations when using the InnoDB version. But there is… per/cmd 0.0183 ms range per/cmd InnoDB Memcache: Storing [100,000] items: 233863 ms total 2.33863 ms per/cmd 1.449…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… online backup in MySQL 6.0, it’s to ship in commercial version only. An Innodb Plugin is announced and will be separate… 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…. MySQL 5.5.11 is GA and MySQL 5.6.2 is nonGA. 2012 marks the first year the annual conference…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… designs and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See part two for…-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /var/log/playback.log 2>&1 & Our… in order to use innodb_fake_changes. Thread pool Percona Playback added a connection pool option via –dispatcher-plugin-thread-pool that…
Comment: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
April 11, 2013 By 2 Comments
… 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.* – xtrabackup # MariaDB 5.3.* – xtrabackup # Percona Server 5.0 – xtrabackup_51 # Percona Server 5.1…
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… execution path. Another thing to note – if you’re using Innodb Plugin consider using new Barracuda format, though do this only after… increase does not mean concurrency issues too. You can have 2 cases when waiting on mutexes and other synchronization objects – either…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… well-known InnoDB patch set is omitted (at least for now). The first version of our new 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 code… drop-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…
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 statically…_DIRECT innodb_file_per_table = 1 And for XtraDB I additionally used: innodb_io_capacity = 10000 innodb_adaptive_checkpoint = 1 innodb_write_io_threads = 16 innodb_read… 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 CPU…
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
…other mysqld or innodb hotbackup). See documentation for details. Percona XtraDB 1.0.2-2 available : in source code from Launchpad, the version 1.0.2-2 you …drop-in plugin for existing MySQL-5.1.30 installation XtraDB is compatible with existing InnoDB tables (Warning: unless you used innodb_extra_…
