> As per the subject we've a large insert query that gives up the error MySQ=
L 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=3Dgcdmg-mysql-2 [at] m.gmane.o rg

--0016e6563ab8a17df004aef9f078
Content-Type: text/plain; charset=ISO-8859-1

Max packet size?

On Oct 10, 2011 6:12 PM, "Neil Tompkins" <neil.tompkins [at] 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=johnny [at] pixelated.net

--0016e6563ab8a17df004aef9f078--

--1403171591-569695616-1318288998=:79440
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Yeah, I think adjusting max packet size may be helpful, remember change tha=
t value in both server and client=0A=0A=0A________________________________=
=0AFrom: Johnny Withers <johnny [at] pixelated.net>=0ATo: Neil Tompkins <neil.to=
mpkins [at] googlemail.com>=0ACc: [MySQL] <mysql [at] lists.mysql.com>=0ASent: Monday=
, October 10, 2011 4:13 PM=0ASubject: Re: Fwd: Large insert query gives MyS=
QL server gone away=0A=0AMax packet size?=0A=0AOn Oct 10, 2011 6:12 PM, "Ne=
il Tompkins" <neil.tompkins [at] googlemail.com>=0Awrote:=0A=0A=0A> As per the s=
ubject we've a large insert query that gives up the error=0AMySQL server ha=
s gone away when we try to execute it.=A0 Any ideas why ?=0A=0A--=0AMySQL G=
eneral Mailing List=0AFor list archives: http://lists.mysql.com/mysql=0ATo =
unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Djohnny [at] pixelated.n=
et
--1403171591-569695616-1318288998=:79440--

--20cf307d000a40f0f604af1a08d5
Content-Type: text/plain; charset=ISO-8859-1

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 <yyll2087 [at] 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 [at] pixelated.net>
> *To:* Neil Tompkins <neil.tompkins [at] googlemail.com>
> *Cc:* [MySQL] <mysql [at] 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 [at] 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=johnny [at] pixelated.net
>
>
>

--20cf307d000a40f0f604af1a08d5--

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

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 [at] 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 [at] pixelated.net>
>> *To:* Neil Tompkins <neil.tompkins [at] googlemail.com>
>> *Cc:* [MySQL] <mysql [at] 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 [at] 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 [at] pixelat=
ed.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


--------------enig23CF8063D486FE2AE5C753A4
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/

iEYEARECAAYFAk6VmDwACgkQhmBjz394Ankw+ACgnFvwLFL9zt8HTUL7XJ5r mojX
nFkAoILqdoOAUm0R9ics5kqHJiHOZAyT
=H/Tn
-----END PGP SIGNATURE-----

--------------enig23CF8063D486FE2AE5C753A4--