boost is wraping the poller

gsaray101 · Post by **gsaray101** » Fri Sep 12, 2008 1:14 pm

I have a cacti server (version 0.8.7a) running spine (version 0.8.7a) with boost. I have everything configured to be snmp data. Only one script server that does the poller graph as attached. Boost is configured to run every half hour. As you can see from the attached screen shot, when boost runs, poller is wraping. It is exceeding 1 minute interval.

What can I do to prevent this.

Post by **TheWitness** » Sat Sep 13, 2008 9:15 am

There is another index needed in the poller_output_boost table to reduce database load. You should also adjust you MySQL settings. You might want to consider splitting your database away from the Web site. An easy way to determine if this is required is by doing the following

Code: Select all

cd /var/www/html/cacti/rra
du -kh .

If this number is either at or above your systems (memory - 1GB), then you need to split your servers.

Then, once you've done a split, you need to tune your MySQL server to maximize memory use and optimize performance.

TheWitness

gsaray101 · Post by **gsaray101** » Mon Sep 15, 2008 10:20 am

Can you give me the exact syntax to create index on poller_output_boost?

Thank you so much

mike

khufure · Post by **khufure** » Wed Sep 24, 2008 2:23 pm

gsaray101 wrote:Can you give me the exact syntax to create index on poller_output_boost?

Seconded, thanks

gsaray101 · Post by **gsaray101** » Wed Oct 01, 2008 2:59 pm

what do you mean?

khufure · Post by **khufure** » Wed Oct 01, 2008 4:35 pm

gsaray101 wrote:what do you mean?

I also want to see the poller index creation sequence. Is it just a generic index or is it optimized?

Post by **TheWitness** » Wed Oct 01, 2008 7:37 pm

Another issue might be that 100k records in one select statement takes a while to obtain from the server, you might want to set that select size smaller, especially if the server does not have a lot of memory. I do not have the index information handy a the moment.

TheWitness

gsaray101 · Post by **gsaray101** » Thu Oct 02, 2008 10:42 am

Witness,

we have multiple cacti installs with the same config and harware. Only with this one, we are having boost problem. If you could get that re-index command to, that would really helpful. I tried to decrease the number of records, it did not help.

Post by **TheWitness** » Fri Oct 03, 2008 7:07 pm

Show me your Boost status page.

TheWitness

gsaray101 · Post by **gsaray101** » Mon Oct 06, 2008 9:18 am

here is the boost status page

Post by **TheWitness** » Mon Oct 06, 2008 7:17 pm

This looks good. Show me your output when you run the following manually:

Code: Select all

php -q poller_boost.php -force -d

The file could be pretty big. Looking for errors.

TheWitness

gsaray101 · Post by **gsaray101** » Tue Oct 07, 2008 10:50 am

when I run this command manually, I get this back:

C:\>php -q d:\cacti\plugins\boost\poller_boost.php -f -d
10/07/2008 11:30:49 AM - SYSTEM BOOST STATS: Time:221.6015 RRDUpdates:200399

I dont see any errors in cacti.log.

gsaray101 · Post by **gsaray101** » Tue Oct 07, 2008 3:21 pm

apparently something is wrong here and I cannot figure out what. is there an alternative to boost? Do I have to use boost? my cacti version is 0.8.7a and I am running spine version 0.8.7b.

thanks,

mike

Post by **TheWitness** » Tue Oct 07, 2008 9:26 pm

No "Ok" messages?

TheWitness

gsaray101 · Post by **gsaray101** » Wed Oct 08, 2008 5:29 pm

when I run that command redirect out to file, I see ok on each line. No errors.
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK

Cacti

boost is wraping the poller

boost is wraping the poller

poller_output_boost table

Re: poller_output_boost table

boost is wrapping the poller

Re: boost is wrapping the poller

boost wrapping the poller

boost is wrapping

boost

alternative to boost

boost

Who is online