[TYPO3-Performance] MySQL connection slow?

Dan Osipov dosipov at phillyburbs.com
Tue Nov 18 15:00:02 CET 2008


Yes, I tested it with both on and off, and found that when ots on the 
connection is not closed. So its off.

The server is under a high load from other applications. I will try to 
get a dedicated server, and test it out.

Dan Osipov
Calkins Media
http://danosipov.com/blog/

Dmitry Dulepov wrote:
> Hi!
> 
> Olivier Dobberkau wrote:
>> i am not sure if p_connects can help?
> 
> Btw, good idea! Yes, it will help if it is turned off :D Otherwise
> it will cause lots of hanging resources and increased memory usage,
> which will end up in swapping :D Persistent connections do not free
> resources when PHP script ends. Thus any non–closed recordset will
> still stay in memory. Therefore it is not recommended to use
> persistent connections in PHP. PHP documentation is wrong about it.
> People, who written it, never checked how it really works :)
> 
> This is the first setting I check when I do performance reviews for
> web sites :)
> 


More information about the TYPO3-Performance mailing list