Hi Mike, A way can be to write to tables with a dynamic name. You can read more about this in the CONFIG-KEYS file, sql_table section. IMHO: as you will be dumping plenty of data at such time resolution this can definitely be a method to scale your deployment.
Cheers, Paolo On Wed, Jun 06, 2012 at 07:39:08PM +0430, Mike Dawson wrote: > Dear all, > > We're using pmacct to construct a bandwidth management system on SME > server and it works pretty nicely putting the data in MySQL. > > However now I want to use the MySQL data to construct a live graph of > how much bandwidth each client is using. So I want pmacct to do an sql > insert every 10 seconds. > > The problem is the allowed config values for sql_history and > sql_history_roundoff being less than one minute. There is no seconds > unit according to: > http://wiki.pmacct.net/OfficialConfigKeys > > > I have set sql_refresh_time to be 10seconds. If I comment out > everything related to sql_history, then even when I disable using > updates, it seems that it just gets counted in one row with replace with > null / 0 timestamps. > > According to the documentation there is no sql_history value for > seconds. > > What I'm using right now for sql timing.. > sql_refresh_time: 10 > ! sql_optimize_clauses: true > ! sql_history: 1m > ! sql_history_roundoff: m > > If anyone has any idea on how to make this work for doing a database > update more frequently than once a minute would much appreciate it. > > Thanks/Regards, > > -Mike _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
