Hi Chris, Got you, the issue is now fixed:
http://www.mail-archive.com/[email protected]/msg00824.html Cheers, Paolo On Tue, Sep 03, 2013 at 01:28:54PM +0100, Chris Wilson wrote: > Hi Paolo, > > On Tue, 3 Sep 2013, Paolo Lucente wrote: > > >Maybe a bug in documentation in the release you are using? > >CONFIG-KEYS says: "The value of the directive is intended to be > >the size (in bytes) of the multi-values buffer.". So 100 bytes is > >on the low side, and by default MySQL comes with a 1MB buffer - > >after that you should tweak MySQL config first, then set the > >sql_multi_values value accordingly. I can confirm statements are > >batched in several buffers if one can't fit them all. > > Thanks, I understand now. I had completely missed that it was in > bytes instead of rows. > > There does seem to be a minor bug in that pmacct appears to fall > over if the value is too small. I'm sure it could log a warning and > write larger but valid INSERT statements, with at least one VALUES > row per statement. > > 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
