Moodle crashing with "Too many open files"

Moodle crashing with "Too many open files"

by Debbie Unterseher -
Number of replies: 2

Moodle 3.5.3 and within the last week it has crashed twice.

Here is information I got from IT:

Mysql version 8 getting the error "Error in accept: Too many open files"

Moodle and Moodlet are the only two systems on the mysql database.

The open_files_limit is already at 10,000.

Any ideas?

Average of ratings: -
In reply to Debbie Unterseher

Re: Moodle crashing with "Too many open files"

by Ken Task -
Picture of Particularly helpful Moodlers

You didn't say what OS ... so ...

http://blogs.reliablepenguin.com/2015/08/28/mariadb-on-centos-7-error-in-accept-too-many-open-files

Above on CentOS 7 and MariaDB, but think MySQL might be the same.  And I assume that's the same thing one would do in a Ubuntu LSB ... like 18.x.

If Windows ... sorry ... don't do those anymore! smile

'spirit of sharing', Ken


Average of ratings: Useful (1)
In reply to Ken Task

Re: Moodle crashing with "Too many open files"

by Debbie Unterseher -
Thanks Ken.  We ran the mysqltuner, which was recommended to do in the performance page, and made some changes to the wait_time.  Hopefully that will fix it!  Always appreciate your input.
Average of ratings: -