Hi, I use this scerario:
sql_refresh_time: 120
sql_history: 2m
sql_history_roundoff: m
sql_dont_try_update: true
nfacctd_pro_rating: true
aggregate[router1.all.in]:
src_host,dst_host,proto,src_port,dst_port,timestamp_start,timestamp_end
aggregate[router1.all.out]:
src_host,dst_host,proto,src_port,dst_port,timestamp_start,timestamp_end
aggregate[router1.sums.in]: dst_host
aggregate[router1.sums.out]: src_host
plugins:
mysql[router1.all.in],mysql[router1.all.out],mysql[router1.sums.in],mysql[router1.sums.out]
sql_table[router1.all.in]: %Y%m%d_router1_in
sql_table[router1.all.out]: %Y%m%d_router1_out
sql_table[router1.sums.in]: %Y_router1_sums_in
sql_table[router1.sums.out]: %Y_router1_sums_out
sql_startup_delay[router1.all.in]: 240
sql_startup_delay[router1.all.out]: 240
sql_startup_delay[router1.sums.in]: 240
sql_startup_delay[router1.sums.out]: 240
in tables %Y%m%d_router1_in and %Y%m%d_router1_out I have columns
stamp_inserted and stamp_updated,
but I don´t need them, because I aggregate nothing. timestamp_start and
timestamp_end is enough.
In these tables I need to store everything for best accuracy when
finding problems.
In sums tables I don´t need column stamp_updated.
Is there any way to not store these columns?
Thank you, Jaroslav
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists