Re: [squid-users] Cache economy calculation

2016-06-29 Thread Yuri Voinov
-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 conte

Re: [squid-users] Cache economy calculation

2016-06-29 Thread 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 t

Re: [squid-users] Cache economy calculation

2016-06-29 Thread Yuri Voinov
-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. Bu

Re: [squid-users] Cache economy calculation

2016-06-29 Thread 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 Sq

Re: [squid-users] Cache economy calculation

2016-06-29 Thread Yuri Voinov
-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.20

Re: [squid-users] Cache economy calculation

2016-06-29 Thread 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

Re: [squid-users] Cache economy calculation

2016-06-29 Thread Eduardo Carneiro
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

Re: [squid-users] Cache economy calculation

2016-06-29 Thread Yuri Voinov
-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 post

[squid-users] Cache economy calculation

2016-06-29 Thread 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