[rtg] rtgpoll using 98% CPU, causing high load

[centyx at centyx.net]

This appears to have been the problem. I inserted lines into my backup script to stop/start rtg just before/after restarting mysql. To be extra safe, I also modified my rtgchk.sh ( run via cron every 5 minutes ) to stop rtgpoll if it is running and mysql is not, and start rtgpoll if it is not running and mysql is. 

Since I have done this, I have not seen the high CPU/load issues.

Thanks Jeff.

On Wed, 25 Oct 2006 10:06:25 -0400, "Jeff Crowe" <jeff at wtccommunications.ca> wrote:
> Hi Micheal,
>
> I haven polling hundreds of interfaces without a problem using RTG.  The
> one statement you made caught my attention:  it is during the busiest
> times due to backups.
>
> Is your mysql database being backed up at that time causing delayed
> inserts for RTG?  If so, then the program is just backing up with mysql
> queries while your databases are locked for backup purposes.
>
> Just a thought.
>
> Cheers,
> Jeff.
>
>> -----Original Message-----
>> From: rtg-bounces at fireflynetworks.net
>> [mailto:rtg-bounces at fireflynetworks.net] On Behalf Of
>> centyx at centyx.net
>> Sent: October 25, 2006 9:48 AM
>> To: rtg at fireflynetworks.net
>> Subject: [rtg] rtgpoll using 98% CPU, causing high load
>>
>>
>> I setup rtgpoll ( from cvs ) yesterday on a server with a p4
>> 2.6ghz processor and 1gb memory running Linux 2.4. The load
>> usually stays around 0.55. I started with a fresh database
>> and created targets using the included rtgtargmkr.pl.
>> Currently there is one 'router' with 18 'interfaces.' rtgpoll
>> ran fine, until around 2:30am, which also happens to be the
>> time when traffic is highest on the network due to backup
>> transfers. At this point, rtg's CPU usage according to the
>> output of ps and top began to skyrocket, and the system load
>> went up to 10. The system became nearly unusable. Once I
>> restarted rtgpoll the load dropped back to normal and
>> everything was fine.
>>
>> Has anyone experienced similar issues or know why this might
>> be happening? I have read previously on the mailing list
>> accounts of other users having hundreds of interfaces being
>> polled, and I am only polling 18, so I would think that I
>> wouldn't be running into perforance/resource issues on a
>> generally idle machine. Any clues or tips on how to
>> troubleshoot this further would be greatly appreciated. Thanks!
>>
>> Michael
>>
>>
>>
>>
>> _______________________________________________
>> RTG mailing list
>> RTG at fireflynetworks.net
>> http://fireflynetworks.net/mailman/listinfo/rtg
>>