>Description: I have a program that takes a large select statement via mysql_use_result (programmed in Perl and DBI). It processes a number of records from this result set and then goes off to perform other activities.
When it returns to take more records from large result set I get error 2013 Lost Connection with MySQL server. It took me some amount of head scratching to realize that that a timeout was being hit! Would it be possible to put a log message in the case that a net_read_timeout or net_write_timeout has been hit? >Fix: I suspect somewhere in libmysql/net.c - which is where the timeouts are set. Would it be possible to have the client set these values via an SQL statement to explicitly increase the timeouts for those connections? Thanks a bunch! >Submitter-Id: <submitter ID> >Originator: Jay Lawrence >Organization: Jay Lawrence - 613-795-9169 - [EMAIL PROTECTED] Infonium Inc. - Open Source Information Management Strategies > >MySQL support: [none | licence | email support | extended email support ] >Synopsis: Please add server log message upon hitting net_read_timeout or >net_write_timeout >Severity: serious >Priority: >Category: mysql >Class: change-request >Release: mysql-3.23.45 >Server: /opt/iAlloy/bin/mysqladmin Ver 8.23 Distrib 3.23.45, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.45-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /opt/iAlloy/var/run/mysql/mysql.sock Uptime: 49 days 3 hours 29 min 3 sec Threads: 1 Questions: 133787 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 3 Queries per second avg: 0.032 >Environment: System: Linux www.infonium.com 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /opt/iAlloy/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-85) Compilation info: CC=' gcc' CFLAGS=' -O3 -mpentiumpro' CXX=' gcc' CXXFLAGS=' -O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Oct 30 2001 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x 1 root root 5724399 Oct 3 2001 /lib/libc-2.2.4.so -rw-r--r-- 1 root root 27314604 Oct 3 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Oct 3 2001 /usr/lib/libc.so Configure command: ./configure --datadir=/opt/iAlloy/share --enable-assembler=yes --enable-shared=yes --localstatedir=/opt/iAlloy/var/run/mysql --mandir=/opt/iAlloy/man --prefix=/opt/iAlloy --sysconfdir=/opt/iAlloy/etc/mysqld --with-berkeley-db '--with-comment=Apachetoolbox V2' --with-extra-charsets=complex --with-innodb=1 --with-mysqld-user=ia_mysqld --with-raid=1 --with-unix-socket-path=/opt/iAlloy/var/run/mysql/mysql.sock --------------------------------------------------------------------- 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