Re: [squid-users] Cache economy calculation
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Yep. Sure. 30.06.2016 0:57, Eduardo Carneiro пишет: > Thank you again. In this case, I think that I'll exclude the "DENIED" of my > query. Theoretically this access don't go to the internet. That's correct? > > > > -- > View this message in context: http://squid-web-proxy-cache.1019090.n4.nabble.com/Cache-economy-calculation-tp4678292p4678300.html > Sent from the Squid - Users mailing list archive at Nabble.com. > ___ > squid-users mailing list > squid-users@lists.squid-cache.org > http://lists.squid-cache.org/listinfo/squid-users -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQEcBAEBCAAGBQJXdCw0AAoJENNXIZxhPexGETUIALFvZVmQ4TAsubu2zgWvee/j kx/8y8gL+GBBW7C+DiwhrDdwKTCCHH8TeG9WEfzzjPDAenFd1hmuZKsxweEAQxsK ptZ/08Zc9hIhwNLoa3FoFqvXmsGEMStnqVgiqdcznCo/m55UgalmxufVjc3RrGPO pn1wzIyHDMUsluhcLUTzVCSZOxpLTiSWRI9Rp6AvFu/r3u25ZVvM9GRpKsLULryq kOE5B7G4M9kme2KJGDF/Oa2kWyy2PiRssbaRMWy0YnnCHGX8Yt22L3pTpZjbvK+v GMhIL7R3v075TYW528vMKiaFhAxvwTgRtT+r6egoIxlXRieIlT4Tu7a32288HPI= =UoUt -END PGP SIGNATURE- 0x613DEC46.asc Description: application/pgp-keys ___ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
Re: [squid-users] Cache economy calculation
Thank you again. In this case, I think that I'll exclude the "DENIED" of my query. Theoretically this access don't go to the internet. That's correct? -- View this message in context: http://squid-web-proxy-cache.1019090.n4.nabble.com/Cache-economy-calculation-tp4678292p4678300.html Sent from the Squid - Users mailing list archive at Nabble.com. ___ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
Re: [squid-users] Cache economy calculation
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 You can extend your SQL query as you required, of course. This was only an direction, idea. Or, possible to write several different queries, like existing script-based reporting tool. 30.06.2016 0:45, Eduardo Carneiro пишет: > Thank you Yuri. But, the other action types like "TCP_DENIED" per example, > shall be calculated too? Or only "MISS" an "HIT" like you said before? > > > > -- > View this message in context: http://squid-web-proxy-cache.1019090.n4.nabble.com/Cache-economy-calculation-tp4678292p4678297.html > Sent from the Squid - Users mailing list archive at Nabble.com. > ___ > squid-users mailing list > squid-users@lists.squid-cache.org > http://lists.squid-cache.org/listinfo/squid-users -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQEcBAEBCAAGBQJXdCIvAAoJENNXIZxhPexGrWsIALoHyCHfnxQprJsoFkLZy4tJ CtiygQT4PF8ly8LomHRgkQ+OyYJZ49/QXAJR2AQQ02t+ddGCKG6zRGAUVOakIwXk D/SJuFoCaSXeNyEv8P9dGbRozXj++mLhijK2QqEMNoccW2B3yao/OefRY7VURQYj QNHhYRRT/Clrk0YQ3q1rGzCuDhDXvlw1SLYDob1xqqSMx4gm39HDtfKI+fcK7aa6 WMZKe0eiDMzTuR6MB7e/6WUh+W/tBCDCX8jVIc7WOgUJ4ggvndinrgKkXz+QQ5kg Nru7cYv0LADxGqQh6gHPCnHerSldYJrOCdzJ44wcWSEjJt1eDV7DzvllruawqjM= =UujZ -END PGP SIGNATURE- 0x613DEC46.asc Description: application/pgp-keys ___ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
Re: [squid-users] Cache economy calculation
Thank you Yuri. But, the other action types like "TCP_DENIED" per example, shall be calculated too? Or only "MISS" an "HIT" like you said before? -- View this message in context: http://squid-web-proxy-cache.1019090.n4.nabble.com/Cache-economy-calculation-tp4678292p4678297.html Sent from the Squid - Users mailing list archive at Nabble.com. ___ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
Re: [squid-users] Cache economy calculation
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Ah, there is better solution exists. You can re-write Calamaris to get source data from DB - it written on perl, simple. Just add DB adapter from CPAN. :) P.S. I think, you will be surprised, how low is your _real_ byte hit :))) 30.06.2016 1:16, Yuri Voinov пишет: > > 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@lists.squid-cache.org > > http://lists.squid-cache.org/listinfo/squid-users > > -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQEcBAEBCAAGBQJXdB8bAAoJENNXIZxhPexG8o4H/2EUtBMEnLH+ewMhdJRhsoOW jG7XCO9NqqSC+bxLX6Y1dHBj7MFS5RBvUs/a4piDGLnOZM7/La57/WK9UU9OmTmw vWjxD/LU7M1yUt9pgCe6K4PRDPJaionnheKNHtY///Xih9G9IgIzOWJgzmVa39pZ hrXdT0qKf/7lAdYIjZPW5Tlm/yxEab3LBWBj823AjJgiXBpPUuMD1G0VMaBz4KG0 5GbgYBLQE57N8pl5ufrOIQY0PFRaaWpr6Ct0Y65feXz3Hm0ax0P6VIlU3Suh3nQg 8YU6H8PQniGWy+Mj1MebrVqZwLID4YYbQ8w+b6F9+Un8Z5cExBIVQd6cm8pl+eo= =m5mo -END PGP SIGNATURE- 0x613DEC46.asc Description: application/pgp-keys ___ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
Re: [squid-users] Cache economy calculation
-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@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- 0x613DEC46.asc Description: application/pgp-keys ___ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
Re: [squid-users] Cache economy calculation
No, no. Only for management purposes. -- View this message in context: http://squid-web-proxy-cache.1019090.n4.nabble.com/Cache-economy-calculation-tp4678292p4678294.html Sent from the Squid - Users mailing list archive at Nabble.com. ___ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
Re: [squid-users] Cache economy calculation
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Hhh... billing system? 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@lists.squid-cache.org > http://lists.squid-cache.org/listinfo/squid-users -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQEcBAEBCAAGBQJXdB3EAAoJENNXIZxhPexGYWcIAInezRTelGnP3rzrsBLWkdZB XqjUFU/9YBPCEqoXiBnO4c3VH4iAyj1pBlZPM5aFhfQOi1Sp3CZksITomckwE0jU xgtafGOudrc8UaOeLwRyEftre6E6yfzEFnKadv+gg4yFOLk0sUKuBAdjqHI13BPx 9BxPc4xN7opmsXow97+q7u/oQyb7f3trvNqJRKKw1KOWgeW2PMh/847v5z7eM0v5 zQ0Z4ueAFNRWIUxC5+OxO9bwrNpGLkG3uUw2ZPlZaZdvTM3OcgaX3Y5s8VhbUxea 3A7v7mbzpgwY7rKfi8jvROPNI3hITYwiKPn3TpuBa7W6kDat3NxPZUwhMPE59+I= =p1Aq -END PGP SIGNATURE- 0x613DEC46.asc Description: application/pgp-keys ___ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
[squid-users] Cache economy calculation
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@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users