… it. Persistent connections were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough so you could recycle connections easily… MySQL versions. So persistent connections are not evil but they need some MySQL support to be properly implemented. Now with new “mysqlnd” driver for PHP…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here …your application and caching them. Persistent Connections Ajax applications with frequent case of one query per request make persistent connections relevant again. Automatic …
Comment: Are PHP persistent connections evil ?
January 17, 2007 By 31 Comments
… expensive than with MySQL. The good news is that SQL Relay’s performance here is comparable to PHP‘s persistent connections. The reason is because SQL Relay has already established X number of Oracle (or MySQL) connections and strives…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 28 Comments
… of MySQL connections quicker than you expected but it also frequently indicates serious problems in the application. If you do not use persistent connections… know any debugger which can connect to PHP process or apache with mod_php and provide backtrace in PHP terms not the one for…
Post: PHP Sessions - Files vs Database Based
March 27, 2007 By 38 Comments
… user on database level. If you change to store PHP sessions in MySQL instead this effect may be no more true and… to your current MySQL Sessions system without need to change how it works internally. If you do not use persistent connections you even do not have to release lock – as soon as connection is closed the lock is…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… also note for many PHP applications abstraction layer is not the main performance problem, also benefit from persistent connections can be much more… by people with traditional database background. Things are different with MySQL. There are many successful applications, using tens of thousands of…
Comment: Why do you need many apache children ?
February 6, 2007 By 15 Comments
… PHP Connections a while back http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ In reality I think persistent connections … close relative of persistent connections – connection pooling is almost always used. Connection creation is not as expensive in MySQL but it …
Comment: HandlerSocket on SSD
April 6, 2011 By 9 Comments
… lookups in Perl/PHP, I hit an almost identical limit (10,500), and then got failed connects… So using persistent connection objects for both MySQLi and HandlerSocket access methods I achieved 40,000 qps via MySQL (avg but…
Comment: HandlerSocket on SSD
November 2, 2010 By 9 Comments
… lookups in Perl/PHP, I hit an almost identical limit (10,500), and then got failed connects… So using persistent connection objects for both MySQLi and HandlerSocket access methods I achieved 40,000 qps via MySQL (avg but…
Comment: Wishes for new "Pure PHP" MySQL driver
October 30, 2006 By 17 Comments
… with frequent case of one query per request make persistent connections relevant again.” Persistent connections were irrelevant? I can see where they’d incur… in the PHP/MySQL world that persistent connections were a bad thing. I would think with appropriate limits on the maximum number of persistent connections, Apache…
