Cacti

  1. Bug #1578144
  2. Comment #9

Comment 9 for bug 1578144

Revision history for this message
Graham Inggs (ginggs) wrote : Re: Cacti causes high CPU load via MySQL after upgrade to Ubuntu 16.04

I've just installed 16.04 server in a VM, updated, then installed mysql-server mysql-client.
I ran the command request by Paul as the root user. I also cleaned up the output.

@@global.sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

@@session.sql_mode =
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

@@sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION