| Subject | RE: [firebird-support] Firebird bandwidth monitoring |
|---|---|
| Author | Nigel Weeks |
| Post date | 2003-09-04T23:19:38Z |
Just use any network analysis program:
MRTG does little graphs
Many firewalling systems have byte counters - just put a rule in for the
specific port, and you're away:
Example for ipfw(FreeBSD, some linux's), done on server
remember to do counts before any allows or deny's - or you'll miss packets
Lets say server is 192.168.0.2, and has an eth0 interface
Clients are 192.168.0.3 - 192.168.0.254
#This rule counts packets leaving the server's interface on the firebird
port
ipfw add 500 count ip from 192.168.0.2,3050 to any out via eth0
#This rule count packets arriving at the server's interface on the firebird
port
ipfw add 510 count ip from any to 192.168.0.2,3050 in via eth0
# Add rules to see traffic to a specific machine(192.168.0.100)
ipfw add 520 count ip from 192.168.0.2,3050 to 192.168.0.100 out via eth0
# see the counters at any time(as root)
ipfw show
# Reset the counters for Firebird analysis
ipfw zero 500
ipfw zero 510
...
`ipfw zero` without a rule number will zero all counters - dangerous if you
need the other counts for other monitors
Just look at the counters at regular intervals(or get cron to do it), and
you'll work out how much data you're using.
You can even simulate slow modem links over any sized connection, to
simulate real-world usage.
Do a `man ipfw` for heaps more info.
MRTG does little graphs
Many firewalling systems have byte counters - just put a rule in for the
specific port, and you're away:
Example for ipfw(FreeBSD, some linux's), done on server
remember to do counts before any allows or deny's - or you'll miss packets
Lets say server is 192.168.0.2, and has an eth0 interface
Clients are 192.168.0.3 - 192.168.0.254
#This rule counts packets leaving the server's interface on the firebird
port
ipfw add 500 count ip from 192.168.0.2,3050 to any out via eth0
#This rule count packets arriving at the server's interface on the firebird
port
ipfw add 510 count ip from any to 192.168.0.2,3050 in via eth0
# Add rules to see traffic to a specific machine(192.168.0.100)
ipfw add 520 count ip from 192.168.0.2,3050 to 192.168.0.100 out via eth0
# see the counters at any time(as root)
ipfw show
# Reset the counters for Firebird analysis
ipfw zero 500
ipfw zero 510
...
`ipfw zero` without a rule number will zero all counters - dangerous if you
need the other counts for other monitors
Just look at the counters at regular intervals(or get cron to do it), and
you'll work out how much data you're using.
You can even simulate slow modem links over any sized connection, to
simulate real-world usage.
Do a `man ipfw` for heaps more info.
> -----Original Message-----http://docs.yahoo.com/info/terms/
> From: Si Carter [mailto:si@...]
> Sent: Thursday, 4 September 2003 19:11
> To: Firebird Support
> Subject: [firebird-support] Firebird bandwidth monitoring
>
>
> Are there any utilities available to monitor bandwidth usage for users
> connected to a firebird database?
>
> rgds
>
> Si Carter
> www.tectsoft.com
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
> Printer at Myinks.com. Free s/h on orders $50 or more to the
> US & Canada. http://www.c1tracking.com/l.asp?cid=5511
> http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to