… Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database… than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4…. performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-…sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. …vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… I wanted to compare InnoDB performance vs TokuDB. I have a …). Also please note the transaction produces 4 INSERTs and workload is very…5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql…innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G …
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: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… the PERFORMANCE_SCHEMA, and paths are unique for basedir and datadir I tested three configurations: Config 1: Default config for MySQL 5.5 and MySQL 5.6…). 12GB memory 4 disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response times…
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: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
…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: 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: 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…
