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
… 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, the InnoDB… 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, the InnoDB buffer pool size is set to…
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… for ORDER BY .. LIMIT. For IO bound applications Clustering (data locality) also becomes very important – if Innodb tables are used having simply auto…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… used innodb_buffer_pool_size = 2G and innodb_flush_method=O_DIRECT to emulate IO bound load. InnoDB parameters: innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb…
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…_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read_io_threads = 16…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… values for any of these variables is indication of IO bound workload. Note however – IO requests submited by threads executing requests are not…, sometimes you can see IO bound workload with hit rate of 995/1000. ————– ROW OPERATIONS ————– 0 queries inside InnoDB, 0 queries in queue…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… change was – I have significantly reduced InnoDB buffer pool to make sure the benchmark is IO bound. That said, benchmark was running on… innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… your workload is mostly bound by the LRU list, then innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size… list bound, then for MySQL 5.1/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…_innodb–; ENTER; } retry: if (entered_thread < innodb_thread_concurrency) { entered_threads++; thread->n_tickets_to_enter_innodb = innodb_concurrency_tickets; ENTER; } if (innodb_… beause log flushing is frequently IO bound operation even if rest of workload is CPU bound so same value for variables …
