List:General Discussion« Previous MessageNext Message »
From:Gary Smith Date:May 20 2009 4:24pm
Subject:RE: Large insert question
View as plain text  
Michael, 

Thanks.  Thats what I was looking for, I just couldn't remember what it was.

Gary

________________________________________
From: Michael Dykman [mdykman@stripped]
Sent: Wednesday, May 20, 2009 9:17 AM
To: Gary Smith
Cc: mysql@stripped
Subject: Re: Large insert question

On Wed, May 20, 2009 at 12:02 PM, Gary Smith <Gary@stripped> wrote:
> Hello,
>
> I'm working on a project that will be inserting very large text streams into a
> database.  They range from 100K to 100M.  I suspect that the average will be about 2M per
> insert.  This is a low volume (under 20 inserts per day).  I don't really need to optimize
> much on this but I had a question regarding max data per insert.  I know some time ago on
> another project I had to increase sometime to handle inserts over a certain size because
> of a default setting that limited the size of the data per connection.  Anyone know what
> setting I need to tweak to ensure that it can accept large inserts of this size?
>
> Thanks,
>
> Gary

As I recall, max_allowed_packet is what controls that limit.


--
 - michael dykman
 - mdykman@stripped

 - All models are wrong.  Some models are useful.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
Thread
Large insert questionGary Smith20 May
  • Re: Large insert questionMichael Dykman20 May
    • RE: Large insert questionGary Smith20 May