Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … enabled on the cluster node acting as async slave for replicated events from the async master to be applied to the other… top of that, other factors affecting async replication like if your workload is CPU or IO bound. Peter wrote some good details…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 9 Comments
… use async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second, async…-threads=$numthreads –rand-init=on –file-num=64 –file-io-mode=async –file-extra-flags=direct –file-fsync-freq=0 –file-block…, mounted with nobarrier. The results for random write case (8 async IO threads): In general it shows stable throughput topping to 148…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 12 Comments
… use async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second, async…-threads=$numthreads –rand-init=on –file-num=64 –file-io-mode=async –file-extra-flags=direct –file-fsync-freq=0 –file-block…, mounted with nobarrier. The results for random write case (8 async IO threads): It seems that InnoDB is not alone with its…
Comment: MySQL Users Conference - Innodb
May 11, 2007 By 6 Comments
… patch for MySQL 5 are at http://google-mysql-tools.googlecode.com/svn/trunk/mysql-patches. Real async IO has one advantage over background IO threads that I am curious about. With async IO…
Comment: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… nice words. The patches from Google were first available for MySQL 4.0.26. They are now available for 4.0… for more IO threads in InnoDB are not needed, as InnoDB has support for using async IO, but this is disabled because async IO didn’t work too well on Linux in the past. Now that Oracle runs on Linux and uses async IO, it…
Post: Testing Intel SSD 520
May 1, 2012 By 8 Comments
… MiB/sec. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first… the question is how much MySQL can use. In his keynote Mark Callaghan mentioned that Fusion-io cards they use are highly… good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in Linux. Let’s test “async… another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems it…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 2 Comments
… test it under MySQL workload, but before getting to that, let me review the same workload on Fusion-io ioDrive PCIe card… Following the format of previous benchmarks, first is random write async 16KB case. We can see some wave-like pattern with throughput 350-400 MiB/sec. Random reads, async: Interesting to see that there is quite unstable throughput in…
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
…-mysql package, which generates TPCC-like workload on MySQL systems. Server hardware: Dell PowerEdge R815 Storage: Fusion-io ioDrive Duo 640GB MLC. Fusion-io…() { var po = document.createElement(‘script’); po.type = ‘text/javascript’; po.async = true; po.src = ‘https://apis.google.com/js/plusone.js…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… external disk enclosure does it great. My Advice for Scaling IO capacity with SAN (this applies to directly attached storage too… use MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL/OS upgrades…
