MySQL Forums
Forum List  »  Merge Storage Engine

Advanced Search
New Topic

Re: Help: unable to create 3 tables each having 500 partitions
Posted by: Ingo Strüwing
Date: January 31, 2007 10:14AM

Hi.

While I am neither familiar with the archive storage engine, nor with partitions, it is easy to guess that you need two file descriptors per partition. That means 3000 file descriptors for 3 tables with 500 archive partitions each.

For 2,600 tables of this configuration you would need 2,600,000 file descriptors.

At least if all of them are open at the same time.

You probably could create all these tables if you FLUSH TABLES after each create.

For more information on partitioning, please ask in the Partitioning forum.

Regards
Ingo

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Help: unable to create 3 tables each having 500 partitions
6182
Ijaz Rashid
January 31, 2007 05:56AM
Re: Help: unable to create 3 tables each having 500 partitions
4486
Ingo Strüwing
January 31, 2007 10:14AM


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.