Hi Jaroslav, Unfortunately not as they are integral part of the sql_history feature (which you need to populate the time-related variables of the tables). As an alternative, only for the 'all' tables where you have the other timestamps, you may disable sql_history and write to a fixed, say, 'router1_in' 'router1_out' tables and, ie. via a sql_trigger script, you can take care yourself of the logics of renaming the tables so to include some time-related variable.
Cheers, Paolo On Wed, Nov 30, 2016 at 01:00:02PM +0100, Jaroslav Jirásek wrote: > 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 _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
