you must know how big your data are or take a testserver and play around with increase the value step for step - we are using 200M because it is only relevant for import dumps here what does not happen parallel and there is enough memory
Am 12.10.2011 15:40, schrieb Tompkins Neil: > But how do I calculate such size ? > > On Wed, Oct 12, 2011 at 2:38 PM, Reindl Harald <h.rei...@thelounge.net > <mailto:h.rei...@thelounge.net>> wrote: > > as big as you largest query > > Am 12.10.2011 15:30, schrieb Tompkins Neil: > > Do you have any recommendations as to what size this should be > increased to > > ? > > > > On Tue, Oct 11, 2011 at 12:23 AM, Angela liu <yyll2...@yahoo.com > <mailto:yyll2...@yahoo.com>> wrote: > > > >> Yeah, I think adjusting max packet size may be helpful, remember change > >> that value in both server and client > >> > >> ------------------------------ > >> *From:* Johnny Withers <joh...@pixelated.net > <mailto:joh...@pixelated.net>> > >> *To:* Neil Tompkins <neil.tompk...@googlemail.com > <mailto:neil.tompk...@googlemail.com>> > >> *Cc:* [MySQL] <mysql@lists.mysql.com <mailto:mysql@lists.mysql.com>> > >> *Sent:* Monday, October 10, 2011 4:13 PM > >> *Subject:* Re: Fwd: Large insert query gives MySQL server gone away > >> > >> Max packet size? > >> > >> On Oct 10, 2011 6:12 PM, "Neil Tompkins" <neil.tompk...@googlemail.com > <mailto:neil.tompk...@googlemail.com>> > >> wrote: > >> > >> > >>> As per the subject we've a large insert query that gives up the error > >> MySQL server has gone away when we try to execute it. Any ideas why ? > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > http://lists.mysql.com/mysql?unsub=joh...@pixelated.net > >> > >> > >> > > > > -- > > Mit besten Grüßen, Reindl Harald > the lounge interactive design GmbH > A-1060 Vienna, Hofmühlgasse 17 > CTO / software-development / cms-solutions > p: +43 (1) 595 3999 33 <tel:%2B43%20%281%29%20595%203999%2033>, m: +43 > (676) 40 221 40 > <tel:%2B43%20%28676%29%2040%20221%2040> > icq: 154546673, http://www.thelounge.net/ > > http://www.thelounge.net/signature.asc.what.htm > > -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
