…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 31 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: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6…0.5+, the time taken for “FLUSH TABLES WITH RAED LOCK” is normally under 1 second. Tips/Tricks: If you have a lot of non-transactional tables (i.e. myisam… mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we…
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…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM; All cities_* tables have 1,5M records each and records are distributed among… quite expected – This is MyISAM table which is accessed via index, which means to retrieve each row MySQL will have to perform… longer. 1) Results for ENUM: select SQL_NO_CACHE city, state from cities_enum limit 10000, 5; Result time(mean): 0.003125 2…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…. I wanted to see how fast MyISAM vs. MonetDB would interpret really large INSERT statements…c89), sum(c129) from t where c11 > 5; select sum(c19), sum(c89), sum(c129… 3.4   0.15   1.2 query3 time   2…abstracted front-end is a great idea; MySQL abstracts the storage backend, but why not…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… in a batch vs 40 seconds for single row statements. So with single statement MyISAM was about 10% faster…5.0. At row0sel.c:row_search_for_mysql() “PHASE 3:”, InnoDB judge whether the SQL is “SELECT” or not. 5.0… is great to see however it is fixed in MySQL 5.1 It also explains why the problem took a …
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…1 | Mysql | | 2 | Solid | | 3 | MyISAM | +—-+———–+ Session1: mysql> begin; Query OK, 0 rows affected (0.00 sec) Session2: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql…
