Chris,
Friday, September 20, 2002, 1:55:39 AM, you wrote:
CT> I'm having some trouble with a sizable (but certainly not huge)
CT> multi-row insert statement. I can successfully execute the query with
CT> up to 7365 rows, but any more and it fails (ERROR 2006: MySQL server has
CT> gone away). More complete info:
CT> Total working query size: 1047426 bytes
CT> wait_timeout variable: 28800
CT> Table type: MyISAM
CT> Columns: 13, including: 4 VARCHAR, 7 INT (varying sizes), 1 TEXT, 1
CT> DATETIME.
CT> This fails through the mysql client copy/paste, mysql client using a
CT> piped file (mysql <filename), and through Perl DBI.
CT> Server uname -a:
CT> Linux test-db 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown
CT> Distro:
CT> Red Hat Linux release 7.2 (Enigma)
CT> MySQL version:
CT> 3.23.52-log
CT> I'd be appreciative of any advice regarding limits that may exist on the
CT> amount of data that can be run through a single multi-row insert. The
CT> easy fix for me right now is to split into multiple multi-row inserts
CT> (splitting at 1000 rows/query seems to be working fine), but I'd rather
CT> get the proper solution or file a bug if need be.
You can also get this error if the size of sent packet is bigger than
max_allowed_packet:
http://www.mysql.com/doc/en/Gone_away.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
