Re: [squid-users] Squid + MySQL ?

Chris Robertson wrote:
> Marcello Romani wrote:
>> Il Friday 31 July 2009 17:29:51 Maxime Gaudreault ha scritto:
>>
>>> After all logs entries are in the database I need to calculate how much
>>> bandwidth has been saved by squid. What HTTP Code tells me that the
>>> object came from the cache ? Everything with HIT in it ? TCP_HIT,
>>> TCP_MEM_HIT, TCP_NEGATIVE_HIT ?
>>>
>>
>> Don't know about NEGATIVE_HIT, but I would add TCP_DENIED to the list.
>>
>
> While it is served from the cache, there is no way to calculate
> bandwidth savings associated with a TCP_DENIED*. By the same metric,
> TCP_NEGATIVE_HIT is served from the cache and has a size associated with
> it and seems like a valid bandwidth savings metric to me.
>

Also, don't forget to use the logformat tag %st instead of the default
%<st.
That will catch the true bandwidth used for PUT, POST, file uploads and
AJAX stuff.

>> Just my 2 (euro)cents.
>>
>
> Ditto. Except US currency.
>

Ditto. In NZc.

Amos

-- 
Please be using
   Current Stable Squid 2.7.STABLE6 or 3.0.STABLE17
   Current Beta Squid 3.1.0.12