Seems like a reasonable was to estimate to me. MySQL is my main concern as well, but I can always host that externally. Thanks for the info, I'm going to look in to this in more depth.
------------------ Aubrey Wells Senior Engineer Shelton | Johns Technology Group A Vyatta Ready Partner www.sheltonjohns.com On Nov 8, 2007, at 1:56 PM, Alain Kelder wrote: > Hello Aubrey, > > Nacctd runs as a daemon, which on my system takes about 1mb of > RAM. The CPU load seems negligible. Not knowing how else to > monitor processor usage over time, I ran this as a script every two > seconds for a couple of hours: > > while true; do > ps aux | grep nacctd | grep -v 'grep' | grep -v 'watch.nacctd' > >> /root/perfmon/watch.nacctd.log > sleep 2 > done > > The resulting log showed the daemon never registered cpu usage over > 0.0. Perhaps my method is flawed. Do you know of a better way? > > Otherwise, I would say that the biggest overhead is running MySQL > (mysqld on my system is using about 20MB of RAM). As far as disk > space, a few months worth of stats for 6 systems (around 15K worth > of rows in the traffic table) takes about 1MB. > > Hope this answers your question.. Cheers, -Alain. > > > On Wed, 7 Nov 2007 22:42:10 -0500, Aubrey Wells > <[EMAIL PROTECTED]> wrote: >> This sounds very interesting. Have you noticed any performance impact >> to running it? >> >> >> >> ------------------ >> Aubrey Wells >> Senior Engineer >> Shelton | Johns Technology Group >> A Vyatta Ready Partner >> www.sheltonjohns.com >> >> >> >> >> On Nov 7, 2007, at 10:15 PM, Alain Kelder wrote: >> >>> Hello Dominic, >>> >>> Out of the various tools I've tried, netacct-mysql is currently my >>> favorite. It collects bandwidth data through libpcap and stores >>> in a >>> MySQL DB. It comes with a PHP front end, but to me the real >>> power is >>> that it stores the stats in MySQL. Through SQL SELECT >>> statements, I'm >>> able to get all the stats I need. For instance: >>> >>> mysql> SELECT SUM((input+output)/1073741824) FROM traffic WHERE >>> IP='10.10.2.122' AND time LIKE '2007-09%'; >>> >>> gives me total (in+out) GBs of bandwith used by 10.10.2.122 during >>> Sept >>> 07. I run it on the Xen host to keep track of the guest domain >>> bandwidth usage, but it should run on the Vyatta box just as well >>> (haven't tried yet, sorry). The other thing I started playing with >>> today is grabbing the data from the DB using PHP and feeding it >>> to the >>> chart PHP script from www.maani.us to get pretty graphs. >>> >>> I would love to know what you end up using! >>> >>> Cheers, -Alain. >>> >>> >>> >>> http://sourceforge.net/projects/netacct-mysql/ >>> >>> Dominic Williams wrote: >>>> Many thanks for your response. >>>> >>>> What we need to generate is a traffic graph for each IP that we >>>> serve i.e. At 4.20.00pm some IP was using 7Mbps, at 4.20.15pm it >>>> was using 5.2Mbps, at 4.20.30 it was using 6.3Mbps and so on. >>>> >>>> We need this data is used to understand how sites (which run on >>>> IPs) behave and also to provision overall bandwidth and pass >>>> bandwidth costs to clients. >>>> >>>> Is this possible and for example, is anyone doing 95th percentile >>>> billing using a Vyatta router? >>>> >>>> Best, Dominic >>>> >>>> -----Original Message----- >>>> From: "Holtz,Robert" <[EMAIL PROTECTED]> >>>> To: "Dominic Williams" <[EMAIL PROTECTED]>; "vyatta- >>>> [EMAIL PROTECTED]" <[EMAIL PROTECTED]> >>>> Sent: 07/11/07 16:27 >>>> Subject: RE: [Vyatta-users] Want to use Vyatta for our main BGP >>>> router - butwhat about traffic tracking? >>>> >>>> You can collect SNMP interface performance data anywhere along the >>>> path to the outside world, not just the router. There's quite a >>>> bit of flexibility. >>>> >>>> Examples: >>>> The Web Server itself >>>> Load Balancer, if you have a bunch of web servers >>>> Ethernet Switch(s) >>>> Router >>>> Etc. >>>> >>>> >>>> >>>> >>>> >>>> >>>> If you are not the intended recipient of this message (including >>>> attachments), or if you have received this message in error, >>>> immediately notify us and delete it and any attachments. If you >>>> no longer wish to receive e-mail from Edward Jones, please send >>>> this request to [EMAIL PROTECTED] You must include the e- >>>> mail address that you wish not to receive e-mail communications. >>>> For important additional information related to this e-mail, visit >>>> www.edwardjones.com/US_email_disclosure >>>> >>>> -----Original Message----- >>>> >>>> >>>> From: [EMAIL PROTECTED] [mailto:vyatta-users- >>>> [EMAIL PROTECTED] On Behalf Of Dominic Williams >>>> Sent: Wednesday, November 07, 2007 10:07 AM >>>> To: [EMAIL PROTECTED] >>>> Subject: [Vyatta-users] Want to use Vyatta for our main BGP router >>>> - butwhat about traffic tracking? >>>> >>>> Hello all, >>>> >>>> My company is very keen to try a Vyatta solution, as we are about >>>> to move our hosting rack to a BGP solution and a 7204VXR with 1GB >>>> seems inordinately expensive!! >>>> >>>> But... we need to be able to monitor and track bandwidth to each >>>> individual IP address that we serve. >>>> >>>> This is a crucial requirement, as it is for many people involved >>>> in Web hosting. >>>> >>>> At the moment we just use Netflow exports from our Cisco router in >>>> conjunction with some tracking software... I know that Vyatta >>>> doesn't support Neflow, but somebody indicated on this list that >>>> you can get at these stats using SNMP. >>>> >>>> Is this really the case? Can you get at traffic flows for >>>> individual IPs that are being served through the router? >>>> >>>> -- I was under the impression SNMP was just of use for monitoring >>>> the status of a particular device / interface etc?? >>>> >>>> Many thanks for any advice you can give. >>>> >>>> Best, Dominic >>>> >>>> Dominic Williams >>>> www.System7.com >>>> www.Wyki.com >>>> >>>> Better Digital Publishing >>>> Email >>>> >>>> [EMAIL PROTECTED] >>>> Direct >>>> >>>> +44 (0) 203 0519110 ext. 8010 >>>> Mobile >>>> >>>> +44 (0) 7710 469456 >>>> Fax >>>> >>>> +44 (0) 8700 607555 >>>> >>>> Terms: This e-mail contains proprietary information some or all of >>>> which may be legally privileged. It is intended for the recipient >>>> only. If an addressing error or transmission error has misdirected >>>> this e-mail, please notify the sender immediately or contact >>>> [EMAIL PROTECTED] If you are not the intended recipient >>>> you must not use, disclose, distribute, copy, print or rely on >>>> this e-mail. >>>> >>>> _______________________________________________ >>>> Vyatta-users mailing list >>>> Vyatta-users@mailman.vyatta.com >>>> http://mailman.vyatta.com/mailman/listinfo/vyatta-users >>>> >>>> >>> _______________________________________________ >>> Vyatta-users mailing list >>> Vyatta-users@mailman.vyatta.com >>> http://mailman.vyatta.com/mailman/listinfo/vyatta-users > _______________________________________________ Vyatta-users mailing list Vyatta-users@mailman.vyatta.com http://mailman.vyatta.com/mailman/listinfo/vyatta-users