[squid-users] Cache economy calculation

[Yuri Voinov]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
 
Eh, if you have access.log in SQL database, you cah simple write SQL
query - viola!

select (TCP_HIT/TCP_MISS)*100 from access_log; // Cache hit

select (field_with_bytes_from_access_log_table *
TCP_HIT_count/field_with_bytes_from_access_log_table *
TCP_MISS)*1024*1024 from access_log; // Byte hit


30.06.2016 0:29, Eduardo Carneiro пишет:
> Hello everyone.
>
> I am using Squid 3.5.19 with dynamic and static caching feature activated.
> It's working very well. All entries of the access.log are in a postgres
> database. I am looking for the best way to calculate the cache economy.
>
> Someone could tell me how to do this?
>
> Best regards.
> Eduardo
>
>
>
> --
> View this message in context:
http://squid-web-proxy-cache.1019090.n4.nabble.com/Cache-economy-calculation-tp4678292.html
> Sent from the Squid - Users mailing list archive at Nabble.com.
> _______________________________________________
> squid-users mailing list
> squid-users at lists.squid-cache.org
> http://lists.squid-cache.org/listinfo/squid-users

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
 
iQEcBAEBCAAGBQJXdB58AAoJENNXIZxhPexGBA8H/0mojJPon2kX2PH+uUf2sDxU
7/e3FBTjWrUT44SRZxL4CJ3voCZYKmLx5B5Zp/fSMmUGdtIOWxbQjMX3F9/YGcIr
t/aLW5VozvD8coGhACzYk+3pyCVwwmDWnfw7YwvLF1dMrlNpgPpscJWrhEQK9Qc0
khmvzCXqIoFJvYgY9W38bViWZKhIGRTRTFoDU1o8l+p+5aR3x/y/PN4kCUzqykxH
rCw6QuB4QaYlAEUaOVc9E9tOHuc5LJE6MlkMWgToHntL099KwHR16NvR10xGzItL
hnNxMZKwJp1lh1wNpPEjHeXJsVphP1OCPOKGm/+iZTz+W28nCuJU/OAA3qUfuQQ=
=BHnu
-----END PGP SIGNATURE-----

-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0x613DEC46.asc
Type: application/pgp-keys
Size: 2437 bytes
Desc: not available
URL: <http://lists.squid-cache.org/pipermail/squid-users/attachments/20160630/e8cca64f/attachment.key>