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: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
….6 IO bound workload Now let’s see how effective is MRR when the workload is IO bound. For the purpose of benchmarking IO bound workload… These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5…. Conclusion There is a huge speedup when the workload is IO bound, the query time goes down from ~11min to under a…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…. IO bound workload Now let’s see how effective are the join optimizations when the workload is IO bound. For the purpose of benchmarking IO bound… workload. BKA makes a huge difference when the workload is IO bound and the query time drops from 2534.41s down to… BKA improves the query time by a huge margin for IO bound workload but does not make much of a difference to…
Comment: ext4 vs xfs on SSD
March 25, 2012 By 23 Comments
…. This is regressions as a result of cleaning up the IO path in the XFS code – it’s put a lot… single file when completely CPU bound… So, basically, XFS is still the filesystem you want for direct IO – but like any filesystem…
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… 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 11 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…
