SARG taking too long to generate reports
Recently I´ve been observing a strange behavior in my sarg report generation routine.
My average line count for access.log is about 250.000-300.000 daily.
And I´ve noticed my reports taking DAYS to generate.
This morning I checked my sarg process, and saw three running, the first of them having started last Thursday (today´s Monday).
I have no idea why this happening.
I tried running sarg with -z and -v parameters, but everything seens alright, but it takes a LOT of time to go from one IP records to another.
Anyone has ever seen anything like it?
[EDIT]: For the record. This issue is happening in two Debian 4.0rc3.
I have other sites running Squid with a number of lines in access.log from 50.000 to 150.000, and their reports are created a LOT faster, altough they´re inferior hardware.
Last edited by Thakowbbery; 09-01-2008 at 12:21 PM.