… scalable Innodb version with more features. Gearman and MemcacheD storage engine plugins are available for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL… 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 Enterprise…-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 Enterprise…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…. Enter MySQL 5.6 with the memcached plugin… As part of the standard MySQL 5.6 GA distribution, there is a memcached plugin included in… full documentation for setting up the plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As a quick… ms max per/cmd 0.0951 ms range per/cmd InnoDB MySQL Select (same table): Fetching [1,000,000] items: 441573 ms…
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….so used by the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when plugin-dir option was set in… MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… buffer pool pages were loaded from disk. Replaying Queries Working with Groupon, we have developed a solution to keep the standby… –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….so used by the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when plugin-dir option was set in… MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –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… green and to show bits/sec (bug 1132900) * Extended “MySQL Threads” graph with all kind of threads (bug 1157911) * Some Cacti single…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_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_native…/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are all defaults, as I understand from documentation TokuDB comes with…
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 5… – xtrabackup_55 # Percona Server 5.6 – xtrabackup_56 # MySQL 5.5.* – xtrabackup_55 # MySQL 5.6.* – xtrabackup_56 # MariaDB 5.5.* – xtrabackup…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… on MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb_bug53674…_handlerton(st_plugin_int*) (handler.cc:435) ==9090== by 0x7A212A: plugin_initialize(st_plugin_int*) (sql_plugin.cc:1048) ==9090== This conflicts with a previous…
