…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: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…1 1 1 1 1 1 Sort_scan 1 1 1 1 1 1…vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 5…performance gain. This is not entirely visible in the manual either for MariaDB or MySQL…
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: 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… 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… 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
… 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… about it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We can see MySQL capabilities to run… and may be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0 I…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… schema and queries are described here Used hardware CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name… of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/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: 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… 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…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… 3.40GHz. InfoBright (ICE) version: 5.1.14-log build number (… that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD… DESC with result: [ 5, 7509643 ] [ 1, 7478969 ] [ 4, 7453687 ] [ 3, 7412939 ] [ 2, 7370368 ] [ 7,… was not really about InfoBright vs MonetDB comparison. My goal …air performance…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…Percona Server 5.1.57 – released and Percona Server 5.1.57 with …1 352.83 371.17 2 682.41 676.39 4…performance significantly. And the similar with writeback cache enabled thread trx=1, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1…There is still performance difference binlogs vs no-binlogs, but…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we … 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes …0.24 0.99 # Rows examine 4 1.57M 0 1 0.94 0.99 0.24 …to reach appropriate performance, what kind of hardware provides better balance of CPU vs IO …
