Hi Edward,

On Tue, 3 Sep 2013, Edward van Kuik wrote:

Sep  2 17:59:01 microserver pmacctd[17603]: ERROR ( summary/mysql ): 'sql_multi_values' is too small (100). Try with a larger value.

I set mine to 1000.

OK, so 1000 might work for you now. But it seems that pmacct can't split the inserts into multiple batches, otherwise a smaller batch size would work too. So one day you might have more than 1000 flows to insert at a time, and you'd get this error and lose data. In fact are you sure you haven't lost any data already?

Cheers, Chris.
--
Aptivate | http://www.aptivate.org | Phone: +44 1223 967 838
Citylife House, Sturton Street, Cambridge, CB1 2QF, UK

Aptivate is a not-for-profit company registered in England and Wales
with company number 04980791.
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Reply via email to