note 38124 added to function.mysql-close

From: Date: Tue, 09 Dec 2003 12:24:20 +0000
Subject: note 38124 added to function.mysql-close
Groups: php.notes 
Request: Send a blank email to php-notes+get-61679@lists.php.net to get a copy of this message
I have same problem. Linux Red Hat 9 with php 4.3.4 & mysql 4.0.16. A connection $link = mysql_connect($server, $db_user, $db_pass); for some reasons, which are unknown to me, is not always closed when called with mysql_close($link); I can quite often see it hanging in process list with status "sleep" for some looooooong seconds. I am trying to close it on other way by setting wait_timeout set to 30 seconds, but for busy sites it is a big issue, as resources are "sleeping" too ;-( ---- Manual Page -- http://www.php.net/manual/en/function.mysql-close.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+38124 Delete -- http://master.php.net/manage/user-notes.php?action=delete+38124&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+38124&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#61679) next »