… with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in… 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… 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‘, PRIMARY…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…` date default NULL, `address` varchar(128) NOT NULL default ”, `city` varchar(64) NOT NULL default ”, `state_id` tinyint(3) unsigned NOT NULL default ‘0‘, `zip` varchar(8) NOT NULL default ”, `country_id` smallint(5) unsigned NOT NULL default ‘0…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…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: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…was busy replicating events vs staying idle. Note …NULL | | 802354 | root | localhost | NULL | Query | 0 | NULL | show processlist | +——–+————-+———–+——+———+——+———————————————————————–+——————+ 3 rows in set (0…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…NULL | NULL | NULL | YES | BTREE | | | antest | 1 | c | 2 | i | A | NULL | NULL | NULL | | BTREE | | +——–+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+ 3 rows in set (0…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… tested only READ queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb… NULL default ”, `state_id` tinyint(3) unsigned NOT NULL default ‘0‘, `zip` varchar(8) NOT NULL default ”, `country_id` smallint(5) unsigned NOT NULL default ‘0…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… ( id int(10) unsigned NOT NULL auto_increment, state varchar(50) NOT NULL, city varchar(255) NOT NULL, PRIMARY KEY (id), KEY state…_varchar WHERE state=’Minnesota’ limit 10000,5; Result time(mean): 0.085637 3) Results for INT + join: select SQL_NO_CACHE…: SIMPLE table: c type: ALL possible_keys: state key: NULL key_len: NULL ref: NULL rows: 1439943 Extra: Using temporary; Using filesort *************************** 2…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
… latin1 collate latin1_bin NOT NULL, `time_id` date NOT NULL, `block_id` int(10) unsigned default NULL, PRIMARY KEY (`tracker_id`,`username… | 37864 | | Innodb_scan_pages_jumpy | 574 | +——————————+——-+ 2 rows in set (0.00 sec) and extended stats: # Query_time: 17.765369 Lock…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…-01′ + interval ’1′ year AND l_discount BETWEEN 0.09 – 0.01 AND 0.09 + 0.01 AND l_quantity < 24; with execution plain...) 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…
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… TABLE `t1000idx2` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `val` char(10) NOT NULL, KEY `i` (`i`,`j`) ) ENGINE=MyISAM… time from result in the table. time for ((i=0;i /dev/null In the result table I compute per query results…
