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?
Subject
Views
Written By
Posted
2799
April 15, 2010 08:01PM
Re: problem about partition
1855
April 16, 2010 10:08PM
1827
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.