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