[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2018-02-15 Thread Launchpad Bug Tracker
This bug was fixed in the package mysql-5.7 - 5.7.21-1ubuntu1 --- mysql-5.7 (5.7.21-1ubuntu1) bionic; urgency=medium * Merge from Debian. * Remaining changes: - Revert "Build with libmecab-dev" since libmecab-dev is in universe. mysql-5.7 (5.7.21-1) unstable;

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2018-02-12 Thread Mario Splivalo
That is better thatn what it is now, but! What is the rationale behind not letting systemd limit the number of open files? The limit exists in MySQL anyways, and for mysql administrator this is just an additional option that needs to be changed. I also imagine most of MySQL admins will set

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2018-01-11 Thread Robie Basak
Is https://salsa.debian.org/rbasak-guest/mysql/merge_requests/3 acceptable to everyone? This sets LimitNOFile to 5000 based on upstream. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1721546 Title:

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2017-10-12 Thread Launchpad Bug Tracker
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: mysql-5.7 (Ubuntu Zesty) Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1721546

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2017-10-12 Thread Launchpad Bug Tracker
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: mysql-5.7 (Ubuntu Xenial) Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1721546

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2017-10-12 Thread Robie Basak
This sounds reasonable to go into Debian as well, thanks. If someone can please propose and test a commit against current Debian VCS, I'll be happy to push it. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu.

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2017-10-12 Thread Nish Aravamudan
Should this be fixed in Debian? Or at least reported there? So that it does not add to the delta? And is the underlying proposed fix to add the Service LimitNOFILE change to the default mysql service file? -- You received this bug notification because you are a member of Ubuntu Bugs, which is

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2017-10-12 Thread Nish Aravamudan
Should this be fixed in Debian? Or at least reported there? So that it does not add to the delta? And is the underlying proposed fix to add the Service LimitNOFILE change to the default mysql service file? -- You received this bug notification because you are a member of Ubuntu Server Team,

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2017-10-12 Thread Mario Splivalo
This can be easily circumvented manually by creating a systemd unit override file for mysql service. One should create a file, named "/etc/systemd/system/mysql.service.d/limits.conf", with this contents (just two lines): [Service] LimitNOFILE=infinity This fix is now implemented in mysql juju

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2017-10-11 Thread Eric Desrochers
** Also affects: mysql-5.7 (Ubuntu Artful) Importance: Undecided Status: Confirmed ** Also affects: mysql-5.7 (Ubuntu Xenial) Importance: Undecided Status: New ** Also affects: mysql-5.7 (Ubuntu Zesty) Importance: Undecided Status: New ** Tags added: sts **

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

2017-10-11 Thread Launchpad Bug Tracker
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: mysql-5.7 (Ubuntu) Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1721546 Title: