… a customer benchmarking insert performance on Amazon EC2, and I have … let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5…Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that …as large, because it varies between ~6.5k to ~12.5k INSERTs per …
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… SSD performance is getting closer to PCIe cards. It really makes sense to test it under MySQL workload,… 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
…. MySQL Status Counters These status counters were 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… 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
…to the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I …query time is for MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5 While …best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but…
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
…xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for… is not available on my CentOS 6.2, so I could not test …It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 …–file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block-…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… those presented in TPC-H benchmark are still subpar even with changes which are currently seen in MySQL 6.0 tree. There is a… Release and may be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0 I expected drastically better…
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… but in batches reads. So let us see how perform 5.1 and 6.0 in cold mode (I dropped OS caches by…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
…benchmarks comparing different MySQL versions in terms of their CPU…MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about 6…some workloads when MySQL 5.1 is slower than 5.0, and same … uses more CPU while delivering better performance so it is probably better …
Post: MySQL Optimizer team comments on TPC-H Results
April 14, 2008 By 1 Comment
… notes about little gains in MySQL 6.0. Do not get this post wrong. I’m not saying MySQL 6.0 SubQuery optimizations are non existent…-H queries or queries from any other benchmarks, rather they look at the queries which MySQL Users have problem with and first… make it into final MySQL 6.0 release. Summary: Poor MySQL 6.0 performance on TPC-H queries does NOT mean to quantify MySQL Optimizer Team work in…
