…Table with VARCHAR: CREATE TABLE cities_varchar ( id int(10) unsigned NOT NULL auto_increment, state…in this table so changing state from VARCHAR to ENUM or TINYINT affects row size significantly. In many cases size… no cost of the join in this case because there is really no join: mysql> EXPLAIN …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…TINYINT(4) DEFAULT NULL, `CarrierDelay` INT(11) DEFAULT NULL, `WeatherDelay` INT(11) DEFAULT NULL, `NASDelay` INT(11) DEFAULT NULL, `SecurityDelay` INT(11) DEFAULT NULL, `LateAircraftDelay` INT…in initial years and up to 48s/chunk for 2008 year. And total load time is 8836 sec (2.45h). The size of…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…size rows, auto increment primary key and couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int…NULL default ”, `state_id` tinyint(3) unsigned NOT …in terms of CPU usage. In…size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs…size rows, auto increment primary key and couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int… `state_id` tinyint(3) …size : 1024 KB 4GB of RAM MySQL version We used MySQL…
