… 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…’ + interval ‘1‘ year AND l_discount BETWEEN 0.09 – 0.01 AND 0.09 + 0.01 AND l_quantity < 24; with execution plain (in 5.1) +—-+————-+———-+——-+—————+—————+———+——+———+————-+ | id…_receiptdate`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 with 59986052 rows So this query takes 32.27 sec to execute in 5.1, and 39…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…and it can’t be because we used MyISAM tables which are not ACID complaint. Plus …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… his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We can see MySQL capabilities…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…MySQL Optimizer Bug 
But now lets see in the difference of behavior of ANALYZE TABLE for MyISAM vs… | antest_innodb | 1 | i | 1 | i | …MySQL version note: This is from MySQL 5.0…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket…= 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover skip… difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is …
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
…MySQL) so do not just compare it directly. It also does not mention if Innodb or MyISAM…MySQL 4.1 actually scaled pretty well with Niagra, suffering slow regression with increased concurrency rather than quick drop. In MySQL 5.0… Linux vs Solaris comparison is also pretty interesting. With MySQL …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The difference is …RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…` varchar(8) NOT NULL default ”, `country_id` smallint(5) unsigned NOT NULL default ‘0‘, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY… 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…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 30 Comments
…MyISAM DEFAULT CHARSET=latin1 I made columns i1 and i2 independent in this case each selecting about 1…(i2,i1); Using where | +—-+————-+———+————-+—————-+——-+———+——+——+————————————-+ 1 row in set (0.00 sec) Hm…in MySQL 5…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…-comparison-of-myisam-infobright-and-monetdb/)…. InfoBright (ICE) version: 5.1.14-log build…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…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… of DRBD. If you’re using MySQL with Innodb (and running MyISAM with DRBD makes little sense anyway) …_at_trx_commit=1 and sync_binlog=1 you will have 4 “sync” operations in MySQL 5.0 – there is event … network IO we’re speaking about 300 microseconds vs 5000 microseconds and DRBD overhead can be well…
