… commercial version only. An Innodb Plugin is announced and will be separate from MySQL Server, providing a more scalable Innodb version with more features… extended Innodb Plugin version, MySQL 5.1 is FA with 5.1.34 and MySQL 5.4.0 is in a nonGA version. The MySQL…-scale MySQL alternative and not just replacement for the Innodb Plugin. MySQL 5.5 is now GA with no more funky version differences for MySQL…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… plugin… As part of the standard MySQL 5.6 GA distribution, there is a memcached plugin included in the base plugin directory (/usr/lib64/mysql/plugin… 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…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb… used by the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when plugin-dir option was set in… the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…MySQL Sunny Bains, Senior Principal Software Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb… used by the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when plugin-dir option was set in… the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… form of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs 1090145, 1102687) * Added UTC option to pmp-check-mysql-replication…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_…group = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_…
Comment: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
April 11, 2013 By 2 Comments
…_version { # Based on MySQL version choose correct binary # MySQL 5.0.* – xtrabackup_51 # MySQL 5.1.* – xtrabackup_51 # MySQL 5.1.* with InnoDB plugin – xtrabackup # MariaDB… – xtrabackup_55 # Percona Server 5.6 – xtrabackup_56 # MySQL 5.5.* – xtrabackup_55 # MySQL 5.6.* – xtrabackup_56 # MariaDB 5.5.* – xtrabackup…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… its data directory. InnoDB is getting stuck, has long-running transactions, or other problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses a…
