…) seems strongly depend on GC of java VM at the high throughput. The room of memory (10~20GB for 100 sessions?) might be needed for high LinkBench throughput. I think LinkBench should have less dependency for…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… disk. Now during those 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to…
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… that I question its readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and… top of something like that? I can’t imagine the performance being all that fantastic, and I could see network latency…
Comment: Profiling MySQL Memory Usage With Valgrind Massif
June 5, 2013 By 3 Comments
… this very useful post. I was wondering – what is the performance penalty of running mysqld (or any other program) under Massif…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… best right now with benchmarks showing up to 50% more performance than even lzjb. With future LZ4 compression for L2ARC combined…
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… solution for randomly choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY RAND() solution…
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… is a waste of resources that could potentially impact our performance, and should be avoided. By the way, a good practice…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… to s2. This scenario can happen when you want to perform a planned failover. With GTIDs, all the operations are straightforward…
Comment: ZFS on Linux and MySQL
May 29, 2013 By 17 Comments
Nice article! Actually I ran into performance issues during testing ZFS on Linux, it’s true it … implementation has not yet been optimized for performance. As the project matures we can expect performance to improve.” http://zfsonlinux.org/faq…
Comment: Is Synchronous Replication right for your app?
May 28, 2013 By 18 Comments
Jay – Yoshinori found one performance bug for semi-sync — http://bugs.mysql.com/bug.php?id=69341. Wonder if there are others.
