… integer value and having value mapping done on application level. So, first of all, a…VARCHAR: CREATE TABLE cities_varchar ( id int(10) unsigned NOT NULL auto_increment, state varchar(50) NOT NULL, city varchar(… This is MyISAM table which is accessed via index, which means to retrieve each row MySQL…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 30 Comments
… multi-column index on (AGE,STATE). Lets see why it is the case. MySQL indexes are (with few exceptions) BTREE indexes – this index type is… now: CREATE TABLE `idxtest` ( `i1` int(10) unsigned NOT NULL, `i2` int(10) unsigned NOT NULL, `val` varchar(40) DEFAULT NULL, KEY `i1… to use second index and hence index merge, what does it turn to ? It is not combined index but single index on another column. This…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(64) NOT NULL default ”, `email` varchar…falcon.html (Note: This benchmark is synthetic micro benchmarks focusing on particular simple data access patterns. Results for your workload …
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…` int(11) NOT NULL, `l_partkey` int(11) NOT NULL, `l_suppkey` int(11) NOT NULL, `l_linenumber` int(11… `l_shipinstruct` char(25) NOT NULL, `l_comment` varchar(44) NOT NULL, `l_shipmode` char(10) NOT…on this server. This is because of Random I/O we had during execution of query, as MySQL used index…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…INT(11) DEFAULT NULL, `FirstDepTime` varchar(10) DEFAULT NULL, `TotalAddGTime` varchar(10) DEFAULT NULL, `LongestAddGTime` varchar(10) DEFAULT NULL, `DivAirportLandings` varchar(10) DEFAULT NULL, `DivReachedDest` varchar… InfoBright vs MonetDB…indexes like InfoBright, but results are impressive. On…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www….indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(64) NOT NULL default ”, `email` varchar… is synthetic micro benchmarks focusing on particular simple data access patterns…
