>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
