Hello,
I am struggling with a prevalent error in MySQL 5.7.25 for Mac OS X 10.14.6 in high-traffic environment. It has been documented online and noted as a bug in MySQL 5.7 here:
https://bugs.mysql.com/bug.php?id=79125
I have already increased my shell maxfiles size to 64000 524288 but as I understand this does not matter.
CNF Config:
table_open_cache = 500
max_connections = 300
interactive_timeout = 300
wait_timeout = 300
The error begins to backlog in MySQL error log for a few hours before MySQL dies and I need to force-quit and restart it.
At this point, I cannot update MySQL because of my Solution Stack (MAMP) requirements.
2019-01-22T09:56:18.753656-06:00 0 [Warning] File Descriptor 1028 exceeded FD_SETSIZE=1024
2019-01-22T09:56:18.762894-06:00 0 [Warning] File Descriptor 1028 exceeded FD_SETSIZE=1024
2019-01-22T21:16:23.931825-06:00 0 [Warning] File Descriptor 1033 exceeded FD_SETSIZE=1024
2019-01-22T21:16:23.942062-06:00 0 [Warning] File Descriptor 1033 exceeded FD_SETSIZE=1024
2019-01-23T02:40:46.794219-06:00 0 [Warning] File Descriptor 1030 exceeded FD_SETSIZE=1024
2019-01-23T02:40:46.802768-06:00 0 [Warning] File Descriptor 1030 exceeded FD_SETSIZE=1024
2019-01-23T07:32:28.304186-06:00 0 [Warning] File Descriptor 1030 exceeded FD_SETSIZE=1024
2019-01-23T07:32:28.313331-06:00 0 [Warning] File Descriptor 1040 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.291382-06:00 0 [Warning] File Descriptor 1032 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.302778-06:00 0 [Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.303748-06:00 0 [Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.304614-06:00 0 [Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
Also:
https://mampsupportforum.com/forums/latest/warning-file-descriptor-1032-exceeded-fd-setsize-1024