… Throughput scales with thread count – each thread runs at 100% CPU utilsation, and XFS gets up to 3x as much throughput… million 4k overwrite IOPS to a single file when completely CPU bound… So, basically, XFS is still the filesystem you want for…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… MySQL Consulting work or even more frequently. IO Bound workload is quite different from CPU bound one, which happens when your working set… application back to speed. The cases when going from CPU bound to IO bound hits the most is there a lot of rows… in CPU bound case – yes you will but it will happen with 100.000 messages not 100 messages as in IO bound case…
Post: XtraDB in CPU-bound benchmark
December 18, 2008 By Leave a Comment
… run for CPU Bound,or it would be more correctly to say in-cache benchmark, because there is a lot of CPU remains idle. This run is exactly the same as Disk Bound but with innodb_buffer_pool… utilize CPU more fully XtraDB will show more gains, though not 1.5x as for IO bound workload. One may ask why CPU…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… ran few CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor : 23 vendor_id : GenuineIntel cpu family : 6 model : 29 model name : Intel(R) Xeon(R) CPU E7450…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…-disks utilization. Also results may be different if load is CPU bound. I compared MySQL 5.1.30 trees – MySQL 5.1… = 2G and innodb_flush_method=O_DIRECT to emulate IO bound load. InnoDB parameters: innodb_additional_mem_pool_size = 16M innodb… more than InnoDB-plugin-1.0.2 And there is CPU utilization for all tested engines: As you see XtraDB also…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… be recognized by older Innodb versions. Note: These are completely CPU bound test conditions, data fits to buffer pool furthermore data and… usually shows synchronization is the issue. Barracuda format uses more CPU while delivering better performance so it is probably better with… case. It shows increased performance while decreased CPU usage. Note when I say CPU usage drop means concurrency issues it does not…
Post: Scaling IO Bound Workloads Webinar
June 19, 2009 By 2 Comments
… IO Bound Workloads in MySQL. My part of the presentation will be speaking about why switching from CPU bound workload to IO bound is…
Post: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
… depending on the workload. Here is example run of purely CPU consuming “Benchmark” function for 2.6Ghz Intel Xeon vs T2000… active replication, if you’re running time sensitive long running CPU bound queries or if queries contribute significant time to generating web…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
… different InnoDB buffer was used. In CPU-bound case innodb_buffer_pool_size=2G In IO-bound case innodb_buffer_pool_size=512M…_DIRECT DBT2 settings For CPU-bound case number of warehouses was 10(1.31GiB). In case of IO-bound load – 100 warehouses… about performance impact in case of CPU-bound workload. The performance impact is negligibly small in IO-bound workload even if all queries…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… improve performance order of magnitude by converting very IO bound load to CPU bound, it is well possible to see limited gains – if… type of load we’re dealing with. If it is CPU bound and there is little IO wait we typically do not… is IO bound (high IO system utilization, low CPU usage) one should think about how much CPU capacity is available. If your CPU is…
