CREATE TABLE IF NOT EXISTS `t1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `a1` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a2` int(11) DEFAULT NULL,
  `a3` enum('e1','e2','e3','e4','e5','e6','e7','e8') COLLATE utf8_unicode_ci DEFAULT 'e1',
  `a4` int(11) DEFAULT NULL,
  `a5` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a6` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ,
  `a8` int(11) NOT NULL DEFAULT '0',
  `a9` enum('e1','e2','e3','e4','e5','e6','e7','e8','e9','e19','e11','e12') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'e9',
  `a10` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a11` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a12` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `a13` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a14` int(11) DEFAULT NULL,
  `a15` text COLLATE utf8_unicode_ci,
  `a16` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a17` text COLLATE utf8_unicode_ci,
  `a18` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a19` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a20` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a21` int(11) DEFAULT '0',
  `a22` int(11) DEFAULT '0',
  `a23` int(11) DEFAULT '0',
  `a24` int(11) DEFAULT '0',
  `a25` enum('y','n') COLLATE utf8_unicode_ci DEFAULT 'n',
  `a26` enum('e1','e2','e3','e4','e5','e6') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'e1',
  `a27` enum('y','n') COLLATE utf8_unicode_ci DEFAULT 'n',
  `a28` enum('y','n') COLLATE utf8_unicode_ci DEFAULT 'y',
  `a29` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `a16` (`a16`),
  KEY `a12` (`a12`),
  KEY `a8` (`a8`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `t2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `a1` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a2` int(11) DEFAULT NULL,
  `a3` enum('e1','e2','e3','e4','e5','e6','e7','e8') COLLATE utf8_unicode_ci DEFAULT 'e1',
  `a4` int(11) DEFAULT NULL,
  `a5` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a6` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ,
  `a8` int(11) NOT NULL DEFAULT '0',
  `a9` enum('e1','e2','e3','e4','e5','e6','e7','e8','e9','e19','e11','e12') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'e9',
  `a10` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a11` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a12` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `a13` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a14` int(11) DEFAULT NULL,
  `a15` text COLLATE utf8_unicode_ci,
  `a16` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a17` text COLLATE utf8_unicode_ci,
  `a18` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a19` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a20` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a21` int(11) DEFAULT '0',
  `a22` int(11) DEFAULT '0',
  `a23` int(11) DEFAULT '0',
  `a24` int(11) DEFAULT '0',
  `a25` enum('y','n') COLLATE utf8_unicode_ci DEFAULT 'n',
  `a26` enum('e1','e2','e3','e4','e5','e6') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'e1',
  `a27` enum('y','n') COLLATE utf8_unicode_ci DEFAULT 'n',
  `a28` enum('y','n') COLLATE utf8_unicode_ci DEFAULT 'y',
  `a29` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `a16` (`a16`),
  KEY `a12` (`a12`),
  KEY `a8` (`a8`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT IGNORE INTO `t2` (
  `a1`,
  `a2`,
  `a3`,
  `a4`,
  `a5`,
  `a6`,
  `a7`,
  `a8`,
  `a9`,
  `a10`,
  `a11`,
  `a12`,
  `a13`,
  `a14`,
  `a15`,
  `a16`,
  `a17`,
  `a18`,
  `a19`,
  `a20`,
  `a21`,
  `a22`,
  `a23`,
  `a24`,
  `a25`,
  `a26`,
  `a27`,
  `a28`,
  `a29`)
(SELECT 
   `a1`,
  `a2`,
  `a3`,
  `a4`,
  `a5`,
  `a6`,
  `a7`,
  `a8`,
  `a9`,
  `a10`,
  `a11`,
  `a12`,
  `a13`,
  `a14`,
  `a15`,
  `a16`,
  `a17`,
  `a18`,
  `a19`,
  `a20`,
  `a21`,
  `a22`,
  `a23`,
  `a24`,
  `a25`,
  `a26`,
  `a27`,
  `a28`,
  `a29` FROM `t1` WHERE 1 ORDER BY `id` ASC);

-- t1 has arround 2.3 mil transactions 
-- truncate t2 (history)
-- start 2 mysql clients and execute the insert ....
    -- if ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
    -- restart the sql if lock timeout
-- start one mysqldump for both tables (database)  

-- test to see if mysql responds

-- select * from t1 where id=2

-- crash happens

-- the test poll is 2 instances with 2 GB !!!