… MyISAM vs Innodb. I…index from antest; +——–+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index…
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(10) unsigned…` smallint(5) unsigned NOT NULL default ’0′, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY `country_id` (`country_id`,`state_id… the data or can only be satisfied by reading the index. This benchmark is so called “micro” benchmark which concentrates on…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… auto_increment, `name` char(40) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM; All cities_* tables have 1… quite expected – This is MyISAM table which is accessed via index, which means to retrieve each row MySQL will have to… scan performs about 25 times better than accessing rows via index (for the case when data fits in memory!) So, if…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… scans and index scans more efficient. I can’t wait for ability to create physically sorted indexes with Innodb (with index built by… a 3x performance boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of the checkpointing rate… or a unique constraint: it is sufficient if the referenced columns form a consecutive set of leftmost columns of any index. Can…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… which the indexed post has (or actually position * chunkid). Reversed index is often described as using unsigned int where each unique word gets… reversed index and the vectorbased storage regarding size needed on disk. Not only space needed is changed between using regular reversed index vs…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/… increment primary key and couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id`…unsigned NOT NULL default ’0′, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY `country_id` (`…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…runs normally – if you need to add/remove indexes and do other schema changes you probably would…time the replication thread was busy replicating events vs staying idle. Note you can speak about idle…Files: slow-log # Overall: 1.22M total, 1.27k unique, 558.56 QPS, 0.37x concurrency ______ # total min…
Comment: To UUID or not to UUID ?
April 15, 2008 By 28 Comments
…would provide better performance in terms of storage and indexing (a 16-byte column instead of 36). In …, and the overhead is much smaller (22 bytes vs. 16) and you are able to convert to …and strike a very good balance between speed and uniqueness. They can also be translated to GUID’s (########-…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
April 10, 2007 By 117 Comments
Hi Michal, Please tell me if you have done the followings 1. set autocommit=0 so you do not commit after each insert. This is the difference between Innodb vs MyIsam 2. disable index keys (not uniques ones which u might need) Catalinux
