Cacti: RRD graphs stop updating and the web interface is slow
![]()
One of my two identical Cacti 0.8.6h appliances stopped updating its RRD graphs, and the web interface became very slow. Both VMs are based on CactiEZ version 1. I had been moving them between VMware hosts when the symptoms appeared.
Rebooting and changing Configuration Settings did not help. Even moving the affected VM back to its original host left me with the same symptoms.
Inspecting the Cacti database files
I logged in over SSH, went to the Cacti database folder and listed its files.
Shell> cd /var/lib/mysql/cacti
Shell> ls -all
-rw-rw---- 1 mysql mysql 303340164 Apr 15 09:32 poller_output.MYD
-rw-rw---- 1 mysql mysql 119115776 Apr 15 09:32 poller_output.MYI
The poller_output.MYD and poller_output.MYI files were very large, and mysqld was using a lot of resources. The two files had a total size of 366 MB, while the virtual machine had only 384 MB of memory assigned.

Clearing the poller output
I read a couple of posts on the Cacti forums and decided to clear the poller_output table from the shell.
Shell> mysqld
mysql>use cacti mysql>
delete from poller_output;
mysql>exit
I also went back to System Utilities and ran Clear Poller Cache.
![]()
Two days later, my Cacti appliance is running smoothly and the poller_output table is small ;-)
-rw-rw---- 1 mysql mysql 28880 Apr 17 18:25 poller_output.MYD
-rw-rw---- 1 mysql mysql 32768 Apr 17 18:25 poller_output.MYI
1 comment
Comments from the original WordPress site, kept read-only.
thanks ;)