Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: Re: Large insert query gives MySQL server gone away

Posted on 2011-10-12 15:40:30 by Tompkins Neil

--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 <h.reindl@thelounge.net>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 <yyll2087@yahoo.com> wrote=
:
> >
> >> Yeah, I think adjusting max packet size may be helpful, remember chang=
e
> >> that value in both server and client
> >>
> >> ------------------------------
> >> *From:* Johnny Withers <johnny@pixelated.net>
> >> *To:* Neil Tompkins <neil.tompkins@googlemail.com>
> >> *Cc:* [MySQL] <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.tompkins@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=3Djohnny@pixelated.net
> >>
> >>
> >>
> >
>
> --
>
> Mit besten GrüÃčen, Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofm=FChlgasse 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--

Report this message

#2: Re: Large insert query gives MySQL server gone away

Posted on 2011-10-12 15:43:56 by Reindl Harald

--------------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 <h.reindl@thelounge.net =
<mailto:h.reindl@thelounge.net>> 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 <yyll2087@yahoo.com =
<mailto:yyll2087@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 <johnny@pixelated.net <mailto:johnny@pixe=
lated.net>>
> >> *To:* Neil Tompkins <neil.tompkins@googlemail.com <mailto:neil.t=
ompkins@googlemail.com>>
> >> *Cc:* [MySQL] <mysql@lists.mysql.com <mailto:mysql@lists.mysql.c=
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" <neil.tompkins@googlema=
il.com <mailto:neil.tompkins@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=3Djohnny@p=
ixelated.net
> >>
> >>
> >>
> >
>=20
> --
>=20
> Mit besten GrüÃčen, Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofm=FChlgasse 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/
>=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=FChlgasse 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--

Report this message