Re: large number of insert with autocommit set to off
CREATE TABLE `SALES` (
`PROD_ID` int(11) NOT NULL,
`CUST_ID` int(11) NOT NULL,
`TIME_ID` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`CHANNEL_ID` int(11) NOT NULL,
`PROMO_ID` int(11) NOT NULL,
`QUANTITY_SOLD` float NOT NULL,
`AMOUNT_SOLD` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (UNIX_TIMESTAMP(TIME_ID))
(PARTITION SALES_1995 VALUES LESS THAN (820450800) ENGINE = InnoDB,
PARTITION SALES_1996 VALUES LESS THAN (852073200) ENGINE = InnoDB,
PARTITION SALES_H1_1997 VALUES LESS THAN (867708000) ENGINE = InnoDB,
PARTITION SALES_H2_1997 VALUES LESS THAN (883609200) ENGINE = InnoDB,
PARTITION SALES_Q1_1998 VALUES LESS THAN (891381600) ENGINE = InnoDB,
PARTITION SALES_Q2_1998 VALUES LESS THAN (899244000) ENGINE = InnoDB,
PARTITION SALES_Q3_1998 VALUES LESS THAN (907192800) ENGINE = InnoDB,
PARTITION SALES_Q4_1998 VALUES LESS THAN (915145200) ENGINE = InnoDB,
PARTITION SALES_Q1_1999 VALUES LESS THAN (922917600) ENGINE = InnoDB,
PARTITION SALES_Q2_1999 VALUES LESS THAN (930780000) ENGINE = InnoDB,
PARTITION SALES_Q3_1999 VALUES LESS THAN (938728800) ENGINE = InnoDB,
PARTITION SALES_Q4_1999 VALUES LESS THAN (946681200) ENGINE = InnoDB,
PARTITION SALES_Q1_2000 VALUES LESS THAN (954540000) ENGINE = InnoDB,
PARTITION SALES_Q2_2000 VALUES LESS THAN (962402400) ENGINE = InnoDB,
PARTITION SALES_Q3_2000 VALUES LESS THAN (970351200) ENGINE = InnoDB,
PARTITION SALES_Q4_2000 VALUES LESS THAN (978303600) ENGINE = InnoDB,
PARTITION SALES_Q1_2001 VALUES LESS THAN (986076000) ENGINE = InnoDB,
PARTITION SALES_Q2_2001 VALUES LESS THAN (993938400) ENGINE = InnoDB,
PARTITION SALES_Q3_2001 VALUES LESS THAN (1001887200) ENGINE = InnoDB,
PARTITION SALES_Q4_2001 VALUES LESS THAN (1009839600) ENGINE = InnoDB,
PARTITION SALES_Q1_2002 VALUES LESS THAN (1017612000) ENGINE = InnoDB,
PARTITION SALES_Q2_2002 VALUES LESS THAN (1025474400) ENGINE = InnoDB,
PARTITION SALES_Q3_2002 VALUES LESS THAN (1033423200) ENGINE = InnoDB,
PARTITION SALES_Q4_2002 VALUES LESS THAN (1041375600) ENGINE = InnoDB,
PARTITION SALES_Q1_2003 VALUES LESS THAN (1049148000) ENGINE = InnoDB,
PARTITION SALES_Q2_2003 VALUES LESS THAN (1057010400) ENGINE = InnoDB,
PARTITION SALES_Q3_2003 VALUES LESS THAN (1064959200) ENGINE = InnoDB,
PARTITION SALES_Q4_2003 VALUES LESS THAN (1072911600) ENGINE = InnoDB)