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
