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

[zulkarnain]

Hi gregor,

 

Thanks for your reply. This directives out "sql_history" and "sql_history_roundoff" only solve my problem with database size and number of row increase issue. And now  pmacct result become inaccurate since pmacct keep continue calculating traffic from the first time pmacctd started. Is there any tricks to get the last 5 minutes data for each ip address without getting database size and number of row increase? any help would be great.

 

regards,

Zul

 
[EMAIL PROTECTED] wrote:

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 is my config.

> 

> ------pmacctd.conf

> syslog: daemon

> interface: eth1

> daemonize: true

> promisc: true

> aggregate: src_host,dst_host

> plugins: mysql

> sql_host: 192.168.1.1

> sql_db: eth1

> sql_table: acct

> sql_table_version: 1

> sql_passwd: pmacctpasswd

> sql_user: pmacct

> sql_history: 5m

> sql_history_roundoff: m

> sql_cache_entries: 2

> networks_file: /etc/pmacct/networks.lst

> pcap_filter: not ip broadcast and not 192.168.1.1

> 

> -----networks.lst

> 192.168.1.2/32

> 192.168.1.3/32

> 192.168.1.4/32

> 

 

Leave the "sql_history" and "sql_history_roundoff" directives out and

you should be all set

--

Cheers,

Gregor

 

_______________________________________________

pmacct-discussion mailing list

http://www.pmacct.net/#mailinglists

---

Get your email and more, right on the new Yahoo.com

_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists