Solution to many request for one host.

[kanada]

Hello,

for many monitored hosts, 1000/5000/10000 cacti generate many sql inserts/inputs into the base.
This look like that:
request - get info - put to base.
I think that beter will be, if cacti will request all hosts, and insert one time into base, like this:
request - get info
request - get info
request - get info
.......... - .......
and then put all into base. I think that minimalize all time reservered to request.

Greetz,

Alexander

[rony]

Mysql buffer size will not allow that and the concurrent updating of rrdtool files would not be able to occur.

[TheWitness]

Alter your poller_output table as follows:

shell$> mysql -u root -p cacti
> ALTER TABLE `poller_output` MODIFY COLUMN `output` VARCHAR(255) NOT NULL DEFAULT '', ENGINE = MEMORY;
> quit

This will reduce load significantly while polling. If you are running MySQL 5.0.3 or above, make the column VARCHAR(512).

Regards,

TheWitness