Oh sweat, I was only recording the last 10minutes, and was wondering why mysql was blazing fast :) Changed line to be: sql_history: 3M
This records last 3 months, I will generally query for only last 30 days Now, if I could understand why ip_src and ip_dst count are different I would be happier Thanks and best regards 2008/6/4 enrico lambertini <[EMAIL PROTECTED]>: > Ahmed Kamal ha scritto: > > Um, sorry one more basic question. My config is below (straight from > examples), and the v2 table I have has a "bytes" column. I am not so sure if > this bytes column is for download or upload or both. In my sql query I need > to get the download and upload bytes per host IP address in last 30 days, a > la > > IP DOWN UP > 1.2.3.4 600M 100M > 5.6.7.8 800M 80M > > Is it possible to get this info, from this config: > > interface: eth1 > daemonize: true > aggregate: src_host,dst_host > ! aggregate: src_net,dst_net > ! plugins: pgsql > plugins: mysql > sql_db: pmacct > sql_table: acct_v2 > sql_table_version: 2 > sql_passwd: xxxxx > sql_user: pmacct > sql_refresh_time: 90 > ! sql_optimize_clauses: true > sql_history: 10m > sql_history_roundoff: mh > ! sql_preprocess: qnum=1000, minp=5 > ! > networks_file: /etc/pmacct/pmacct-networks > > > yes, > > query download: > SELECT sum( bytes ) > FROM `table` > WHERE ip_dst = '1.2.3.4' > > query upload: > SELECT sum( bytes ) > FROM `table` > WHERE ip_src = '1.2.3.4' > > another way: mahe this changes in the script > !download > aggregate[in]: src_host, dst_host > aggregate_filter[in]: dst host 1.2.3.4 > > !upload > aggregate[out]: src_host, dst_host > aggregate_filter[out]: src host 1.2.3.4 > > !you need data per mounth > sql_history: 30m > sql_refresh_time: 300 > > then you can make a sum per column > > byz > > enrico > > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists >
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
