cant increase open files limit

[anthonysomerset]

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?

[gplessis]

Please see some comments here : http://www.dotdeb.org/2014/04/02/mysql-5-6-17-for-wheezy/#comment-29419

[gplessis]

@anthonysomerset : did manage to fix your issue by editing /etc/security/limits.conf ?

[ewasser]

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.

[mpingu]

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.