1. mampsupportmod
  2. MAMP - Troubleshooting
  3. Thursday, 24 January 2019

Saw a bunch of these errors in mysql_error.log and then MySQL died. I saw it's potentially a bug in 5.7 here and it's fixed in version 8.

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:

interactive_timeout = 300
wait_timeout = 300

 

 

Anyone have experience with this?

 

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

 





There are no replies made for this post yet.
Be one of the first to reply to this post!