… Table: CREATE TABLE `test` ( `id` int(11) NOT NULL AUTO_INCREMENT, `col2` int(11) DEFAULT NULL, `col3` varchar(200) DEFAULT NULL, PRIMARY KEY…`), # KEY `col2_2` (`col2`,`col3`) # Column types: # `col2` int(11) default null # `col3` varchar(200) default null # To remove this duplicate index…` (`col2`,`id`) # PRIMARY KEY (`id`), # Column types: # `col2` int(11) default null # `id` int(11) not null auto_increment # To shorten this…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
… `menu` ( `id` int(11) NOT NULL auto_increment, `label` varchar(50) NOT NULL default ”, `link` varchar(100) NOT NULL default ‘#’, `parent` int(11) NOT NULL default ’0′, `sort` int(11) default…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…` int(10) unsigned NOT NULL, `NAME` varchar(255) DEFAULT NULL, `MTYPE` int(10) unsigned DEFAULT NULL, `PRTYPE` int(10) unsigned DEFAULT NULL, `LEN` int(10) unsigned DEFAULT NULL, `PREC` int(10…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…, city varchar(255) NOT NULL, PRIMARY KEY (id), KEY state (state) ) ENGINE=MyISAM; 2) Table with VARCHAR: CREATE TABLE cities_varchar ( id int(10) unsigned NOT NULL auto_increment, state varchar(50) NOT NULL, city varchar(255) NOT NULL…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…` int(11) DEFAULT NULL, `LateAircraftDelay` 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…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
November 1, 2009 By 50 Comments
…, CRSDepTime int DEFAULT NULL, DepTime int DEFAULT NULL, DepDelay int DEFAULT NULL, DepDelayMinutes int DEFAULT NULL, DepDel15 int DEFAULT NULL, DepartureDelayGroups int DEFAULT NULL, DepTimeBlk varchar(20…, CRSArrTime int DEFAULT NULL, ArrTime int DEFAULT NULL, ArrDelay int DEFAULT NULL, ArrDelayMinutes int DEFAULT NULL, ArrDel15 int DEFAULT NULL, ArrivalDelayGroups int DEFAULT NULL, ArrTimeBlk varchar(20…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…` INT(11) DEFAULT NULL, `LateAircraftDelay` 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…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…_CustomerKey int primary key, C_Name varchar(25), C_Address varchar(25), C_City varchar(10), C_Nation varchar(15), C_Region varchar(12), C_Phone varchar…_PartKey int primary key, P_Name varchar(25), P_MFGR varchar(10), P_Category varchar(10), P_Brand varchar(15), P_Colour varchar(15), P_Type varchar…
Post: Handling big result sets
June 26, 2006 By 13 Comments
… NULL, `f9` varchar(13) default NULL, `f10` varchar(39) default NULL, `f11` int(11) default NULL, `f12` float default NULL, `f13` int(11) default… NULL, `f26` varchar(13) default NULL, `f27` varchar(39) default NULL, `f28` int(11) default NULL, `f29` float default NULL, `f30` int(11) default…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…_id` int(10) unsigned NOT NULL auto_increment, `url_from` varchar(255) NOT NULL, `url_to` varchar(255) NOT NULL, `anchor` varchar(255) NOT NULL, `from_site_id` int(10) unsigned NOT…, `revert_domain` varchar(255) NOT NULL, `url_prefix` varchar(255) NOT NULL, `from_domain_id` int(10) unsigned NOT NULL, `ext` varchar(25) NOT…
