… with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in…$I ( id BIGINT UNSIGNED NOT NULL, k INTEGER UNSIGNED DEFAULT ’0′ NOT NULL, c CHAR(120) DEFAULT ” NOT NULL, pad CHAR(60) DEFAULT ” NOT NULL, PRIMARY KEY (id…(10) unsigned NOT NULL DEFAULT ’0′, `mid` int(10) unsigned NOT NULL DEFAULT ’0′, `id` bigint(20) unsigned NOT NULL, `k` int(10) unsigned NOT NULL DEFAULT ’0…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… vs Innodb. I used the following simple table for tests: CREATE TABLE `antest` ( `i` int(10) unsigned NOT NULL, `c` char(80) default NULL… | i | 1 | i | A | NULL | NULL | NULL | | BTREE | | | antest | 1 | c | 1 | c | A | NULL | NULL | NULL | YES | BTREE | | | antest | 1 | c | 2 | i | A | NULL | NULL | NULL | | BTREE… loading the data with INSERT in Innodb table we do not get NULL cardinality as with MyISAM but instead we get very…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…NULL, `Div5WheelsOff` varchar(10) DEFAULT NULL, `Div5TailNum` varchar(10) DEFAULT NULL ) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=latin1; Last fields starting with “Div*” are not … there is graph: Conclusions: This experiment was not really about InfoBright vs MonetDB comparison. My goal was to check how …
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… cities_varchar ( id int(10) unsigned NOT NULL auto_increment, state varchar(50) NOT NULL, city varchar(255) NOT NULL, PRIMARY KEY (id), KEY state (state…_join ( id int(10) unsigned NOT NULL auto_increment, state_id tinyint(3) unsigned NOT NULL, city varchar(255) NOT NULL, PRIMARY KEY (id), KEY state…
Post: Multiple column index vs multiple indexes
August 22, 2008 By 13 Comments
… there were questions raised about Index Merge on Multiple Indexes vs Two Column Index efficiency. I mentioned in most cases when… tables: CREATE TABLE `t1000idxmerge` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `val` char(10) NOT NULL, KEY `i` (`i`), KEY `j` (`j`) ) ENGINE…=latin1 CREATE TABLE `t1000idx2` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `val` char(10) NOT NULL, KEY `i` (`i`,`j`) ) ENGINE=MyISAM DEFAULT…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…(1) NOT NULL, `l_linestatus` char(1) NOT NULL, `l_commitdate` date NOT NULL, `l_receiptdate` date NOT NULL, `l_shipinstruct` char(25) NOT NULL, `l_comment` varchar(44) NOT NULL, `l_shipmode` char(10) NOT NULL, PRIMARY…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So…NOT EXISTS lineorder ( LO_OrderKey bigint not null, LO_LineNumber tinyint not null, LO_CustKey int not null, LO_PartKey int not null, LO_SuppKey int not null, LO_OrderDateKey int not null…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… NOT NULL auto_increment, `name` varchar(64) NOT NULL default ”, `email` varchar(64) NOT NULL default ”, `password` varchar(64) NOT NULL default ”, `dob` date default NULL, `address` varchar(128) NOT NULL default ”, `city` varchar(64) NOT NULL default…
Post: UNION vs UNION ALL Performance
October 5, 2007 By 15 Comments
… performance of UNION vs MySQL 5.0 index merge algorithm Sinisa… Numbers would be different but it should not change general point of having optimization … *************************** id: NULL select_type: UNION RESULT table: type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL …
Post: COUNT(*) vs COUNT(col)
April 10, 2007 By 45 Comments
… TABLE `fact` ( `i` int(10) unsigned NOT NULL, `val` int(11) default NULL, `val2` int(10) unsigned NOT NULL, KEY `i` (`i`) ) ENGINE=MyISAM DEFAULT…(val2) queries, but not COUNT(val). Why ? Because val column is not defined as NOT NULL there can be some NULL values in it and… scan only if it is needed because column can be NULL. Now lets try few more queries: mysql> select count(*) from…
