<?xml version="1.0"?>
<rss version="2.0">
  <channel>
    <title>PHPDeveloper.org</title>
    <link>http://www.phpdeveloper.org</link>
    <description>Up-to-the Minute PHP News, views and community</description>
    <language>en-us</language>
    <pubDate>Sat, 18 May 2013 06:12:27 -0500</pubDate>
    <ttl>30</ttl>
    <item>
      <title><![CDATA[Internet Super Hero Blog: PHP 5.3: Persistent Connections with ext/mysqli]]></title>
      <guid>http://www.phpdeveloper.org/news/11981</guid>
      <link>http://www.phpdeveloper.org/news/11981</link>
      <description><![CDATA[<p>
The Internet Super Hero blog has <a href="http://blog.ulf-wendel.de/?p=211">posted some statistics</a> comparing the connections per second that can be made with the newly introduced persistent connection support coming with PHP 5.3 in the <a href="http://php.net/mysqli">mysqli (ext/mysqli)</a> driver.
</p>
<blockquote>
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".
</blockquote>
<p>
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  <a href="http://dev.mysql.com/doc/refman/6.0/en/mysql-change-user.html">mysql_change_user() (= COM_CHANGE_USER)</a>.
</p>]]></description>
      <pubDate>Thu, 19 Feb 2009 09:31:33 -0600</pubDate>
    </item>
  </channel>
</rss>
