[Typo3-debian] mysql_pconnect(): Too many connections
Jordan van Bergen
jordanvanbergen at gmail.com
Wed Feb 23 10:01:31 CET 2005
Hi,
> # If you have problems with too many connections or a lot of
> # idle connections, try this
> # timeout values in s
> #set-variable = max_connections=250
> #set-variable = interactive_timeout=180
> #set-variable = wait_timeout=180
> #
> # Here you can see queries with especially long duration
> #log-slow-queries = /var/log/mysql/mysql-slow.log
> I don't give much on out-of-the-box values, because traffic and
> performance often varies between hosts and even changes on the same host
> by time. You should find some values between 1) stopping your errors
> (raise max_connections, limit timeouts) and 2) don't give up performance
> (don't raise max_connections/timeouts too high).
> Benchmarking is always a good way, but often not trivial.
I have set the above settings. Let's see if this will help the problem go
away.
Regards
Jordan van Bergen
jordanvanbergen at gmail.com
More information about the TYPO3-debian
mailing list