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
4172
February 13, 2009 06:07PM
2567
February 14, 2009 12:53AM
2654
February 14, 2009 10:50AM
Re: "out of resources" error in MySQL 6
2854
February 16, 2009 11:54AM
2389
February 16, 2009 04:26PM
2541
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.