MySQL Forums
Forum List  »  Partitioning

Re: "out of resources" error in MySQL 6
Posted by: Mattias Jonsson
Date: February 16, 2009 11:54AM

How does your table look like?

If they are heavily partitioned and using myisam or innodb with --innodb_file_per_table, then the number of file descriptors (handlers) will be very high. On unix you can probably allow a higher value by `ulimit -n 8196` or higher, or increase the --open_files_limit.

For MyISAM the number of file descriptors for a partitioned table is 2 x partitions, i.e. one .MYI and one .MYD file per partition.

Options: ReplyQuote


Subject
Views
Written By
Posted
4193
February 13, 2009 06:07PM
2581
February 14, 2009 12:53AM
2667
February 14, 2009 10:50AM
Re: "out of resources" error in MySQL 6
2868
February 16, 2009 11:54AM
2411
February 16, 2009 04:26PM
2556
February 18, 2009 09:08PM


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.