MySQL Forums
Forum List  »  Newbie

Re: MySQL goes off periodically
Posted by: Payam Arzani
Date: July 12, 2017 01:31PM

I have still a little question about file descriptors. I have had more than 1024 tables in mysql, and I think this caused the file descriptors error. Apparently, the mysql process opens all the tables at once, so for that process there would be more than 1024 file descriptors. I have deleted about 200 old tables in order to come below 1024. I hope this solves the problem for the moment. But as my customers increase in number, that number of tables will again exceed 1024. My question is this:

Even in MySQL 8, if there are more than 1024 tables in MySQL, will that not cause the same file descriptors exceeded error? because the FD_SETSIZE will still remain 1024 for macOS, and in MySQL 8 the process will open more than 1024 files. So the same error must needs occur again.

Thank you for a reply.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL goes off periodically
July 12, 2017 01:31PM


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.