Public bug reported:
Ubuntu 16.04 LTS
Cacti 0.8.8f which is the default version for Ubuntu 16.04 uses invalid
datetime values ("0000-00-00 00:00:00"). MySQL 5.7 does not support
zero-dates, this causes the Cacti poller script to run amok and execute
the same SQL queries over and over. In my case this ends up with MySQL
consuming about 35% CPU and php (via the poller) about 15% CPU.
This probably goes for clean installs as well (as Cacti has this invalid
datetime in a number of the php-files supplied by the Cacti package)
** Affects: cacti (Ubuntu)
Importance: Undecided
Status: New
--
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/ubuntu/+source/cacti/+bug/1578144/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
