No, it should definitely batch the data into inserts of 1000 values each. Edward
On Tue, Sep 3, 2013 at 10:29 AM, Chris Wilson <[email protected]> wrote: > 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 > -- Edward van Kuik Nitric Industries CC t/a Nitric Software Laboratory 78 Strand Street Cape Town, South Africa Tel: +27 21 300 1073 Cell: +27 83 645 6443 http://nitric.co.za/
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
