Re: "out of resources" error in MySQL 6
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.
Subject
Views
Written By
Posted
4113
February 13, 2009 06:07PM
2516
February 14, 2009 12:53AM
2622
February 14, 2009 10:50AM
Re: "out of resources" error in MySQL 6
2831
February 16, 2009 11:54AM
2368
February 16, 2009 04:26PM
2512
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.