On Wed, Oct 23, 2002 at 10:18:07PM +0100, Georgie Casey wrote:
> Im getting a too many connections error in my PHP pages at
> http://www.free-ringtones.tv. I presume this is from the MySQL server, and I
> know I access the database a lot for each page. So whats the solution to

MySQL has a default of either 50 or 100 concurrent connections.  Exceed it
and you'll get that error.  That parameter is configurable - if you run the
MySQL daemon itself.  If you use shared hosting, you may not be able to 
tweak it.

Do the pages -need- to be totally dynamic, or can you use the caching system
you mentioned?  If so, then wrap code that stats an HTML page for the time,
and if it's too old, update it.  Be sure to use file locking so you don't
clobber yourself.

Moreover, do you open one connection and re-use it in a page, or do you do
multiple opens and closes?  

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to