[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
** Also affects: akonadi via http://bugs.mysql.com/bug.php?id=80772 Importance: Unknown Status: Unknown ** Changed in: akonadi Importance: Unknown => Undecided ** Changed in: akonadi Status: Unknown => New ** Changed in: akonadi Remote watch: MySQL Bug System #80772 => None -- You received this bug notification because you are a member of Kubuntu Bugs, which is subscribed to akonadi in Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Ubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/akonadi/+bug/1576930/+subscriptions -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
Seems to be fixed for me with mysql 5.7.13 from yakkety. RAM consumtion dropped from ~900 to ~200 MB. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
Workaround on comment #10 seemed to work for me, but after some time memory consumption started to grow up to 957MB -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
** Changed in: mysql-5.7 (Ubuntu) Status: Confirmed => Triaged -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
The problem is observed on the mysql-5.7 ** Changed in: mysql-5.7 (Ubuntu) Status: Triaged => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
Mysql version 5.7.12-0ubuntu1.1 from ubuntu proposed repo does not fix this bug. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
Is there any progress on this bug? I'm burning my SSD drive because of memory swapping... -- You received this bug notification because you are a member of Kubuntu Bugs, which is subscribed to akonadi in Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
Unfortunately it actually does not seem to solve the problem. Memory usage is already up to more than 500 MB. Sorry for not testing long enough obviously. -- You received this bug notification because you are a member of Kubuntu Bugs, which is subscribed to akonadi in Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
Thank you for confirming, this is useful. We'll wait for a fix from MySQL upstream, then. -- You received this bug notification because you are a member of Kubuntu Bugs, which is subscribed to akonadi in Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
The workaround in comment #10 seems to work for me. Memory usage is now at around 200 MB. Conf file is: ~/.local/share/akonadi/mysql.conf -> add under [mysqld] -- You received this bug notification because you are a member of Kubuntu Bugs, which is subscribed to akonadi in Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
** Description changed: [Status] - Suspected cause is triaged upstream in MySQL; waiting fix. + Suspected cause is triaged upstream in MySQL; awaiting fix. [Workaround] Proposed in comment 10; please report success or failure. [Original Description] In the last days using Kubuntu 16.04 I've noticed that after a while of use, RAM consumption of mysqld daemon rises above 800 MB, even surpassing Firefox, as you can see in the attached images. Initially, when system is just booted, RAM consumption of mysqld daemon it remains approximately 135-140 MB, but I have seen how after a while, in a matter of a few minutes, without touching anything, consumption rises progressively to around 830 MB. In the second image you can see that mysqld daemon is related to Akonadi, which at the same time has a lot of threads running. It is possible that the problem is in managing Akonadi processes, but it is clear that consumption of mysqld daemon is not normal, and that there must be a problem, either MySQL or Akonadi, causing this situation. I tried replacing MySQL with MariaDB, but will not let me uninstall MySQL components without also uninstall a lot of applications as dependencies (like Akonadi, Amarok, Kontact, KAdressBook ...). What I can do, even as an interim solution? Here are the attached screenshots: https://www.sendspace.com/file/712oyk https://www.sendspace.com/file/qcqeem -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
So the workaround suggested upstream is to add: innodb-read-io-threads=1 innodb-write-io-threads=1 to ~/.local/share/akonadi/mysql.cnf Can someone please confirm if this is accurate and if it works? We'll need to wait for a fix from upstream, but in the meantime hopefully the workaround will work for those affected. ** Description changed: + [Status] + + Suspected cause is triaged upstream in MySQL; waiting fix. + + [Workaround] + + Proposed in comment 10; please report success or failure. + + [Original Description] + In the last days using Kubuntu 16.04 I've noticed that after a while of use, RAM consumption of mysqld daemon rises above 800 MB, even surpassing Firefox, as you can see in the attached images. Initially, when system is just booted, RAM consumption of mysqld daemon it remains approximately 135-140 MB, but I have seen how after a while, in a matter of a few minutes, without touching anything, consumption rises progressively to around 830 MB. In the second image you can see that mysqld daemon is related to Akonadi, which at the same time has a lot of threads running. It is possible that the problem is in managing Akonadi processes, but it is clear that consumption of mysqld daemon is not normal, and that there must be a problem, either MySQL or Akonadi, causing this situation. I tried replacing MySQL with MariaDB, but will not let me uninstall MySQL components without also uninstall a lot of applications as dependencies (like Akonadi, Amarok, Kontact, KAdressBook ...). What I can do, even as an interim solution? - Here are the attached screenshots: https://www.sendspace.com/file/712oyk https://www.sendspace.com/file/qcqeem ** Changed in: mysql-5.7 (Ubuntu) Status: New => Triaged ** Changed in: mysql-5.7 (Ubuntu) Importance: Undecided => High -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
If this is the upstream MySQL bug that Norvald mentioned, then the fix would be in mysql-5.7, so adding a task for that. We can mark one of the tasks as Invalid when we figure out which is right. ** Also affects: mysql-5.7 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Kubuntu Bugs, which is subscribed to akonadi in Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
> I'm not sure about akonadi. It can't. I meant we support it packaging wise as some people prefer to use another MySQL backend. But once you do that you're on your own. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
On Mon, May 02, 2016 at 12:52:44PM -, Philip Muškovac wrote: > Regarding switching to MariaDB, that is supported, but you need to > replace mysql with mariadb in one go: > > # apt-get install mariadb-client-core-10.0 mariadb-server-core-10.0 Note that migrating your data back to MySQL is generally not possible, so back up your data first. MySQL/MariaDB packaging cannot currently do it anyway. I'm not sure about akonadi. -- You received this bug notification because you are a member of Kubuntu Bugs, which is subscribed to akonadi in Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
Regarding switching to MariaDB, that is supported, but you need to replace mysql with mariadb in one go: # apt-get install mariadb-client-core-10.0 mariadb-server-core-10.0 should give you: The following packages will be REMOVED: mysql-client-core-5.7 mysql-server-core-5.7 The following NEW packages will be installed: libreadline5 mariadb-client-core-10.0 mariadb-common mariadb-server-core-10.0 ** Changed in: akonadi (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/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
It might be this bug: http://bugs.mysql.com/bug.php?id=80772 Can try the workaround mentioned in the bug report? ** Bug watch added: MySQL Bug System #80772 http://bugs.mysql.com/bug.php?id=80772 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
Same problem for me, not with akonadi, simply by installing mysql. mysqld uses approximately 130Mb at startup and goes up to 806 Mb adter 10 minutes, without any server process running. Any workaround yet ? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
I must add that I use Ubuntu 16.04 too. (not Kubuntu) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
akonadi package configures its own mysqld, so any configuration changes for akonadi users need to be made in akonadi packaging and not mysql packaging. akonadi packagers/Kubuntu team: I'm happy to help with this, let me know. It probably makes more sense for someone familiar with Kubuntu and/or akonadi to figure out what is needed on that side, though? ** Package changed: mysql-5.7 (Ubuntu) => akonadi (Ubuntu) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
Ubuntu 16.04 does not have MySQL 5.5, it has 5.7. The most likely explanation for the memory usage going up is that default buffer sizes have been increased significantly for mysqld over the last few releases. You may need to edit config files to reduce the buffers. ** Package changed: mysql-5.5 (Ubuntu) => mysql-5.7 (Ubuntu) ** Changed in: mysql-5.7 (Ubuntu) Importance: Undecided => High ** Tags added: xenial -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.7 in Ubuntu. Matching subscriptions: main https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1576930/+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 1576930] Re: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04
Ubuntu 16.04 does not have MySQL 5.5, it has 5.7. The most likely explanation for the memory usage going up is that default buffer sizes have been increased significantly for mysqld over the last few releases. You may need to edit config files to reduce the buffers. ** Package changed: mysql-5.5 (Ubuntu) => mysql-5.7 (Ubuntu) ** Changed in: mysql-5.7 (Ubuntu) Importance: Undecided => High ** Tags added: xenial -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1576930 Title: Excessive consumption RAM of mysqld daemon in Kubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1576930/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs