MySQL Forums
Forum List  »  Partitioning

Re: Range Partition
Posted by: Sam Mathews
Date: June 18, 2017 01:05AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
156
June 17, 2017 06:09AM
84
June 17, 2017 10:41AM
Re: Range Partition
65
June 18, 2017 01:05AM
74
June 18, 2017 10:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.