MySQL Forums
Forum List  »  Partitioning

key partition
Posted by: jongse park
Date: April 12, 2012 06:28AM

How many partition does mysql have the best performance with key partition?

This is table script

CREATE TABLE key_partition
(
ORD_ID VARCHAR(19) NOT NULL,
DGA_ID VARCHAR(10) NULL,
GDGD_DT DATETIME NULL,
LGKD_ID VARCHAR(24) NULL,
DD_CD VARCHAR(6) NULL,
IEGE VARCHAR(20) NULL,
MCD VARCHAR(10) NULL,
PEI VARCHAR(10) NULL,
USR_ID VARCHAR(10) NOT NULL,
PRIMARY KEY (ORD_ID, USR_ID)
)
PARTITION BY KEY (USR_ID)
PARTITONS 100
;

How about partitions 100 ?

Options: ReplyQuote


Subject
Views
Written By
Posted
key partition
2128
April 12, 2012 06:28AM
1566
April 13, 2012 08:16AM
1480
April 13, 2012 04:12PM


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.