Fwd: Large insert query gives MySQL server gone away

> 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@m.gmane.o rg

Re: Fwd: Large insert query gives MySQL server gone away

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

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=johnny@pixelated.net

--0016e6563ab8a17df004aef9f078--

Re: Fwd: Large insert query gives MySQL server gone away

--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________________________________=
=0AFrom: Johnny Withers =0ATo: Neil Tompkins mpkins@googlemail.com>=0ACc: [MySQL] =0ASent: Monday=
, October 10, 2011 4:13 PM=0ASubject: Re: Fwd: Large insert query gives MyS=
QL server gone away Max packet size? On Oct 10, 2011 6:12 PM, "Ne=
il Tompkins" =0Awrote: =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 ? --=0AMySQL G=
eneral Mailing List=0AFor list archives: http://lists.mysql.com/mysql=0ATo =
unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Djohnny@pixelated.n=
et
--1403171591-569695616-1318288998=:79440--

Re: Fwd: Large insert query gives MySQL server gone away

--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 wrote:

> Yeah, I think adjusting max packet size may be helpful, remember change
> 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=johnny@pixelated.net
>
>
>

--20cf307d000a40f0f604af1a08d5--

Re: Large insert query gives MySQL server gone away

--------------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
> ?
>=20
> On Tue, Oct 11, 2011 at 12:23 AM, Angela liu wrote=
:
>=20
>> 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@pixelat=
ed.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/

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