The process list on MySQL have about 10 idle connections by the cacti user. And one is more or less constantly running the query:
SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00' (followed by 2-3 other queries, all seem to return zero results) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: Cacti causes high CPU load via MySQL after upgrade to Ubuntu 16.04 To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
