[RESOLVED] mysql too many connections errors...

[stevesweetland]

i understand this would be because there simply isnt enough memory to allow mysql to have as many connections as are being created.

my simple question, is that will it make a noticeable difference, if i stopped being lazy, and closed all the open connections on a script, once its finished?

IE i use database objects, so at the bottom of any script that uses one or two database objects, just put

db->finish() (which is the free memory of resultwotsit function).

for each database object?

[TheDefender]

From the PHP Manual for [man]mysql_close[/man]:

Freeing resources
Due to the reference-counting system introduced with PHP 4's Zend Engine, it is automatically detected when a resource is no longer referred to (just like Java). When this is the case, all resources that were in use for this resource are made free by the garbage collector. For this reason, it is rarely ever necessary to free the memory manually by using some free_result function.
(The exception to this is if you use persistent connections)

So to answer your question, no I don't think it would make any difference.

[stevesweetland]

incidentally - i fixed this by changing my database connection method from

mysql_pconnect() < persistent connection

to

mysql_connect()