I set mine to 1000. Edward On Sep 3, 2013 12:06 AM, "Chris Wilson" <[email protected]> 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<http://www.pmacct.net/#mailinglists> >
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
