MySQL Forums
Forum List  »  Partitioning

partition out of resources
Posted by: Yang HuanWei
Date: August 06, 2007 08:31AM

I got an error message when too many program are running at the same time.

Error Description: Out of resources when opening
file '.\data\cntxt_hist#P#cntxt_hist_p30.MYD' (Errcode: 24)

I didn't get this error before I altered table to 30 partitions, so I wonder
if mysql opened all partition files for each program accessing(SQL query).
The open_file_limit setting of mysql is 500.
Currently, I tried to enlarge the open_file_limit setting to 2000. But it is
not the long-term solution for allowed connection > 100.

Have any solution to solve this error?
or if I know which partition be queried in my SQL, can I limit mysql to open
this specific partition file using SQL statement?

Options: ReplyQuote

Written By
partition out of resources
August 06, 2007 08:31AM
September 12, 2007 11:57AM

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.