…1 thread: 87 MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4…MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…5.5 Hash Join Disabled w/ join_buffer_size=4M & mrr_buffer_size=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1…performance gain. This is not entirely visible in the manual either for MariaDB or MySQL…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… 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 a lot… perform 5.1 and 6.0 in cold mode (I dropped OS caches by `echo 1 > /proc/sys/vm/drop_caches` and restarting mysqld) 5.1 – time 1… scan will be performed in this case) then we got: 1 min 39.14 sec to execute query (compare with 1 hour 14…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… at MySQL 5.1.23 vs 6.0.4 results for 10GB data set which “fits in memory”. The cut-off time for this test was 1… 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… 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…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL …the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an … {540} dm-0 447.1 34.0 7.4 0% 2.4 5.4 23.4 49.6 0.6 0% 0.0 0.6 85% 0 Misaligned: #ts …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…NULL default ”, `country_id` smallint(5) unsigned NOT NULL default ‘0‘, PRIMARY KEY (`id`), UNIQUE KEY …described here Used hardware CentOS release 4.4 (Final) 2 Ñ… Dual Core …mysql-5.1-falcon for Falcon (Please note this is a first release of Falcon and it is still in alpha stage and performance…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…ICE) version: 5.1…. 5, 7509643 ] [ 1, 7478969 ] [ 4, 7453687 ] [ 3, 7412939 ] [ 2…0.5s for MonetDB and 2.92s for InfoBright. Warnings: do not try EXPLAIN this query in InfoBright. MySQL…0.31s To group all results there is graph: Conclusions: This experiment was not really about InfoBright vs…performance…
Page: Presentations
May 3, 2006 By
…. Download MySQL Performance 5.0 vs 4.1 MySQL Users Conference 2006, Santa Clara, CA This presentation shows in numbers performance differences in MySQL 4.1 and 5.0, showing most important performance improvements and… MySQL Performance. Download MySQL and PHP for Web Applications Open Source Revolution 2002, Stockholm, Sweden Presentation about MySQL Server features and ways Focuses on MySQL 4.0…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… more overhead. Profiling MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5.0 grammar became much bigger… raw results, in tps (more is better) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639.73 596.01 593.51…
