May 25, 2012

Comment: Benchmarking single-row insert performance on Amazon EC2

… version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that…

Comment: Benchmarking single-row insert performance on Amazon EC2

… when increased insert buffer flushing was enabled (using the FB patch, not XtraDB but difference should be similar)

Comment: ext4 vs xfs on SSD

sandeep, I am not aware about alternative in ext4. There is a patch for MySQL which can do somewhat similar on any filesystem (this comes with Percona XtraDB Cluster)

Comment: ext4 vs xfs on SSD

…/xfs/2012-01/msg00325.html and this was the prototype patch I wrote to fix the overwrite DIO performance problem: http… XFS results are: sync async threads throughput throughput vanilla patched vanilla patched 1 1.90/124k 1.83/120k 1.72/112k…. Other testing I’ve done on this machine with this patch has given close to a million 4k overwrite IOPS to…

Comment: ext4 vs xfs on SSD

… long. For that matter look at the bug list or patch list for MySQL/InnoDB at any one point in time… agreements, customers can try to pressure companies to move one patch ahead of another. I’ve worked in that environment, and can tell you that I’ve almost never seen a patch moved up that way unless something is completely broken. There…

Comment: MariaDB 5.3 is released as GA!

… in vagueness, it’s harder for people to back-port patches. As an alternative Ubuntu has decided to just keep rolling… perspective, but Oracle (and Sun before them) don’t just patch security exploits between releases, there are other things that get… like to pin release versions.) Given MariaDB is MySQL with patches, I’m not sure quite how much that gains, or…

Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables

Peter, Why not use similar patch as in Google Patches II, where InnoDB file writes can be altogether disabled using …

Comment: MariaDB 5.3 is released as GA!

… it is the case that distros would only want to patch security issues whereas MySQL also fixes non-security bugs like… sticking to the original version they released and cherry pick patches on top of that might be worth questioning.

Post: Percona welcomes Drizzle 7.1

… function HTTP JSON API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle 7.0 (which was released…

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

… on Percona Server with XtraDB and includes Write Set REPlication patches. It uses the Galera library, version 2.x, a generic…