As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is …. Persistent connections were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough so you could recycle connections…
Comment: Why do you need many apache children ?
February 6, 2007 By 15 Comments
… wrote at PHP Connections a while back http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ In reality I think persistent connections are good thing… if they are implemented properly. For example in Java World the close relative of persistent connections – connection pooling…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 28 Comments
… MySQL connections quicker than you expected but it also frequently indicates serious problems in the application. If you do not use persistent connections and you have connection in Sleep stage for 600 seconds what could it… 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: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is FAQ . I’m to meet… your application and caching them. Persistent Connections Ajax applications with frequent case of one query per request make persistent connections relevant again. Automatic load…
Post: PHP Sessions - Files vs Database Based
March 27, 2007 By 38 Comments
… one of our customers. If you use file based sessions PHP will lock session file for whole script execution duration, which… based session behavior with MySQL Sessions ? If you have dedicated connection to session database and use Innodb tables for your session… 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… which may do very little work and formating, so database connection may become the issue. Caching should be good help in… growth it will however start to crawl. So developing you PHP applications use test database with reasonable amount of data in…
Comment: Are PHP persistent connections evil ?
June 20, 2009 By 31 Comments
[...] – Ñм., например, обÑуждение в блоге Peter Zaitsev Are PHP persistent connections evil ?. Ð”Ð»Ñ Ñ€ÐµÑˆÐµÐ½Ð¸Ñ Ð¿Ñ€Ð¾Ð±Ð»ÐµÐ¼Ñ‹ и учитываÑ, что в Ñлучае Ñ MySQL [...]
Comment: Are PHP persistent connections evil ?
May 13, 2008 By 31 Comments
[...] http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ [...]
Comment: Are PHP persistent connections evil ?
March 15, 2008 By 31 Comments
[...] que conexão persistente com o banco de dados é cafonérrimoooo, para saber, leia este artigo: Are PHP persistent connections evil?. O pessoal do suporte técnico do Onda me indicou o artigo (adoro quando provam que eu estou [...]
Comment: Are PHP persistent connections evil ?
January 12, 2008 By 31 Comments
[...] mysqli pour des problèmes de performances et de stabilité (voir ce post très intéressant : http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/). Apparemment, ces problèmes ont été résolus avec mysqlnd puisque cette fonctionnalité [...]
