[Rabbit-dev] Logging Usage

[Luis Soltero]

working!

mysql> select * from proxy_stats;
+----------+-------------+--------------+--------------+---------------+---------------------+
| username | client_read | client_write | network_read | network_write | last_access         |
+----------+-------------+--------------+--------------+---------------+---------------------+
| test     |       56195 |        46204 |        37402 |         24746 | 2011-08-19 05:37:06 |
+----------+-------------+--------------+--------------+---------------+---------------------+
1 row in set (0.00 sec)

mysql> select * from proxy_stats;
+----------+-------------+--------------+--------------+---------------+---------------------+
| username | client_read | client_write | network_read | network_write | last_access         |
+----------+-------------+--------------+--------------+---------------+---------------------+
| test     |      104099 |        75218 |        56873 |         36219 | 2011-08-19 05:37:20 |
+----------+-------------+--------------+--------------+---------------+---------------------+
1 row in set (0.00 sec)

mysql> select * from proxy_stats;
+----------+-------------+--------------+--------------+---------------+---------------------+
| username | client_read | client_write | network_read | network_write | last_access         |
+----------+-------------+--------------+--------------+---------------+---------------------+
| test     |      189965 |       420265 |       933861 |         91495 | 2011-08-19 05:37:38 |
+----------+-------------+--------------+--------------+---------------+---------------------+
1 row in set (0.00 sec)

mysql> select * from proxy_stats;
+----------+-------------+--------------+--------------+---------------+---------------------+
| username | client_read | client_write | network_read | network_write | last_access         |
+----------+-------------+--------------+--------------+---------------+---------------------+
| test     |      346455 |       753148 |      1503840 |        179451 | 2011-08-19 05:38:48 |
+----------+-------------+--------------+--------------+---------------+---------------------+
1 row in set (0.00 sec)


Can you tell me more about network_write/read?   Is this just the raw network read/write that is caused by the requested
url? in otherwords... if there is a cache hit then the network traffic is very small. if there is a cache hit then there
is considerably more network traffic.   Is there a way to tell the amount of data that was extracted from the cache? or
is this built into network_X some how?

I look forward to your response.

--luis


On 8/17/11 4:20 PM, Robert Olofsson wrote:
> On Wed, 17 Aug 2011 16:06:43 -0400
> Luis Soltero <lsoltero at globalmarinenet.com> wrote:
>
>> It sounds like writing our own logger is probably the best way to do that but I have no idea how.  Would it be possible
>> to create a template that we could use as a starting point.  In the end we will want to execute sql statements to update
>> table entries in the db.
> Take a look at the StandardOutTrafficLogger that I made, consider it a 
> very basic template. You probably want to look at SQLBlockFilter to 
> see how to handle the database connection.
>
> I thought about writing an example sql traffic logger, but I did not
> figure out what values would be good to log in the general case.
>
> /robo
>


-- 


Luis Soltero, Ph.D., MCS
Director of Software Development, CTO
Global Marine Networks, LLC
StarPilot, LLC
Tel: 865-379-8723
Fax: 865-681-5017
E-Mail: lsoltero at globalmarinenet.net
Web: http://www.globalmarinenet.net
Web: http://www.starpilotllc.com