… Percona Live MySQL Conference: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” by Dmitri Kravtchuk, MySQL Performance Architect “MySQL 5.6: What’s New in InnoDB” by Sunny Bains, Senior Principal Software Engineer “MySQL 5…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… cache can be invaluable. Enter MySQL 5.6 with the memcached plugin… As part of the standard MySQL 5.6 GA distribution, there is… for setting up the plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As a quick benchmark, I… store against both a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin. Here are some details…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, Senior Software Engineer, Oracle Topic: “MySQL 5…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… terms of MySQL performance that still stands in the way of InnoDB scalability is the…transactions. In this case MySQL 5.6 scalability goes back to the good old MySQL 5.5 times and we… going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… InnoDB options are: [mysqld_safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush… good settings out-of-box, but I am ready to tune something if there are suggestions.
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…innodb_flush_log_at_trx_commit to something besides 1 and suddenly you can update much faster. I see this tuning… that logic (I usually get less than 5 people who do out of 100). But, …tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think …
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…. In MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL 5.5 there is an option to have a single separate dedicated purge thread and in MySQL 5.6.2 one… change and by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | | INNODB_AUTOEXTEND_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5… this system. innodb_stats_on_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file… guess is one of the component of purging fine tuning in MySQL 5.6 innodb_file_per_table is now ON by default. This…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… 2 years after MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full Text… previous MySQL versions to MySQL 5.6, and other issues. Our MySQL Remote DBA Team is ready to monitor, maintain, and fine tune our customers’ MySQL 5…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
…role_id_note` (`role_id`,`note`) ) ENGINE=InnoDB AUTO_INCREMENT=22187769 DEFAULT CHARSET=…MySQL 5.5. For example, in this case, the actual number of “Handler_read_next” calls was reduced from 8346769 (5.5) to just 266 (5… need more manual care and tuning now. MySQL is conservative about “Using index…
