MySQL too many connection problems

From: Date: Tue, 13 Nov 2001 21:57:18 +0000
Subject: MySQL too many connection problems
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-14305@lists.php.net to get a copy of this message
Hi folks-- I'm working on an installation of phpshop 0.6x and have started getting "too many connections to the database" errors whenever I work with it for any length of time. I have a heavily database-driven and busy site calling on three databases. Having heard that mysql_pconnect is better to use than mysql_connect, I thought maybe my other scripts using the latter were causing the problem so I moved the busiest pages from mysql_connect to mysql_pconnect. No go. The problem only occurs when I'm using phpshop and affects the entire site, not just the phpshop pages. Sometimes loading my (non-phpshop) home page restarts things, sometimes I have to go in and reboot mysqld. I have customized the phpshop code but I haven't done any customization to the way phpshop connects to the database. Ideas? Many thanks, Lynn

« previous php.db (#14305) next »