… have benchmarked two different kinds of workloads, IO bound and in-memory. Benchmark on IO bound workload was performed with a buffer pool size… a dual core machine with the following CPU configuration: 2xIntel(R) Core(TM)2 CPU 6600 @ 2.40GHz. The amount of memory… actuality the query took 31654 seconds to finish in the IO bound workload. Again here hash join beats BKA and BNL comprehensively…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… “r”, replication is CPU-bound, otherwise – IO. If it is not conclusive, mpstat will give you better visibility by CPU thread. Note this assumes… picture. If you find that replication is CPU bound, this maybe very helpful. If it is IO bound, then fixing it may not be as easy (or rather, as cheap). Let me explain. If replication is IO bound, most…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… people understand IO and as not as I typically use these terms. For me IO is IO bound workload – disks are moving and CPU sits… of cases are about IO because we would call cases when too much of logical IO is happening CPU bound. The beauty of this…) – it is very easy to see if system is IO bound or CPU bound, while to understand if MySQL goes through more rows than…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… and load was mostly CPU bound. Next I went on testing MySQL. My goal was to simulate as much IO as possible so… or may be thousands of IOs per system for the whole system which allows to waste some CPU cycles handling them without… MyISAM we got CPU bound before we could reach the system capacity – these 70K queries/sec generated just over 50K IOs/sec while…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
… 5.0.19, more about default values). For Multiple CPU boxes (4+ CPU) situation is different. In theory you could use 2… threads for each CPU and Disk resource. For Disk IO bound workload you could only account number of disks and for CPU bound only number… separate variable beause log flushing is frequently IO bound operation even if rest of workload is CPU bound so same value for variables would…
Comment: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… couple of notes here 1) Even though Vadim called it IO bound benchmark, it is not completely the case. With data just… is mixed benchmark which loads both CPU and IO subsystem intensively, so it both cares about IO performance but also about contention issues. It would be interesting to see results for completely CPU bound and IO bound benchmarks too…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
… profile not CPU-bound load (for CPU-bound there is OProfile, see for example http://mysqlinsights.blogspot.com/2009/08/oprofile-for-io-bound-apps.html). I.e. for IO-bound or…
Comment: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
Laurynas, Is this CPU bound or IO bound purge operation ? In this case with short transactions in Sysbench, … undo space which with 16GB buffer pool can still be CPU bound. What kind of “hints” on it is also what Percona… there are more gains to get if you can trigger IO bound purge. I’d also use just update-key in sysbench…
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…. So this should not be random IO bound workload. It should be mainly CPU bound. If you want IO bound workload you have to have some… you ad SHA1(id) as a key it would become io bound on insert at some time in the future.
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…. So this should not be random IO bound workload. It should be mainly CPU bound. If you want IO bound workload you have to have some… you ad SHA1(id) as a key it would become io bound on insert at some time in the future.
