Re: [Phplib-users] SQL: more than 'max_user_connections'

[Lindsay H. <fm...@fm...>]

Thus spake so...@gm... on Thu, Feb 20, 2003 at 09:23:46AM CST
> > You have to lower the mysql wait_timeout value from the default 8 h to
> > 1-5 minutes mas, so stale persistent connections will be freed
> 
> on my server persistent connections are impossible
> 
> > This is a mysql issue.  You can change max_user_connections in your
> > my.cnf file.  Do a locate for it on your system.  This is often set
> > to 0 (no limit) but may be set to a specific value which is too low
> > for your situation.
> 
> max_user_connections is set to 0 (no limit)

Hmmm.  This smells like a bug.  You might try setting max_user_connections
to something extremely large, like 1000, and see if this helps.
 
> can I change someting in my PHP Scripts? (close DB)

using connect() rather than pconnect() might help, but isn't this hard-coded
into the phplib database object scripts?  Lowering the wait_timeout for
pconnect() might also help, but if mysql isn't honoring the
max_user_connections setting then who knows.  If your server isn't setting
up persistent connections on a pconnect call then this might not help.

-- 
Lindsay Haisley       | "Everything works    |     PGP public key
FMP Computer Services |       if you let it" |      available at
512-259-1190          |    (The Roadie)      | <http://www.fmp.com/pubkeys>
http://www.fmp.com    |                      |