List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:October 12 2011 1:40pm
Subject:Re: Large insert query gives MySQL server gone away
View as plain text  
But how do I calculate such size ?

On Wed, Oct 12, 2011 at 2:38 PM, Reindl Harald <h.reindl@stripped>wrote:

> 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 increased
> to
> > ?
> >
> > On Tue, Oct 11, 2011 at 12:23 AM, Angela liu <yyll2087@stripped> wrote:
> >
> >> Yeah, I think adjusting max packet size may be helpful, remember change
> >> that value in both server and client
> >>
> >> ------------------------------
> >> *From:* Johnny Withers <johnny@stripped>
> >> *To:* Neil Tompkins <neil.tompkins@stripped>
> >> *Cc:* [MySQL] <mysql@stripped>
> >> *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@stripped>
> >> 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=1
> >>
> >>
> >>
> >
>
> --
>
> 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
>
>

Thread
Fwd: Large insert query gives MySQL server gone awayNeil Tompkins11 Oct
  • Re: Fwd: Large insert query gives MySQL server gone awayJohnny Withers11 Oct
    • Re: Fwd: Large insert query gives MySQL server gone awayAngela liu11 Oct
      • Re: Fwd: Large insert query gives MySQL server gone awayTompkins Neil12 Oct
        • Re: Large insert query gives MySQL server gone awayReindl Harald12 Oct
          • Re: Large insert query gives MySQL server gone awayTompkins Neil12 Oct
            • Re: Large insert query gives MySQL server gone awayReindl Harald12 Oct