[TYPO3-Performance] MySQL connection slow?

Dan Osipov dosipov at phillyburbs.com
Tue Nov 18 15:31:47 CET 2008


Here is a question, that was probably asked before:
mysql vs mysqli
Which one is better (faster & stable)?

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

Dan Osipov wrote:
> 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