Hey postadelmaga: the file is in /lib/systemd/system/mysqld.service in debian and ubuntu. Those services are shipped in the mysql package, so closing the systemd tag (adding the tag though).
I looked at mysql upstream, and their service files doesn't let the limit of files to opened up. Do you have a particular use case with a very large database? I really vary on the idea we disable the limit checks on mysql. Also, did you look at other distros, did they change the limit as well as distro-patch (it doesn't seem for me)? Maybe you can try opening an upstream bug to engage the discussion? ** No longer affects: systemd (Ubuntu) -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1434758 Title: mysqld: errno: 24 - Too many open files Status in mysql-5.6 package in Ubuntu: New Bug description: After upgrading to 15.04 mysql cannot set the file limit and so it doesn't work well. /var/log/mysql/error.log shows the following: [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000) [ERROR] /usr/sbin/mysqld: Can't open file: ... (errno: 24 - Too many open files) The issue looks to be related to the recent switch to systemd indeed if I start using upstart everything work fine. I found out similar issues reported on Debian and the general suggestion is to add following line to the `mysqld.service` anyway this file is not present on my installation : LimitNOFILE=infinity LimitMEMLOCK=infinity Other distro stores this file in `/usr/lib/systemd/system/mysqld.service` I'm not sure how Ubuntu is managing this, maybe with file in dir /etc/default/ ? I have also tried adding following lines in /etc/security/limits.conf, but the problem persist: mysql soft nofile 65535 mysql hard nofile 65535 ProblemType: Bug DistroRelease: Ubuntu 15.04 Package: mysql-server (not installed) Uname: Linux 3.19.2-031902-generic x86_64 ApportVersion: 2.16.2-0ubuntu4 Architecture: amd64 CurrentDesktop: Unity Date: Sat Mar 21 10:17:00 2015 InstallationDate: Installed on 2014-03-10 (375 days ago) InstallationMedia: Ubuntu 14.04 LTS "Trusty Tahr" - Alpha amd64 (20140309) SourcePackage: mysql-5.5 UpgradeStatus: Upgraded to vivid on 2015-03-20 (0 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1434758/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp
