… db. 3. CREATE TABLE …. SELECT – It is not supported to perform such type of statements http://mysqlopt.blogspot.co.uk/2013…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
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…
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: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
Here at the MySQL Performance Blog, we’ve been discussing the several new features that …: 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…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… node is crashed and I have this error in my log : 07:53:55 UTC – mysqld got signal 11 ; This could…
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.
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
…-1 and gzip-6. I may have found the main performance bottleneck (benchmark in progress), if I am right, I’ll…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal. On Wednesday, June…
