Hi,
I have a server running with pmacctd and mysql and the following configfile:
! pmacctd configuration
!
!
!
daemonize: true
pidfile: /var/run/pmacctd.pid
syslog: daemon
!
! interested in in and outbound traffic
aggregate: src_host,dst_host,src_port,dst_port
! on this network
!pcap_filter: net 127.0.0.0/8
! on this interface
interface: eth0
!
! storage methods
plugins: mysql[in], mysql[out]
!plugins: memory[inbound], memory[outbound]
sql_host: localhost
sql_table: acct
sql_user: yyyyyyy
sql_passwd: xxxxxxxx
sql_table_version: 1
! refresh the db every minute
sql_refresh_time: 60
! reduce the size of the insert/update clause
sql_optimize_clauses: true
! accumulate values in each row for up to an hour
sql_history: 5m
! create new rows on the minute, hour, day boundaries
sql_history_roundoff: mhd
! in case of emergency, log to this file
!sql_recovery_logfile: /var/lib/pmacct/recovery_log
After a couple of minuts I have 502-505 of these processes running:
root 17871 0.0 0.2 13364 5004 ? S Mar26 0:00
pmacctd: MySQL Plugin -- DB Writer [in]
root 17895 0.0 0.2 13364 5000 ? S Mar26 0:00
pmacctd: MySQL Plugin -- DB Writer [out]
Why is it not closing the mysql connections or reusing the connections?
uname -a
Linux tfb 2.6.18-6-686 #1 SMP Sun Feb 10 22:11:31 UTC 2008 i686 GNU/Linux
Promiscuous Mode Accounting Daemon, pmacctd 0.10.1
mysql --version
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
Hope anyone have a clue what to try :-)
--
Med venlig hilsen
René Madsen
Schultz Conuslt
Glanshatten 54b
5220 Odense SØ
tlf.: (+45) 46 95 08 82
mobil: (+45) 28 34 36 85
www.schultzconsult.dk
Kontortid: man-tor 08.30-18.30 fre 08.30-15.45
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
