This is a continuation of this thread: http://forums.cpanel.net/f354/server-mysql-crash-328931.html
I'm having the same issue - myql crashes daily taking down sites on one of my cpanels created through WHM (the other cPanel I made in WHM doesn't seem to be crashing).
The .err file in /var/lib/mysql/ gave tons of errors:
I did run the sql to see open files, after following your instructions to increase the limit.
Here is the output of running that sql command (via SSH) to see open files:
I'm having the same issue - myql crashes daily taking down sites on one of my cpanels created through WHM (the other cPanel I made in WHM doesn't seem to be crashing).
The .err file in /var/lib/mysql/ gave tons of errors:
I've been dealing with this for about a week now, ever since installing the cPanel trial on my new dedicated server running CentOS 6.6.[ERROR] /usr/sbin/mysqld: Can't open file: ... (errno: 24)
I did run the sql to see open files, after following your instructions to increase the limit.
Here is the output of running that sql command (via SSH) to see open files:
I'm hoping this solves the issue, but if anyone has more ideas please let me know.+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Open_files | 32 |
+---------------+-------+
+------------------+---------+
| Variable_name | Value |
+------------------+---------+
| open_files_limit | 1022976 |
+------------------+---------+