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