…. This is regressions as a result of cleaning up the IO path in the XFS code – it’s put a lot… Throughput scales with thread count – each thread runs at 100% CPU utilsation, and XFS gets up to 3x as much throughput… a single file when completely CPU bound… So, basically, XFS is still the filesystem you want for direct IO – but like any filesystem…
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 is…
Post: Scaling IO Bound Workloads Webinar
June 19, 2009 By 2 Comments
… Solutions for 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: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… it is IO bound (high IO system utilization, low CPU usage) one should think about how much CPU capacity is available. If your CPU is 25… have very IO bound application without serialization issues (say reporting slave) which is very IO bound showing 100% IO subsystem utilization on 5% of CPU usage…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… second 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 are… design 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/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…=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read_io_threads = 16 join_buffer_size=1M…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…_sync_spin_loops can be used to ballance between wasting CPU time running spin locks and doing unneeded context switches. The… values for any of these variables is indication of IO bound workload. Note however – IO requests submited by threads executing requests are not… may have these at zeroes while workload being IO bound still. Next, number of file IO operations is shown as well as computed…
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…_size = 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: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… = yes Speeds | 24×1600.000 Models | 24xIntel(R) Xeon(R) CPU X5650 @ 2.67GHz Caches | 24×12288 KB # Memory ##################################################### Total | 23… every fileio benchmark and an IO bound read-write oltp benchmark in autocommit mode. File IO benchmark For the FileIO benchmark,…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… a lot of CPU resources but none of disk IO and mysqldump should have relatively little CPU needs and be bound by disk. Also… buffer pool with only 12MB remaining. This makes workload extremely IO bound hence such drop in performance. The performance of mysqldump is… happen the workload which is normally in memory becomes disk IO bound which can slow it down more than 100 times. The…
