how can config thold to faster my system?

[looc]

i used cacti 0.8.7& thold 0.3.8,now i have 142 hosts.each host has 6-10 tholds. used thold run time about 77sec.and disabled thold run time about 33 sec that in the same poller config.
I saw the process, the process of the need to thold calculation, but also for mysql operation. What can raise such an effect. Because, I also need plus 300-400 hosts ?

[rezouss]

I have the same problem under Linux.

Fedora Core 3
PHP 5.1.2
Mysql 5.1.5

Cacti 0.8.7
Cactid 0.8.6.i
architecture 1.3
settings 0.3
thold 0.3.8
weathermap 0.94
links 0.3

550 hosts
12.500 data sources

=> Polling with thold : 230 sec. (over 300 during backup of rra files)
=> Polling without thold : 70 sec.


I don't have the problem with thold 0.3.4 (i have others...).

Do you have any idea ?

Thanks.

[rezouss]

After a little work, i upgraded to:

Cacti 0.8.7 ==> Cacti 0.8.7a
Cactid 0.8.6.i ==> Spine 0.8.7a
architecture 1.3 ==> architecture 1.4
settings 0.3
thold 0.3.8
weathermap 0.94
links 0.3

It's better:
=> Polling without thold : 60 sec.
=> Polling with thold : 160 sec.

See you.

[savagemindz]

Try this against your DB.

Code: Select all

ALTER TABLE `graph_templates_item` ADD INDEX ( `task_item_id` );

This dropped running with thold from 290 secs to 24 secs for me.

iain

[lostpckt]

I'd love to tune my system to run faster (~30s for ~18k RRD's), but I'm skeptical of running things against the DB that I'm not familiar with (I'm just not familiar with mysql in general).

What does the line you posted do, or rather, how does it speed things up?

Sorry for the n00b question.

[rezouss]

Oh yeah !

I tried on my lab, then passed it on production.
Polling time has now reduced from 160 sec to 60 sec !

Could you add this parameter in the next release (cacti or thold) ?

Thanks savagemindz !

[kyosanim]

Worked for me, too!

[savagemindz]

It just adds an index against one of the columns in the DB so that column can be search against quicker. It doesn't actually mess with any data.

This has been added to v0.3.9 of the thold plugin.

iain

[TheWitness]

I discussed this with Jimmy the other day. There is some pretty significant additional overall performance improvements we can implement. The only problem is that the changes require MySQL 5.0.x which several of the big distros are not handling yet. So, in the mean time, there will be a few additional optimizations put in on top of what Jimmy has already done. It's somewhere down the list though.

Jimmy was pretty happy with this one though.

TheWitness

[lostpckt]

Awesome, that's kind of what I figured, but being a SQL n00b, I wanted to verify.

I did see a 5-10s increase in speed (mySQL 5.0.45-6), so that was a pretty awesome gain. Glad to see it will be included in future versions once all the dependencies are there.

[mia1dolfan]

Code: Select all

mysql> use cacti;
Database changed
mysql> ALTER TABLE `graph_templates_item` ADD INDEX ( `task_item_id` );
Query OK, 183154 rows affected (9.87 sec)
Records: 183154  Duplicates: 0  Warnings: 0

It did not make any notable difference in my install.

Cacti 0.8.7.a + spine + boost SVN + thold .0.3.9