partition out of resources
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?
Subject
Views
Written By
Posted
partition out of resources
6042
August 06, 2007 08:31AM
5095
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.