Paolo,
I returned the sql refresh time to 60 seconds. Then, I transferred a
46mb file using wget. the transfer was from 69.18.69.133 (off network)
to 159.54.224.249. The transfer took about 2.5 minutes.
Wget reported these transfer stats: (Transfer began at 10:40:49)
Length: 47,657,612 (17,654,084 to go) [application/octet-stream]
10:43:19 (309.40 KB/s) - `mrtg.rar.2' saved [47657612/47657612]
Then, I ran this query against the db:
select stamp_inserted,stamp_updated,ip_src,ip_dst,packets,bytes from
acct_v2 where (ip_dst='69.18.69.133' or ip_src='69.18.69.133') and
stamp_inserted>'2005-02-25 09:55:00';
+---------------------+---------------------+----------------
+----------------+---------+----------+
| stamp_inserted | stamp_updated | ip_src | ip_dst
| packets | bytes |
+---------------------+---------------------+----------------
+----------------+---------+----------+
| 2005-02-25 10:40:00 | 2005-02-25 10:41:01 | 159.54.224.250 |
69.18.69.133 | 701 | 38809 |
| 2005-02-25 10:40:00 | 2005-02-25 10:41:01 | 69.18.69.133 |
159.54.224.250 | 1288 | 1904860 |
| 2005-02-25 10:40:00 | 2005-02-25 10:42:01 | 69.18.69.133 |
159.54.224.250 | 6742 | 10002416 |
| 2005-02-25 10:40:00 | 2005-02-25 10:42:01 | 159.54.224.250 |
69.18.69.133 | 3483 | 187080 |
| 2005-02-25 10:40:00 | 2005-02-25 10:43:01 | 69.18.69.133 |
159.54.224.250 | 6687 | 9863335 |
| 2005-02-25 10:40:00 | 2005-02-25 10:43:01 | 159.54.224.250 |
69.18.69.133 | 3637 | 197137 |
| 2005-02-25 10:40:00 | 2005-02-25 10:44:01 | 69.18.69.133 |
159.54.224.250 | 2192 | 3251420 |
| 2005-02-25 10:40:00 | 2005-02-25 10:44:01 | 159.54.224.250 |
69.18.69.133 | 1102 | 58168 |
+---------------------+---------------------+----------------
+----------------+---------+----------+
(sorry about the wrap on the table)
Total bytes where 159.54.224.249 was the ip_dst: 25,022,031
Total bytes where 159.54.224.249 was the ip_src: 481,194
Is this any help?
Thanks,
Dave
On Thu, 2005-02-24 at 23:23 +0100, Paolo Lucente wrote:
> Hello Dave,
> with the details in my hands, i've actually no idea. Can you do some simple
> file transfer of some rather large file and check counters after it has
> completed ? This should point out what counter increases the correct way.
> A 40-50Mb transfer should suffice. One note: because the bufferization
> of packets is enabled a little skew might be normal; with 32768 bytes as
> buffer size, it should buffer some 900 packets (circa 1Mb ?).
>
> Cheers,
> Paolo
>
>
> _______________________________________________
> pmacct-discussion mailing list
> [email protected]
> http://muffin.area.ba.cnr.it/mailman/listinfo/pmacct-discussion
>
--
Dave Maple
Senior Network Engineer
GMTI, Foundation Engineering
(757)624-2471
[EMAIL PROTECTED]
