mySQL Errcode: 24

The mySQL error: Errcode: 24 is an indication that the number of files that mySQL is allowed to open has been exceeded. MySQL has a variable called open_files_limit which is usually set to 1024 by default.

To increase the open_files_limit variable you need to edit the /etc/my.cnf file and add the lines:

open_files_limit = 2500

Make sure you restart mysql once the my.cnf configuration has been saved. Please note: the variable of 2500 is just an example. We would generally view the current number of files and add 1000 to come up with a a safe variable for open_files_limit.

The open_files_limit directly affects how much server memory is used, so please be conservative when setting this variable.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

cPanel Server Time

Setting the server timezone in cPanel is very easy. Having the correct server time helps when...

Dovecot Is Not Running on cPanel

Quite a common error with Dovecot running on Xen hypervisors, especially for clients who use...

CentOS Change Hostname

One of the most common changes to CentOS servers is modifying the hostname. Hostnames are...

Swap Disk Size

What is swap? Swap space is the area on a hard disk which is part of the Virtual Memory of your...

Log Slow MySQL Queries

MySQL can often use excessive CPU cores or time out unexpectedly. The slow-query-log can assist...