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

[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.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

 

Any help would be great.

 

regards,
Zul

---

How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.

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