News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Internet Super Hero Blog:
PHP 5.3 Persistent Connections with ext/mysqli
February 19, 2009 @ 09:31:33

The Internet Super Hero blog has posted some statistics comparing the connections per second that can be made with the newly introduced persistent connection support coming with PHP 5.3 in the mysqli (ext/mysqli) driver.

Persistent Connections have been a mixed bag. They can give you a significant performance boost by caching (pooling) connections although MySQL is already comparatively fast at establishing connections. However,connections are stored "as-is" in the cache. They are not "cleaned up".

The ext/mysqli driver takes care of this and a few other problems surrounding the persistent connections by cleaning up things like rolling back active transactions, unlocking tables, closing prepared statements and closing handlers. The trick is in a call to the C-API function mysql_change_user() (= COM_CHANGE_USER).

0 comments voice your opinion now!
mysqli ext driver persistent connection trouble solved statistic


blog comments powered by Disqus

Similar Posts

Matt Curry's Blog: Did You Guys Know About The CakePHP DebugKit?

Christopher Jones' Blog: OCI8 1.2.3 Patch is Available on PECL

Gonzalo Ayuso: Handling several PDO Database connections in Symfony2 through the DIC in PHP

Brian Swan's Blog: Using the Zend Framework and the PDO_SQLSRV Driver

Chris Jones' Blog: Using PHP OCI8 with 32-bit PHP on Windows 64-bit


Community Events





Don't see your event here?
Let us know!


podcast wordpress developer api install code language introduction community application list configure symfony interview series release library threedevsandamaybe laravel unittest

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework