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
