MySQL, PHP, and persistent connections

From: Date: Wed, 21 Jun 2000 17:02:23 +0000
Subject: MySQL, PHP, and persistent connections
Groups: php.db 
Request: Send a blank email to php-db+get-550@lists.php.net to get a copy of this message
Hi all, We're using mysql_pconnect() for our db connections, and have seen a few strange items, one of them being the apparent non-reuse of existing connections (persistent connections are allowed). Has anyone else seen similar behavior? Our wait_timout is set to 8 hours (too high?), and max_connections to 250 (too low?) Also, is the overhead in making the connections great enough to warrant persistent connections, or would we be better off with normal connections? What's the load on the machine for keeping connections open (memory constraints, etc). versions: PHP 3.0.12 MySQL 3.22.32 Thanks, any feedback would be appreciated.. Michael ************************************* Michael Tanoviceanu Web Developer, Soundbreak.com mtanoviceanu@soundbreak.com (310) 358-2100 phone (310) 358-2199 fax *************************************

« previous php.db (#550) next »