Re: Large insert query gives MySQL server gone away

--20cf307f356ee0867904af1a2ab1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

But how do I calculate such size ?

On Wed, Oct 12, 2011 at 2:38 PM, Reindl Harald wrot=
e:

> 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 increase=
d
> to
> > ?
> >
> > On Tue, Oct 11, 2011 at 12:23 AM, Angela liu wrote=
:
> >
> >> Yeah, I think adjusting max packet size may be helpful, remember chang=
e
> >> that value in both server and client
> >>
> >> ------------------------------
> >> *From:* Johnny Withers
> >> *To:* Neil Tompkins
> >> *Cc:* [MySQL]
> >> *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" >
> >> 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=3Djohnny@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, m: +43 (676) 40 221 40
> icq: 154546673, http://www.thelounge.net/
>
> http://www.thelounge.net/signature.asc.what.htm
>
>

--20cf307f356ee0867904af1a2ab1--

Re: Large insert query gives MySQL server gone away

--------------enig9BB4EA982F6D1FE6882198C1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 ?
>=20
> On Wed, Oct 12, 2011 at 2:38 PM, Reindl Harald > wrote:
>=20
> as big as you largest query
>=20
> Am 12.10.2011 15:30, schrieb Tompkins Neil:
> > Do you have any recommendations as to what size this should be in=
creased 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 value in both server and client
> >>
> >> ------------------------------
> >> *From:* Johnny Withers lated.net>>
> >> *To:* Neil Tompkins ompkins@googlemail.com>>
> >> *Cc:* [MySQL] om>>
> >> *Sent:* Monday, October 10, 2011 4:13 PM
> >> *Subject:* Re: Fwd: Large insert query gives MySQL server gone a=
way
> >>
> >> Max packet size?
> >>
> >> On Oct 10, 2011 6:12 PM, "Neil Tompkins" il.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=3Djohnny@p=
ixelated.net
> >>
> >>
> >>
> >
>=20
> --
>=20
> 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/
>=20
> http://www.thelounge.net/signature.asc.what.htm
>=20
>=20

--=20

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


--------------enig9BB4EA982F6D1FE6882198C1
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk6VmZwACgkQhmBjz394AnkJcwCfdH5xnkpMCa+Zi3u88oML p+34
xAcAoJjfoKM+3dgMVcvWDXLWPSCrHvng
=c6AM
-----END PGP SIGNATURE-----

--------------enig9BB4EA982F6D1FE6882198C1--