Am 08.12.2014 um 14:56 schrieb Chris Knipe:
They have been dealt with. mySQL has 4096 file descriptors available. Through all of this, not one single error is logged to the errorlog either.limits.conf: mysql soft nofile 4096 mysql hard nofile 4096
that won't work well depending on the number of threads and tables the first below is a webserver with some thousand MyISAM tables the second a dbmail-server with just a view InnoDB tables (dbmail)and depedning how mysqld is started "limits.conf" often is not relevant at all, in the past with sysvinit i remember to have placed "ulimit" calls into the init-script, systemd has much better options
http://duntuk.com/how-raise-ulimit-open-files-and-mysql-openfileslimit [root@localhost:~]$ lsof | grep mysqld | grep -v DEL | wc -l 798365 [root@mail:~]$ lsof | grep mysqld | grep -v DEL | wc -l 19662
signature.asc
Description: OpenPGP digital signature