Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

perfmon tcp connections, WwWXxX, udp high ports, d-link extract firmware dsl-2750u, wwwwxxxxx.2G, yxxxcom, WWWXXX, ftp://192.168.100.100, wwwxxx 100, www.xxxcon

Links

XODOX
Impressum

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

Posted on 2011-10-11 01:11:52 by Tompkins Neil

> 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

Report this message

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

Posted on 2011-10-11 01:13:33 by Johnny Withers

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

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

--0016e6563ab8a17df004aef9f078--

Report this message

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

Posted on 2011-10-11 01:23:18 by Angela liu

--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 <johnny@pixelated.net>=0ATo: Neil Tompkins <neil.to=
mpkins@googlemail.com>=0ACc: [MySQL] <mysql@lists.mysql.com>=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" <neil.tompkins@googlemail.com>=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--

Report this message

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

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

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

--20cf307d000a40f0f604af1a08d5--

Report this message

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

Posted on 2011-10-12 15:38:04 by Reindl Harald

--------------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 <yyll2087@yahoo.com> 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 <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@pixelat=
ed.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, 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--

Report this message