Comment 4 for bug 683310

Revision history for this message
Lee Bieber (kalebral-deactivatedaccount) wrote :

From "show create table bench1'

Table Create Table
bench1 CREATE TABLE `bench1` (
  `field1` INT NOT NULL,
  `field_search` INT NOT NULL,
  `field2` INT NOT NULL,
  `field3` INT NOT NULL,
  `field4` VARCHAR(16) COLLATE utf8_general_ci NOT NULL,
  `field5` INT NOT NULL,
  `field6` DOUBLE NOT NULL,
  `field7` DOUBLE NOT NULL,
  `field8` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
  `field9` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
  `field10` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
  `field11` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
  `field12` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
  `field13` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
  `field14` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
  `field15` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
  `field16` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`field1`,`field2`,`field3`,`field4`,`field5`,`field6`,`field7`,`field8`,`field9`,`field10`,`field11`,`field12`,`field13`,`field14`,`field15`,`field16`),
  KEY `index2` (`field_search`),
  KEY `index3` (`field3`),
  KEY `index4` (`field4`),
  KEY `index5` (`field5`),
  KEY `index6` (`field6`),
  KEY `index7` (`field7`),
  KEY `index8` (`field8`),
  KEY `index9` (`field9`),
  KEY `index10` (`field10`),
  KEY `index11` (`field11`),
  KEY `index12` (`field12`),
  KEY `index13` (`field13`),
  KEY `index14` (`field14`),
  KEY `index15` (`field15`),
  KEY `index16` (`field16`)
) ENGINE=InnoDB COLLATE = utf8_general_ci