MySQL Forums
Forum List  »  Partitioning

Re: problem about partition
Posted by: Rick James
Date: April 16, 2010 10:08PM

Yes, PARTITION leads to lots of file handles. And they are usually all opened whenever you touch the Partition table.

table_open_cache should be high -- thousands is usually reasonable. However, it is limited by what the OS will let mysql have. If this is "too low", then you will be opening and closing tables much too often.

How big is the table you are partitioning? If it is under a gigabyte, it may not be worth partitioning at all. Care to SHOW CREATE TABLE so we can critique it?

Options: ReplyQuote

Written By
April 15, 2010 08:01PM
Re: problem about partition
April 16, 2010 10:08PM
April 18, 2010 08:16PM

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.