[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: mysql strangeness...
From:       "wagnerbianchi.com" <me () wagnerbianchi ! com>
Date:       2014-12-08 14:11:52
Message-ID: CADtYh6Hmh9HZA4AzjFygGrLxThaUUAf+JpCHWeXWYOq1wfXv3Q () mail ! gmail ! com
[Download RAW message or body]


Very good share Reindl.



--
*Wagner Bianchi, MySQL Database Specialist*
Mobile:  +55.31.8654.9510
E-mail:  me@wagnerbianchi.com
Twitter: @wagnerbianchijr

2014-12-08 12:05 GMT-02:00 Reindl Harald <h.reindl@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
>
>
>


[prev in list] [next in list] [prev in thread] [next in thread]