… 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool …the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made … be classified as large, because it varies between ~6.5k to ~12.5k INSERTs per second, with …
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
…cards. It really makes sense to test it under MySQL workload, but before getting to that, let me …10 build 110; Firmware v5.0.7, rev 107053 Following the format of previous benchmarks, first is random write … 520. For 8 threads it is 0.6 ms ( for Intel 520 – 0.69 ms). To better understand patterns …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… hours in case of MySQL 5.6 and MariaDB 5.5. Note that query cache is disabled during these benchmark runs and that… 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_bufer… 1 1 1 1 1 Handler_mrr_init N/A 0 0 1 1 Handler_mrr_rowid_refills N/A N/A…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… move on to the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I have used TPC… the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set… the lowest query time is for MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5 While with join_buffer…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by… enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… but that option is not available on my CentOS 6.2, so I could not test it. At … MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually…-num=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block-size=16384 –report…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l_extendedprice * l… to find is Baron’s bug with no mention in MySQL 6.0 manual. No mentions about Using MRR also, but I guess…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… seconds. Ratio is MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0… those presented in TPC-H benchmark are still subpar even with changes which are currently seen in MySQL 6.0 tree. There is a…
Post: MySQL 6.0 Subquery optimizations are published.
February 6, 2008 By 4 Comments
… in MySQL 6.0 which is far from all the issues but still very good number. If you had issues with subqueries in MySQL 4.1 or 5.0 and pulled away from using them I’d encourage you to try MySQL 6.0 and see… in Progress and Plans, Benchmarks and Test Results Hopefully in the future we’ll see more MySQL teams being proactive with publishing…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
…’ve recently done benchmarks comparing different MySQL versions in terms of their CPU efficiently in TPC-C…. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about 6% … us there are some workloads when MySQL 5.1 is slower than 5.0, and same applies to the new …
