… MySQL Consulting work or even more frequently. IO Bound workload is quite different from CPU bound one, which happens when your working set… back to speed. The cases when going from CPU bound to IO bound hits the most is there a lot of rows are… 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 benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… 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… = 2G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at…
Post: Scaling IO Bound Workloads Webinar
June 19, 2009 By 2 Comments
… 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: Looking on 5.4 - IO bound benchmarks
April 30, 2009 By 5 Comments
… in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB buffer_pool) and tested…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… run every fileio benchmark and an IO bound read-write oltp benchmark in autocommit mode. File IO benchmark For the FileIO benchmark, I… benchmark As the goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out… reduced InnoDB buffer pool to make sure the benchmark is IO bound. That said, benchmark was running on a Percona Server 5…
Post: XtraDB in CPU-bound benchmark
December 18, 2008 By Leave a Comment
… show other results also. Here is the run for CPU Bound,or it would be more correctly to say in-cache… remains idle. This run is exactly the same as Disk Bound but with innodb_buffer_pool_size=8G which is more… will show more gains, though not 1.5x as for IO bound workload. One may ask why CPU is not fully used…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… have benchmarked two different kinds of workloads, IO bound and in-memory. Benchmark on IO bound workload was performed with a buffer pool size… actuality the query took 31654 seconds to finish in the IO bound workload. Again here hash join beats BKA and BNL comprehensively… C, Hash Join takes similar amount of time both for IO bound workload and in-memory workload. Why, because Hash Join implies…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… can improve performance order of magnitude by converting very IO bound load to CPU bound, it is well possible to see limited gains… memory is helpful to solve this problem. If it is IO bound (high IO system utilization, low CPU usage) one should think about… if we have very IO bound application without serialization issues (say reporting slave) which is very IO bound showing 100% IO subsystem utilization on 5…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… InnoDB buffer was used. In CPU-bound case innodb_buffer_pool_size=2G In IO-bound case innodb_buffer_pool_size=512M innodb…_DIRECT DBT2 settings For CPU-bound case number of warehouses was 10(1.31GiB). In case of IO-bound load – 100 warehouses… performance impact in case of CPU-bound workload. The performance impact is negligibly small in IO-bound workload even if all queries are…
