A good move is to put mysql db and rrd files on different file systems/drives. action=view_tech I can see that the run time is very long; Last Run Statistics Time:388.4284 Method:spine...... Watching the 5 minute polls running on the CLI via htop and top, I can see that my spine processes start up, the CPU on the server shoots up to 100% for about 30 seconds, then all the spine processes exit, and the server drops to %1~ usage and all is quiet.
Some agent's don't have the horsepower to deliver that many OID's at a time.
Documentation When you need help installing or using Cacti, be sure to check these resources first.
Cacti Manual [html | pdf | text] Contains basic information such as installing and using Cacti as well advanced features such as Data Queries and 95th percentile.
Therefore, we can reduce the number for those older/underpowered devices.
For snmp, snmpget the _exact_ OID you're asking for, using same community string and snmp version as defined within cacti.