Re: How to do session times The Right Way

If there are many queries are of the form "How many people are on at time x", it would pay to precompute the number of people online, second by second, and store this in a file to be accessed as needed. You could create a program to compute this incrementally and run a cron job periodically to update the file.

For the "How many people on between time x and y", I don't see any way around storing a list of begin-end pairs extracted from the weblogs and computing your functions from these.

For the math involved, you wish to consult some of the open source log analyzers, such as analog.

-Mark

Comment on Re: How to do session times The Right Way

Replies are listed 'Best First'.
Re: Re: How to do session times The Right Way by xaphod (Monk) on Nov 01, 2002 at 22:58 UTC
I'm often asked to to supply quantative data to suits. 90% of the time they don't actually care, so I stopped trying. Instead I just grab instance data and I graph it. And the suits love it. I've done graphs for mail spools, ups load, and of course all the bandwidth stats, etc., etc. The tool I use called CACTI, and uses RRD tool to do the graphing. If you can write a script that returns some numbers, cacti can handle it. Alas it's not perl. Cacti is available here. -- TTFN, FNORD xaphod	[reply]

Replies are listed 'Best First'.

Re: Re: How to do session times The Right Way
by xaphod (Monk) on Nov 01, 2002 at 22:58 UTC

I'm often asked to to supply quantative data to suits. 90% of the time they don't actually care, so I stopped trying. Instead I just grab instance data and I graph it. And the suits love it. I've done graphs for mail spools, ups load, and of course all the bandwidth stats, etc., etc.

The tool I use called CACTI, and uses RRD tool to do the graphing. If you can write a script that returns some numbers, cacti can handle it. Alas it's not perl.

Cacti is available here.

[reply]