MySQL Forums
Forum List  »  Merge Storage Engine

Re: what's the limit on number of tables in MERGE table?
Posted by: Ingo Strüwing
Date: November 10, 2005 05:17AM

I might have overlooked some important information from your posting. Because I stopped reading when I saw:

./foo/bar_99.MYD' not found (Errcode: 24)

I issued the command "perror 24" and got:
System error: 24 = Too many open files

This means that you ran into the file limit. Use the shell command "ulimit -n" to see what your limit is. The default is usually 1024. Since every open MyISAM table takes two file descriptors, a limit around 500 as you saw it, is explainable.

Please try to add
* hard nofile 4096
to /etc/security/limits.conf, log out and in, and issue the command
ulimit -n 4096
before starting mysqld.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: what's the limit on number of tables in MERGE table?
4826
November 10, 2005 05:17AM


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.