… index by sort of key_cache as it can for MyISAM. EXPLAIN may take long time In MySQL 5….NULL | PRIMARY | 4 | NULL | 1600 | Using index | +—-+————-+——-+——-+—————+———+———+——+——+————-+ 1 row in set (0.00 sec) This statement obviously will not…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… does the relevance sorting by default, adding relevance sorting to the MySQL queries would… tested MyISAM FT index, I reallocated that memory to into key_buffer…the `FTS_DOC_ID` primary key column properly, MySQL crashed with an out… respect to individual features, not in the context of application …
Post: What's up with HandlerSocket?
March 28, 2011 By 43 Comments
…MyISAM simply because it was the default. Even today, many organizations using recent versions of MySQL 5.1 are not using the InnoDB plugin because it is not enabled by… use cases This is sort of a chicken-and…has focused almost entirely on primary-key-select workloads because that …
Post: Finding out largest tables on MySQL Server
February 4, 2008 By 27 Comments
… idxfrac FROM information_schema.TABLES ORDER BY data_length + index_length DESC LIMIT 10… for MyISAM can also help you to size your key … may be there is long primary key with Innodb tables. Of …bit to look for different sorting order or extra data – … have active. It does not work with MySQL before 5….
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…NOT NULL auto_increment, state varchar(50) NOT NULL, city varchar(255) NOT NULL, PRIMARY KEY (id), KEY state (state) ) ENGINE=MyISAM…keys: PRIMARY key: PRIMARY key_len: 1 ref: test.c.state_id rows: 1 Extra: 2 rows in set (0.00 sec) Because we’re sorting by…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
…primary key order into Innodb tables for optimal performance, but effect does not end here. If indexes are built by…two main ways to load data in MySQL you can use Multiple value insert (standard…back – helpful to make sure MyISAM build indexes via sorting not by BTREE insertion. For Innodb SET UNIQUE…
Post: Are larger buffers always better ?
June 6, 2006 By 9 Comments
…MySQL sample configuration is designed for 2GB and they happen to have 16, they would simply multiply all/most values by…NOT NULL default ’0′, `c` char(10) default NULL, `d` int(11) default NULL, PRIMARY KEY (`id`), KEY `d` (`d`) ) ENGINE=MyISAM…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 31 Comments
…not exactly what it gets from the index – typically (unless it is covering index) MySQL gets a “row pointer” which can be primary key value (for Innodb tables) physical file offset (for MyISAM…
Comment: Why MySQL could be slow with large tables ?
November 29, 2006 By 141 Comments
…MySQL is rather fast loading data in MyISAM table, but there is exception, which is when it can’t rebuild indexes by sort…sort_file_size) or it could be just lack of optimization, if you’re having large (does not fit in memory) PRIMARY…problem is – unique keys are always rebuilt using key_cache, which…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
…sorts of different things: Versions later than MySQL 5.0.33 are not…corrupted more seldom than MyISAM. Thanks to checksums …not caused by faulty hardware. Primary keys are typically simple integer keys in Innodb while secondary keys may have very complex structure. Compex corruptions are resolved by…
