[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