|
|
Posted by Phil Steer on 02/07/07 21:39
Thanks for your reply and your confirmation that my code looks OK. Hopefully
my hosting service (NetNation) will come to the same conclusion and will
quickly resolve any problem with the server (although, since it is a shared
server, I can't see how anyone elses' mySQL database would work correctly).
Regarding the use of a persistent connection, I can see the logic (reuse an
exisitng connection rather than create a new one) but my worry is that I
might still end up exceeding the connection limit (even though that
shouldn't happen) but with connections that never time out, and so the
problem never clears. I think I'll wait for the moment and see what
NetNation come back with.
Best Regards, Phil
"J.O. Aho" <user@example.net> wrote in message
news:52ttdsF1pnmmkU1@mid.individual.net...
> Phil Steer wrote:
>> Warning: mysql_connect(): User 'username' has exceeded the
>> 'max_connections'
>
> There ain't anything wrong with your code,as I can see, it should work as
> thought, would think the problem is at the server, I would suggest you try
> with mysql_pconnect() and see if you can reuse connections and that way
> get around troubles.
> http://www.php.net/manual/en/function.mysql-pconnect.php
Navigation:
[Reply to this message]
|