…, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m…NULL, c CHAR(120) DEFAULT ” NOT NULL, pad CHAR(60) DEFAULT ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on … ’0′, `id` bigint(20) unsigned NOT NULL, `k` int(10) unsigned NOT NULL DEFAULT ’0′, PRIMARY KEY …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
….6 vs MySQL … | +——————-+——————+——-+——+——+———+—————–+ | `ssb`.`lineorder` | GEN_CLUST_INDEX | 6001 | 2095 | 3906 | 964974 |…int primary key, D_Date char(18), D_DayOfWeek char(9), D_Month char(9), D_Year smallint, D_YearMonthNum int, D_YearMonth char…
Post: Multiple column index vs multiple indexes
August 22, 2008 By 13 Comments
… my previous post there were questions raised about Index Merge on Multiple Indexes vs Two Column Index efficiency. I mentioned in most cases when query can use both of the ways using multiple column index… simple tables: CREATE TABLE `t1000idxmerge` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `val` char(10) NOT NULL, KEY `i` (`i…
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…NULL, `l_returnflag` char(1) NOT NULL, `l_linestatus` char(1) NOT NULL, `… See there are new Extra notes USING INDEX condition; USING MRR. It would…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… ) ENGINE=MyISAM; 3) Table with INT: CREATE TABLE cities_join ( id int(10) unsigned NOT NULL auto_increment… ( `id` tinyint(3) NOT NULL auto_increment, `name` char(40) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `…- This is MyISAM table which is accessed via index, which means to retrieve each row MySQL …
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… note MySQL only saves very basic cardinality information for index prefixes for index stats and these rarely change. There is no histograms… ? Also note many simple “queries” (using constants for index accesses) will not use index cardinality data at all but will estimate number… MyISAM vs Innodb. I used the following simple table for tests: CREATE TABLE `antest` ( `i` int(10) unsigned NOT NULL, `c` char(80…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…char(1) DEFAULT NULL, `Diverted` tinyint(4) DEFAULT NULL, `CRSElapsedTime` INT(11) DEFAULT NULL, `ActualElapsedTime` INT(11) DEFAULT NULL, `AirTime` INT…experiment was not really about InfoBright vs MonetDB comparison. My goal … they also do not have indexes like InfoBright, but results are impressive…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
… table is CREATE TABLE `c` ( `tracker_id` int(10) unsigned NOT NULL, `username` char(20) character set latin1 collate latin1_bin NOT NULL, `time_id` date NOT NULL, `block_id` int(10) unsigned… (tough it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so be careful with queries scan many records by…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…case of index tree not fitting into memory. This is not simply the case of 32 bytes vs 4 …containing just integer auto_increment primary key and containing char(36) value and used for UUID primary key … efficiently ? They would not be as efficient as Ints simply because size matters but you can do …
