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
4254
February 13, 2009 06:07PM
2616
February 14, 2009 12:53AM
2698
February 14, 2009 10:50AM
Re: "out of resources" error in MySQL 6
2902
February 16, 2009 11:54AM
2446
February 16, 2009 04:26PM
2593
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.