Re: Large insert query gives MySQL server gone away

2011-10-12 Thread Reindl Harald
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

Re: Large insert query gives MySQL server gone away

2011-10-12 Thread Tompkins Neil
But how do I calculate such size ? On Wed, Oct 12, 2011 at 2:38 PM, Reindl Harald 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,

Re: Large insert query gives MySQL server gone away

2011-10-12 Thread Reindl Harald
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 wrote: > >> Yeah, I think adjusting max packet size may be helpful, remember change >> that