note 38124 added to function.mysql-close
| From: | zlosliwiec at wizaz dot pl | 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