[Typo3-debian] mysql_pconnect(): Too many connections

[Lars E. D. Jensen]

Jordan van Bergen wrote:

> Hi All,
> 
> Nothing to do with the DEBIAN installation & TYPO3 of course, but we are
> getting the following error on a production server:
> 
> Warning: mysql_pconnect(): Too many connections in
> /var/lib/typo3/typo3_src-3.7.0/t3lib/class.t3lib_db.php on line 813
> 
> The server is hosting like 25 typo3 websites and all of them don't have
> that much visitors. If I search with google everybody is telling not to
> use mysql_pconnect() (persistent) but mysql_connect instead.
> 
> Why is using TYPO3 the mysql_pconnect() ? and does anyone know how to set
> some settings so you won't get the above error message?

MySQL has a default limit of connections. This limit can be raised with
MySQL configuration.
If you are using TYPO3 3.7.0 you can force TYPO3 to use mysql_connect in
"Install Tool", but this will probably cause more resource usage on the
server. As a solution to this you could use some kind of sql relay so
connections are reused and not opened/closed constantly. A sql relay is
pretty advanced to handle but is a good way to go.

-- 
Med venlig hilsen / Best regards
Lars E. D. Jensen
ledj-typo3 at dcmedia.biz