Repost: Persistent connections is not persistent

From: Date: Wed, 12 Sep 2001 21:07:24 +0000
Subject: Repost: Persistent connections is not persistent
Groups: php.db 
Request: Send a blank email to php-db+get-12385@lists.php.net to get a copy of this message
Actually I don't know if this problem is a PHP-, an Apache- or a MySQL-issue, but in this forum probably a lot is using the same combination of servers, so probably someone has an experience to share with me. I'm running a PHP-build website (using PHP 4.0.6) and an Apache-server (1.3.20) on a Windows 2000-server. PHP is running as a Apache-module. Most of pages is password-protected using .htaccess-files. The website is connecting to a MySQL-server (3.23.41) using pconnect(). The setup of the MySQL-server is the default in regard of the max_connections-variable (set to 100). As far as I understood, the mysql_pconnect-mechanism should reuse earlier connections made by the same user. However, I can see, that very often just a reload of a page is opening a new process, and suddenly the max_connections-limit is reached: The user is getting 'Too many connections'-errors. The SQL-server is restarted and soon after the user get 'MySQL Server has gone away'-error. On more reload of the page makes a new connection. Before I decide to raise the 'max-connections'-setting, I would be nice to hear from anyone with a similar experience. Is there a better solution, for instance using mysql_connect() and mysql_close() instead of mysql_pconnect. Or is this just a wellknown problem in MySQL? Anyone?

« previous php.db (#12385) next »