MySQL Forums
Forum List  »  Partitioning

Re: Partitioned table causes open_files errror
Posted by: Phil Hildebrand
Date: June 10, 2008 10:13PM

Looks like this may be by design:

http://dev.mysql.com/doc/refman/5.1/en/table-cache.html

"...With MyISAM tables, one extra file descriptor is required for the data file for each client that has the table open. (By contrast, the index file descriptor is shared between all threads.) ..."

So, then the answer would be to increase the linux level max open files (nofiles) for mysql, as well as the mysql open_files_limit if necessary. Limiting connections have a similar effect, but increasing the limits is probably the better option (overhead for open files should not be that much of an issue).

So, (tables + total partitions) * (max concurrent connections expected)...?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partitioned table causes open_files errror
3117
June 10, 2008 10:13PM


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.