Hi, I'm having some trouble with a sizable (but certainly not huge) multi-row insert statement. I can successfully execute the query with up to 7365 rows, but any more and it fails (ERROR 2006: MySQL server has gone away). More complete info:
Total working query size: 1047426 bytes wait_timeout variable: 28800 Table type: MyISAM Columns: 13, including: 4 VARCHAR, 7 INT (varying sizes), 1 TEXT, 1 DATETIME. This fails through the mysql client copy/paste, mysql client using a piped file (mysql <filename), and through Perl DBI. Server uname -a: Linux test-db 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Distro: Red Hat Linux release 7.2 (Enigma) MySQL version: 3.23.52-log I'd be appreciative of any advice regarding limits that may exist on the amount of data that can be run through a single multi-row insert. The easy fix for me right now is to split into multiple multi-row inserts (splitting at 1000 rows/query seems to be working fine), but I'd rather get the proper solution or file a bug if need be. Cheers, Chris --------------------------------------------------------------------- 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
