Hello Peter On 2006-10-05 Peter Gershkovich wrote: > Problem: > > When we run a large query (returns 4000 records) on a firewalled > XServe (OS X 10.4) against Mysql database (outside firewall) on an > AIX (Version 5.2) machine the database server intermittently > generates the following errors: > > ERROR 2006 (HY000): MySQL server has gone away
If the result is large, check if max_allowed_packet is set to at least 16MB or so in both, the client and the serve (see docs how to configure variables best). Also, a gone away server normally means a crash of mysqld for which some debugging output is written on stderr by mysqld. In Debian Linux this is sent to syslog, check where your output has gone to. Third, try experimenting if the same problem occurs if you use "LIMIT 10" or if the query takes a very long time *before* the output is sent to the client. That helps identifying which limit or timeout you've hit. A firewall normally only lead to trouble if either the query takes say 5min before the first result row comes and the firewall things that the connection is timed out or if you have an enormous number of simultaneous connections and some connection tracking table runs full. bye, -christian- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
