Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be …has been discussed on a previous post in our blog. Starting with 5.1, the new plugin API …of the plugin is its flexibility, and not its performance, which seems to be on par with having …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default… this test was provided by Adotomi. I will be blogging about raw performance of the OCZ card in another post. Also, while… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…/lib/mysql/ib_logfile* -rw-rw—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May… InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And from the manual: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept the…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
A few weeks ago I wrote about “MySQL Performance at High Concurrency” and why it is important, which was … MySQL performance at low concurrency is important for you. I decided to write about this topic as a number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is … transaction. Why is that a major problem for MySQL scalability? The scan is performed under kernel_mutex (or trx_sys->mutex in… currently in the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay…
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.6…. And if you cannot make it this year, watch this blog following the conference and we’ll announce when and where…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much worse than Galera. As I illustrated in a blog… does NOT set an lower bound on performance, only a upper bound. The best performance you can expect is modifying a given… update much faster. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This is…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It … hence its rather complex configuration. Probably most readers of this blog know (or should know) about Linux swappiness setting, which basically…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 3, 2013 By 10 Comments
… Memcache vs. Memcache observations: http://blog.ulf-wendel.de/2013/toying-with-peclmysqlnd_memcache-and-mysql-5-6-memcache-innodb/ HandlerSocket vs… MySQL 5.6 (yet). If you compare HS @ 5.5 with InnoDB Memcache @ 5.6 you should see roughly the same performance… features… see also http://de.slideshare.net/nixnutz/nosql-in-mysql Independent YCSB results would be interesting but require significant time…
