Re: Range Partition

[Sam Mathews]

CPU xeon e5 2697A dual socket.
RAM 1.5 TB total 64 GB x24 DDR4 2133Mhz.
HDD 8 HDD 8TB each 12 Gbps NLSas 7.2 RPM.
NIC 10Gbps DA/SFP+ QLOGIC.
OS Centos 7 64 bit.
RAID 10 is being used.
CPU is multi-threaded

innodb_buffer_pool_size:224GB


CREATE TABLE test1 (
id int(255) NOT NULL AUTO_INCREMENT,,
fname varchar(255) NOT NULL,
lanme varchar(255) NOT NULL,
doj timestamp NOT NULL default '0000-00-00 00:00:00',
hash varchar(255) NOT NULL,
PRIMARY KEY (ID,doj ),
INDEX IND_fname(fname ),
INDEX IND_lname(lname ),
INDEX IND_hash(hash)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

we are creating .sql file of insert statments of .1million rows in one file.
it is multiple values insert in one insert statement.