… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
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
… both MySQL 5.5 and MySQL 5.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… captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd…
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… when the workload is IO bound and the query time drops from 2534.41s down to under a minute. MySQL 5.6 has… BKA improves the query time by a huge margin for IO bound workload but does not make much of a difference to…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… for MySQL Performance Optimization. In fact I probably have to touch it in every second MySQL Consulting work or even more frequently. IO Bound workload is quite different from CPU bound one, which happens when… back to speed. The cases when going from CPU bound to IO bound hits the most is there a lot of rows are…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… quite typical server we recommend to run MySQL on. What is important I used Noop IO scheduler, instead of default CFQ. Disclaimer… if load is CPU bound. I compared MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with…_size = 2G and innodb_flush_method=O_DIRECT to emulate IO bound load. InnoDB parameters: innodb_additional_mem_pool_size = 16M innodb…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S… examines 20 rows, which means about 1 IO per 40 rows… which amounts to pretty IO bound load for me. But average is… less than 1 row in average which makes it very IO bound. So what If I am planning for load growth and…
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… to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I…
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… you’re interested in Schooner appliance offerings, flash or scaling MySQL in General. You can follow this url to register.
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on… as big as memory, so the workload should be somewhat IO-bound. My goal for this benchmark is long-term performance, but… doesn’t mean that we weren’t IO-bound; it might only mean that we were IO-bound the whole time waiting on fsync…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… you should be able to see it by comparing IO MySQL is doing to IO going to devices from OS standpoint. If this… goodness. Data Size ChangesThe more data you have the more IO bound workload is likely to be and also it is possible…
