A short time ago, at a computer terminal far, far away, Paolo Lucente wrote:
Dear Paolo, I've changed the config to the following: debug: false daemonize: true interface: eth0 sfacctd_ip: 62.148.189.229 sfacctd_port: 6343 plugin_buffer_size: 2048 plugin_pipe_size: 2048000 imt_buckets: 65537 imt_mem_pools_size: 65536 sfacctd_allow_file: /etc/pmacct/sflow_allow.map networks_file: /etc/pmacct/sflow_networks.map pre_tag_map: /etc/pmacct/sflow_pretag.map sfacctd_renormalize: true sfacctd_disable_checks: true syslog: local2 sql_table: acct_v7 sql_table_version: 7 sql_host: localhost sql_user: pmacct sql_passwd: ****** sql_optimize_clauses: true sql_history: 1M sql_history_roundoff: m sql_multi_values: 512000 sql_locking_style: table sql_db: pmacct sql_dont_try_update: false sql_cache_entries: 2000000 sql_refresh_time: 60 plugins: mysql[traffic_perip] aggregate[traffic_perip]: src_host, dst_host, tag After this change, I haven't seen any duplicate entries. But I'm seeing some weird locking issues. pmacct is trying to lock the table (LOCK TABLES `acct_v7` WRITE). And this is done 16 times. Also the table lock is preventing SELECTs while the table is being updated. -- With kind regards, Dennis Koster Manager Linux Hosting Solutions Denit Hosting Solutions Contactweg 131 1014 BJ Amsterdam Telefoon: +31 (0)20 337 1801 Fax: +31 (0)20 337 1802 Internet: www.denit.nl E-mail: [email protected] _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
