Hi Chris, 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.
Cheers, Paolo On Mon, Sep 02, 2013 at 11:03:02PM +0100, Chris Wilson wrote: > Hi all, > > I tried to enable the sql_multi_values option, but setting it to a > reasonable number of rows to insert at once (100) to avoid hitting > the MySQL packet size limit. But I get these errors in the logs: > > Sep 2 17:59:01 microserver pmacctd[17603]: ERROR ( summary/mysql ): > 'sql_multi_values' is too small (100). Try with a larger value. > > Sep 2 16:57:46 microserver pmacctd[17608]: ERROR ( inbound/mysql ): > You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use > near 'VALUES (FROM_UNIXTIME(1378141141), FROM_UNIXTIME(1378141080), > '00:1b:21:92:98:17' at line 1 > > This looks like a bug to me? Surely it should be reasonable to > insert up to 100 rows at a time (per SQL statement) instead of just > 1? > > 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 _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
