[Bug 1839527] Re: mysqld eats more than 16 GB of memory on startup
** Tags removed: server-triage-discuss -- You received this bug notification because you are a member of Ubuntu Server, which is subscribed to mysql-5.7 in Ubuntu. Matching subscriptions: main https://bugs.launchpad.net/bugs/1839527 Title: mysqld eats more than 16 GB of memory on startup To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1839527/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1839527] Re: mysqld eats more than 16 GB of memory on startup
Upstream bug was verified by them. -- You received this bug notification because you are a member of Ubuntu Server, which is subscribed to mysql-5.7 in Ubuntu. Matching subscriptions: main https://bugs.launchpad.net/bugs/1839527 Title: mysqld eats more than 16 GB of memory on startup To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1839527/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1839527] Re: mysqld eats more than 16 GB of memory on startup
Still, something is happening in ubuntu where we still get the conservative 1024*1024 value, and we do have systemd 240 in eoan. I removed the 5000 setting from the mysql service file, issued daemon- reload, and I still get 1024*1024. In any case, by forcing a larger limit, I was able to reproduce the issue. UPDATE: ah, there is a change in the debian/ubuntu packaging: systemd (240-2) unstable; urgency=medium ... * Don't bump fs.nr_open in PID 1. In v240, systemd bumped fs.nr_open in PID 1 to the highest possible value. Processes that are spawned directly by systemd, will have RLIMIT_NOFILE be set to 512K (hard). ... -- You received this bug notification because you are a member of Ubuntu Server, which is subscribed to mysql-5.7 in Ubuntu. Matching subscriptions: main https://bugs.launchpad.net/bugs/1839527 Title: mysqld eats more than 16 GB of memory on startup To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1839527/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1839527] Re: mysqld eats more than 16 GB of memory on startup
I filed this bug upstream: https://bugs.mysql.com/bug.php?id=96525 ** Bug watch added: MySQL Bug System #96525 http://bugs.mysql.com/bug.php?id=96525 ** Also affects: mysql-server via http://bugs.mysql.com/bug.php?id=96525 Importance: Unknown Status: Unknown -- You received this bug notification because you are a member of Ubuntu Server, which is subscribed to mysql-5.7 in Ubuntu. Matching subscriptions: main https://bugs.launchpad.net/bugs/1839527 Title: mysqld eats more than 16 GB of memory on startup To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1839527/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1839527] Re: mysqld eats more than 16 GB of memory on startup
Since the LimitNOFILE=5000 isn't applied, the process gets whatever default the host has. In this case, Arch's kernel, since this is an LXC container. Aug 08 18:19:23 mysql57 bash[13131]: open files (-n) 1073741816 <--- see this? You probably have the same value on the host. I've seen another bug recently that involved arch linux and high limits: https://github.com /kubernetes-sigs/kind/pull/760 There it is claimed that Arch's default is 1073741816, which matches your number above. A bug was filed against mariadb, which has the same behavior you described with mysql here: https://jira.mariadb.org/browse/MDEV-18360 The same code is in mysql 5.7 All that being said, this works fine when the host is Ubuntu, because the limits are set to lower values there by default. One could still argue that mysql is running on Ubuntu, just with an "odd" non-ubuntu kernel, and that it shouldn't allocate memory like that. ** Tags added: server-triage-discuss -- You received this bug notification because you are a member of Ubuntu Server, which is subscribed to mysql-5.7 in Ubuntu. Matching subscriptions: main https://bugs.launchpad.net/bugs/1839527 Title: mysqld eats more than 16 GB of memory on startup To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1839527/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs