Re: [pmacct-discussion] MySQL database size and number of row (SORRY)

2006-08-28 Thread zulkarnain
Hi Peter,   Thank you for your quick response, I greatly appreciate it. My apologize for sending the same question to the list, but I did not receive any email from pmacct-discussion@pmacct.net accept this one, also checked to the list archieve at pmacct.net website and my message still did not a

Re: [pmacct-discussion] MySQL database size and number of row

2006-08-28 Thread Peter Nixon
You already asked this question a couple of hours again AND you received an answer. Why would you spam the list a second time with the same question? -Peter On Mon 28 Aug 2006 23:30, zulkarnain wrote: > Hi, > > I'm having problem with running pmacct in my network. MySQL database size > and num

[pmacct-discussion] MySQL database size and number of row

2006-08-28 Thread zulkarnain
Hi,   I'm having problem with running pmacct in my network. MySQL database size and number of row increase every minutes. I'm just wondering if is it possible to keep only one row for each ip_src and ip_dst ip address and reduce the size of mysql database? Here is my config.   --pmacctd.co

Re: [pmacct-discussion] pm-acct on debian sarge

2006-08-28 Thread Peter Nixon
On Mon 28 Aug 2006 21:43, Paolo Lucente wrote: > Hi Thomas, > > On Mon, Aug 28, 2006 at 06:43:26PM +0200, Thomas Stegbauer wrote: > > so first i tried to run the nfacctd from sarge (version 0.7.4) > > > > but starting the process with; > > nfacctd -D -c src_host,dst_host -l 3 -P pgsql -f > > /e

Re: [pmacct-discussion] pm-acct on debian sarge

2006-08-28 Thread Paolo Lucente
Hi Thomas, On Mon, Aug 28, 2006 at 06:43:26PM +0200, Thomas Stegbauer wrote: > so first i tried to run the nfacctd from sarge (version 0.7.4) > > but starting the process with; > nfacctd -D -c src_host,dst_host -l 3 -P pgsql -f /etc/pmacct/nfacctd.conf In old releases, the use of commandlin

Re: [pmacct-discussion] pm-acct on debian sarge

2006-08-28 Thread Peter Nixon
On Mon 28 Aug 2006 19:43, Thomas Stegbauer wrote: > hi ml, > > i am currentliy trying pmacct - cause netflow2mysql doesn't fit my > vision's ;) or at least mysql doesn't run my queries without full > table-locks, even with innodb. > > so first i tried to run the nfacctd from sarge (version 0.7.4) >

Re: [pmacct-discussion] MySQL database size and number of row

2006-08-28 Thread Gregor Heuer
zulkarnain schrieb: > Hi, > > I'm having problem with running pmacct in my network. MySQL database > size and number of row increase every minutes. I'm just wondering if > is it possible to keep only one row for each ip_src and ip_dst ip > address and reduce the size of mysql database? > Here

[pmacct-discussion] pm-acct on debian sarge

2006-08-28 Thread Thomas Stegbauer
hi ml, i am currentliy trying pmacct - cause netflow2mysql doesn't fit my vision's ;) or at least mysql doesn't run my queries without full table-locks, even with innodb. so first i tried to run the nfacctd from sarge (version 0.7.4) but starting the process with; nfacctd -D -c src_host,dst_host

[pmacct-discussion] MySQL database size and number of row

2006-08-28 Thread zulkarnain
Hi,   I'm having problem with running pmacct in my network. MySQL database size and number of row increase every minutes. I'm just wondering if is it possible to keep only one row for each ip_src and ip_dst ip address and reduce the size of mysql database? Here is my config.   --pmacctd.co