Large insert question
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Large insert question
Michael, Thanks. Thats what I was looking for, I just couldn't remember what it was. Gary From: Michael Dykman [mdyk...@gmail.com] Sent: Wednesday, May 20, 2009 9:17 AM To: Gary Smith Cc: mysql@lists.mysql.com Subject: Re: Large insert question On Wed, May 20, 2009 at 12:02 PM, Gary Smith g...@primeexalia.com 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 - mdyk...@gmail.com - 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=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Large insert question
On Wed, May 20, 2009 at 12:02 PM, Gary Smith g...@primeexalia.com 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 - mdyk...@gmail.com - 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=arch...@jab.org