I also saw some posts that Mac OS X has too many open files and you may need to raise the file descriptor limits here and here and a restart is required. Not sure how safe this is though.
Another solution is to set the MySQL interactive and wait timeout's to a lower value (versus default of 8 hours) so they release descriptors more quickly. The settings below are both for 5 minutes, but you might want to tighten that a bit more if you are running a production environment.
My.CNF:
Code: Select all
interactive_timeout = 300
wait_timeout = 300
Mac OS X 10.14.2
MAMP Pro 5.2
MySQL 5.7.23
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
2019-01-23T12:03:54.305484-06:00 0 [Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.306341-06:00 0 [Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.307217-06:00 0 [Warning] File Descriptor 1037 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.310512-06:00 0 [Warning] File Descriptor 1037 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.311865-06:00 0 [Warning] File Descriptor 1037 exceeded FD_SETSIZE=1024
2019-01-23T12:03:55.075392-06:00 0 [Warning] File Descriptor 1038 exceeded FD_SETSIZE=1024
2019-01-23T12:03:55.084937-06:00 0 [Warning] File Descriptor 1039 exceeded FD_SETSIZE=1024
2019-01-23T14:46:43.370416-06:00 0 [Warning] File Descriptor 1031 exceeded FD_SETSIZE=1024
2019-01-23T14:46:43.380674-06:00 0 [Warning] File Descriptor 1031 exceeded FD_SETSIZE=1024
2019-01-23T15:17:32.993687-06:00 0 [Warning] File Descriptor 1029 exceeded FD_SETSIZE=1024
2019-01-23T15:17:33.003711-06:00 0 [Warning] File Descriptor 1029 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.168848-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.178195-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.258724-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.269156-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.413230-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.422540-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:42.388568-06:00 0 [Warning] File Descriptor 1032 exceeded FD_SETSIZE=1024
2019-01-23T22:52:42.397778-06:00 0 [Warning] File Descriptor 1032 exceeded FD_SETSIZE=1024