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

Reply via email to