Re: INSERT IGNORE ... SELECT performance question

[John Nahlen]

Dang, frustrating, I've tried making two posts earlier today and neither one seem to have gotten through.

move table (only relevant columns included):

CREATE TABLE `move` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fenbefore` varchar(90) DEFAULT NULL,
  `fenafter` varchar(90) DEFAULT NULL,
  `position` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fenafter_index` (`fenafter`),
  KEY `fenbefore_index` (`fenbefore`) USING BTREE,
  KEY `position_index` (`position`),

) ENGINE=MyISAM AUTO_INCREMENT=19512 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED

Explain:

 
id, select_type, table, type, possible_keys, key , key_len, ref , rows , Extra
1 , SIMPLE     , move , ALL , NULL         , NULL, NULL   , NULL, 19511,

before reading your webpage, my key_buffer_size was 685MB on a 4 GB machine.

I've never worked with InnoDB but if you think it will help I'll try it.

Thanks for replying.



Edited 3 time(s). Last edit at 07/23/2011 10:15PM by John Nahlen.