…mysql> show index from antest; +——–+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index…
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… is MyISAM table which is accessed via index, which means to retrieve each row MySQL will have to perform OS system call… can’t be done by index and extra sort pass (filesort) is required, which also makes MySQL to store Join result in…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of … HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, …unique constraint: it is sufficient if the referenced columns form a consecutive set of leftmost columns of any index…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www…. key and couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( …NULL default ’0′, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY `country_id…KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…increment primary key and couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id`… NOT NULL default ’0′, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY `country_id` …MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
…indexed post has (or actually position * chunkid). Reversed index is often described as using unsigned int where each unique…index and the vectorbased storage regarding size needed on disk. Not only space needed is changed between using regular reversed index vs…, linux 2.6 and mysql 4.1.18 was used …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… need to add/remove indexes and do other…busy replicating events vs staying idle. Note…mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql…Overall: 1.22M total, 1.27k unique, 558.56 QPS, 0.37x…
Comment: To UUID or not to UUID ?
April 15, 2008 By 28 Comments
… with UUID’s in MySQL when stored as text. Ideally, MySQL would have a … performance in terms of storage and indexing (a 16-byte column instead of 36…the overhead is much smaller (22 bytes vs. 16) and you are able to … very good balance between speed and uniqueness. They can also be translated to GUID…
