| Bug #3140 | Mysql can't auto close the timeout connections after a long time | ||
|---|---|---|---|
| Submitted: | 11 Mar 2004 1:47 | Modified: | 12 Mar 2004 15:00 |
| Reporter: | kang hongjiu | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | mysql-4.0.18 (Source distribution) | OS: | Linux (Linux e2p 2.4.22-1.2115.nptl #1) |
| Assigned to: | Dean Ellis | CPU Architecture: | Any |
[11 Mar 2004 1:52]
kang hongjiu
sorry I put a error place.:)
[12 Mar 2004 15:00]
Dean Ellis
I cannot repeat this with 4.0.19. Unless the connection explicitly changes its own session-level timeout, the connection is terminated once it exceeds the system-level timeout. You might have whatever you are using to connect check its timeouts to see if they are being overridden.
Description: I have set wait_timeout and interactive_timeout to 30 in the section mysqld of file /etc/my.cnf .And I also use the phpmyadmin show the mysql Variables,I can see the wait_timeout and interactive_timeout success to set the new value 30. After a long time(about one day) ,I use the phpmyqdmin to show the mysql Processes, I found it have many connections with Time>30 .But I use the phpmyadmin to kill one processes then the mysql will close all the connections with Time>30 .I am sure it is not the phpmyadmin bug. Some other msg: >C compiler: gcc (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1) >C++ compiler: g++ (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1) >Environment: <machine, os, target, libraries (multiple lines)> System: Linux e2p 2.4.22-1.2115.nptl #1 Wed Oct 29 15:42:51 EST 2003 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/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/3.3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux Thread model: posix Configure command: ./configure '--without-innodb' '--prefix=/usr/local/mysql' '--with-charset=gb2312' How to repeat: After a long time(about one day).