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 charm: https://github.com/marcoceppi/charm-mysql/issues/20 ** Bug watch added: github.com/marcoceppi/charm-mysql/issues #20 https://github.com/marcoceppi/charm-mysql/issues/20 -- 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: max open files limit prevents max_connections over 214 on systemd To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs