May 25, 2012

Post: Are PHP persistent connections evil ?

As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which … – you could get much more problems with it. Persistent connections were added to PHP during times of MySQL 3.22/3.23… persistent connections are not evil but they need some MySQL support to be properly implemented. Now with new “mysqlnd” driver for PHP

Comment: Why do you need many apache children ?

… at PHP Connections a while back http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ In reality I think persistent connections… properly. For example in Java World the close relative of persistent connections – connection pooling is almost always used. Connection creation is…

Post: Wishes for new "Pure PHP" MySQL driver

… you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is FAQ . I’m to meet… application and caching them. Persistent Connections Ajax applications with frequent case of one query per request make persistent connections relevant again. Automatic…

Post: PHP Sessions - Files vs Database Based

… one of our customers. If you use file based sessions PHP will lock session file for whole script execution duration, which… all requests from the same sessions will be serialized on PHP level, which means they also will be serialized for single… change how it works internally. If you do not use persistent connections you even do not have to release lock – as…

Post: Database problems in MySQL/PHP Applications

… also note for many PHP applications abstraction layer is not the main performance problem, also benefit from persistent connections can be much… WHERE featured=1; Now populate List for IN on your PHP application: SELECT * FROM articles WHERE user_id IN(23,545… 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 ?

[...] – см., например, обсуждение в блоге Peter Zaitsev Are PHP persistent connections evil ?. Для решения проблемы и учитывая, что в случае с MySQL [...]

Comment: Are PHP persistent connections evil ?

[...] http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ [...]

Comment: Are PHP persistent connections evil ?

[...] 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 ?

[...] 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é [...]

Comment: Are PHP persistent connections evil ?

[...] 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é [...]