cant increase open files limit
Opened this issue · 4 comments
out of the box after an upgrade from debian stock mysql 5.5 to dotdeb 5.6 gives me the following error in daemon.log
Buffered warning: Could not increase number of max_open_files
i tried setting my /etc/security/limits.conf but to no avail
any ideas?
Please see some comments here : http://www.dotdeb.org/2014/04/02/mysql-5-6-17-for-wheezy/#comment-29419
@anthonysomerset : did manage to fix your issue by editing /etc/security/limits.conf ?
Why was the calling of /usr/bin/mysqld_safe changed?
- /usr/bin/mysqld_safe > /dev/null 2>&1 &
+ su - mysql -s /bin/sh -c "/usr/bin/mysqld_safe > /dev/null 2>&1 &"
Is there are a reason for this? This is the reason why the settings from my.cnf can't be used. The ulimit in mysqld_safe will be only executed if the current user is root.
Will this be fixed to the old behaviour? Otherwise thousands of installations have to change their /etc/security/limits.conf and /etc/pam.d/su because the later file don't use "pam_limits.so". It's out commented.
Is there an Update to this Issue? Since its open from April 2014 now.
I have looked into the MySQL Init File from Debian and from MariaDB. Both dont start the mysqld_safe process as mysql user, they start it as root.