MySQL Forums
Forum List  »  Partitioning

Re: partition out of resources
Posted by: Mikael Ronström
Date: September 12, 2007 11:57AM

Hi,
Yes, all partition files are opened.
The issue is something we'll address in a future version.
Also not all storage engines opens files as part of the
open call so the behavior is dependent on the storage engine.

Rgrds Mikael

Yang HuanWei Wrote:
-------------------------------------------------------
> 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


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