I have seem some sites code that actually open multiple connections to the same database..
If I am using php's mysql_connect() function, then every time a query is run this function gets run. Wouldn't this mean that for every query a new "connection" is opened to the same database?
thanks,
Eben
[EMAIL PROTECTED] wrote:
Suggestion.. make a small script called closeall.php .. basically it has some code to force closed the mysql connection opened (be sure to run a close for all openened handles)
I have seem some sites code that actually open multiple connections to the same database..
Add this file into php.ini under the script_prepend part (gets run after all other scripts are done) .. Perhaps something is getting left open/not closing properly?
On Thu, 17 Jul 2003, Eben Goodman wrote:
I run a site that gets a fair amount of traffic throughout the day. For days at a time the site runs smoothly, and then, at seemingly random intervals I get the mysql error "Too many connections". The only solution for this is to stop the mysql service and restart it. I changed the max_connections variable to allow for 300 connections instead of the default 100. When I view processes when the error occurs the process list is totally flooded with mysql processes.
I am using php to establish connections and using the mysql_connect() function, not mysql_pconnect. I used to use the pconnect function and it seemed to produce the Too many connections error more frequently. I'm at a bit of a loss with this, any tips on how to address this are greatly appreciated.
thanks,
Eben
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]