… vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1)…`country_id` smallint(5) unsigned NOT NULL default ‘0‘, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), … on disk) 2. Run each query for 1, 4, 16, 64, 128, 256, 512 concurrent threads. …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… let us first take a look 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 hour so…. Vadim has already Wrote about it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… data set we’ve used for this benchmark. We have 4 tables: 1) Table with ENUM: CREATE TABLE cities_enum ( id int…_varchar WHERE state=’Minnesota’ limit 10000,5; Result time(mean): 0.085637 3) Results for INT + join: select SQL_NO_CACHE… this case: for VARCHAR it takes about 0.022 per query which makes it about 4 times faster than for MyISAM. This…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 31 Comments
… | 1 | SIMPLE | idxtest | index_merge | i1,i2 | i1,i2 | 4,4 | NULL | 1032 | Using intersect(i1,i2); Using where | +—-+————-+———+————-+—————+——-+———+——+——+————————————-+ 1 row in set (0.00…,i2,combined | i2,i1 | 4,4 | NULL | 959 | Using intersect(i2,i1); Using where | +—-+————-+———+————-+—————-+——-+———+——+——+————————————-+ 1 row in set (0.00 sec) Hm… Optimizer decides…
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 `email` (`email`), KEY `country_id… schema and queries are described here Used hardware CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name… 350Mb of data on disk) 2. Run each query for 1, 4, 16, 64, 128, 256 concurrent threads. 3. For each thread…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… blocksize random write workload): ext4 1 thread: 87 MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping… xfs 4 threads: 97 MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs…=rndwr –max-time=3600 –max-requests=0 –num-threads=$numthreads –rand-init=on –file-num=1 –file-extra-flags=direct –file-fsync…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… 0.9.1 The table I loaded data is: CREATE TABLE `ontime` ( `Year` year(4) DEFAULT NULL, `Quarter` tinyint(4) DEFAULT NULL, `Month` tinyint(4… DESC Result: [ 5, 1816486 ] [ 4, 1665603 ] [ 1, 1582109 ] [ 7, 1555145 ] [ 3, 1431248 ] [ 2, 1348182 ] [ 6, 1202457 ] And 0.9s execution for MonetDB and… and InfoBright: 0.31s To group all results there is graph: Conclusions: This experiment was not really about InfoBright vs MonetDB comparison…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… 1.57M 0 1 0.94 0.99 0.24 0.99 # Rows examine 4 1.57M 0 1 0.94 0.99 0.24 0.99 # Rows affecte 0 0 0 0 0 0 0 0 # Rows read 32 1.70M 0 3 1.02 1.96 0… performance, what kind of hardware provides better balance of CPU vs IO utilization as well as as simple as how much…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… workload. Versions in question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5… 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…) 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…
Post: COUNT(*) vs COUNT(col)
April 10, 2007 By 45 Comments
…=latin1 mysql> select count(*) from fact; +———-+ | count(*) | +———-+ | 7340032 | +———-+ 1 row in set (0.00 sec) mysql> select count(val) from fact; +————+ | count…> select count(val2) from fact; +————-+ | count(val2) | +————-+ | 7340032 | +————-+ 1 row in set (0.00 sec) As this is MYISAM table MySQL has…
