Very good share Reindl.
-- *Wagner Bianchi, MySQL Database Specialist* Mobile: +55.31.8654.9510 E-mail: m...@wagnerbianchi.com Twitter: @wagnerbianchijr 2014-12-08 12:05 GMT-02:00 Reindl Harald <h.rei...@thelounge.net>: > > 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 > > >
