[TYPO3-Performance] MySQL connection slow?

Dan Osipov dosipov at phillyburbs.com
Tue Nov 18 15:38:21 CET 2008


* Correction: For TYPO3. Can I use mysqli with TYPO3, or is it not 
compatible?

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

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