Re: Very slow insert with Innodb

[Rick James]

I assume one of these is a typo:
`ID` bigint(16) unsigned NOT NULL,
PRIMARY KEY (`PurchasedGameTicketID`),

Is it
KEY `Fld1Tbl1` (`Fld1`),
KEY `Fld2Tbl1` (`Fld2`),
KEY `Fld3Tbl1` (`Fld3`)
or is it really
KEY (fld1, fld2, fld3)

Those have different meanings -- in some cases 3 keys is better, in some cases the compound key is better.

For
select * from Tbl1 where Fld1 = ? and Fld2 = ? and Fld6 = ?
The compound key may be better. (It would match on fld1 and fld2.)

How many rows in each INSERT? Possibly it should be limited to a few dozen at a time.