[Bug 1434758] Re: mysqld: errno: 24 - Too many open files

[postadelmaga]

I'm a developer and I have 3/5 db on my machine, each one with many
table ( 100+ ) however the main point is that using upstart I don't have
issues, ideally the systemd behavior should be the same ...

On my machine, I'm on 15.04, /lib/systemd/system/mysqld.service is missing, which package provide it ? 
- I have searched the file with apt-file and dpkg -l (mysql-server-5.6 and mysql-sever-core-5.6) but there is no track of it.

I have manually created that file with the following content, but I
still have the issue:

[Service]
LimitNOFILE=infinity
LimitMEMLOCK=infinity

It will be great if you can share the content of your `mysqld.service` so I can add it manually.
Does I need to link this file some where ?

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.6 in Ubuntu.
https://bugs.launchpad.net/bugs/1434758

Title:
  mysqld: errno: 24 - Too many open files

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1434758/+subscriptions