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]