MySQL Forums
Forum List  »  Partitioning

Help: unable to create 3 tables each having 500 partitions
Posted by: Ijaz Rashid
Date: January 31, 2007 06:10AM

##########
PROBLEM
##########
My requirements are to create 2,600 tables in one DB each having 500 partotions. But I'm unable to create even three (ARCHIVE, MYISAM).

Open_file_limit = 2048 (Maximum for windows OS)
Error is "Out Of Resources when opening file'\dbname\t1#P#p4.MYD'(ErrCode:24); "

Windows 2000 SP 4
MySql 5.1.14-beta-community-nt
##########
EXAMPLE
##########
DROP TABLE IF EXISTS T1;
CREATE TABLE T1 ( ID smallint , Time timestamp NOT NULL) ENGINE=ARCHIVE
PARTITION BY HASH (ID)
PARTITIONS 500;

...

DROP TABLE IF EXISTS T3;
CREATE TABLE T3 ( ID smallint , Time timestamp NOT NULL) ENGINE=ARCHIVE
PARTITION BY HASH (ID)
PARTITIONS 500;


Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Help: unable to create 3 tables each having 500 partitions
2939
January 31, 2007 06:10AM


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.