… the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time had an effect on performance of the benchmark… using MyISAM for everything!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult… operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not cover. I…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer…, pt-duplicate-key-checker will detect subtle redundancies that are engine-dependent, like redundant suffixes for secondary keys in InnoDB. As…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… subqueries) and we saw in my presentation that sometimes these perform worse and sometimes better than another equivalent solution. If you… can be improved. But there’s a finite amount of engineer-years spent developing and testing the query optimizer. The developers… solution for randomly choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY RAND() solution…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend… on the same machine if you use the BLACKHOLE storage engine) in between the actual master and the slaves at the… that I question its readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… not supported inside transaction. 2. Updates involving non-transactional storage engines – It is not possible to mix non-transactional tables (such… issue can arise if slave host is using different storage engine for the respective table on master databases. Also, if BINLOG… db. 3. CREATE TABLE …. SELECT – It is not supported to perform such type of statements http://mysqlopt.blogspot.co.uk/2013…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…_logfile* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence && ls…: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept the size of your redo…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… cost of the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal. On Wednesday…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics. Bugs Fixed…-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. This…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… was placed on the storage engine API diminishing importance of the Innodb storage engine. The Falcon storage engine was announced as a potential… the Drizzle project participates in the conference. Percona runs Percona Performance Conference as a free event going concurrently with the conference…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… Software 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…
