… rough code for this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… almost to zero. We will run benchmarks with Thread Pool vs no-Thread Pool so we will see exact curve there…
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…
Comment: COUNT(*) for Innodb Tables
December 20, 2011 By 32 Comments
… | +—————+————–+——+—–+———+—————-+ | id | bigint(20) | NO | PRI | NULL | auto_increment | | id_acct | int(11) | NO | MUL | 0 | | mysql> select count(id_acct) from… it’s due to the difference in field type (bigint vs int).
Comment: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
August 4, 2009 By 30 Comments
In the test you used int+join table, what if we move the join table functionality to our application and just compare ENUM VS CHAR VS INT.
Comment: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
February 20, 2009 By 30 Comments
[...] about it, but after that session I was looking up some VARCHAR vs CHAR debate information and found this post on the MySQL Performance Blog. Turns out his idea isn’t really that crazy (performance-wise, at [...]
Comment: Using CHAR keys for joins, how much is the overhead ?
June 22, 2007 By 18 Comments
I tried running VARCHAR vs CHAR for sha1 ids The join took 3.90 seconds for CHAR(40) and 4.05 seconds for VARCHAR(40) using latin1 encoding Innodb tables. So there is indeed benefits from using CHAR type for this type of column while it is not significant.
Post: Trailing spaces in MySQL
November 27, 2006 By 7 Comments
… if you mind trailing spaces stored choosing VARCHAR vs CHAR in addition to fixed length vs dynamic level rows and space spent for… comparison is done trailing spaces are always removed, even if VARCHAR column is used which is pretty counterintuitive. So “a “=”a”=”a ” for all textual column types – CHAR, VARCHAR, TEXT. BLOB is exception it will preserve trailing spaces and…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… id=”attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far…_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: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…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… experiment was not really about InfoBright vs MonetDB comparison. My goal was …
