List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:October 12 2011 1:43pm
Subject:Re: Large insert query gives MySQL server gone away
View as plain text  
you must know how big your data are

or take a testserver and play around with increase the
value step for step - we are using 200M because it
is only relevant for import dumps here what does not
happen parallel and there is enough memory

Am 12.10.2011 15:40, schrieb Tompkins Neil:
> But how do I calculate such size ?
> 
> On Wed, Oct 12, 2011 at 2:38 PM, Reindl Harald <h.reindl@stripped
> <mailto: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
> <mailto: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
> <mailto:johnny@stripped>>
>     >> *To:* Neil Tompkins <neil.tompkins@stripped
> <mailto:neil.tompkins@stripped>>
>     >> *Cc:* [MySQL] <mysql@stripped
> <mailto: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 <mailto: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 <tel:%2B43%20%281%29%20595%203999%2033>, m: +43
> (676) 40 221 40
>     <tel:%2B43%20%28676%29%2040%20221%2040>
>     icq: 154546673, http://www.thelounge.net/
> 
>     http://www.thelounge.net/signature.asc.what.htm
> 
> 

-- 

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


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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