Please help! in PHP mySQL, the use of SELECT FOR UPDATE and SELECT LOCK IN …, so there is an auto mysql_close.(Which would rollback your transaction in the SELECT) With a persistent connection, may be it… pending, but there is no way to store the connection persistent link resource in a session or anywhere else, so there…
Comment: Are PHP persistent connections evil ?
November 14, 2006 By 32 Comments
[...] At the MySQL Performance Blog there is a very interesting article about PHP’s persistent MySQL connections and why there are not enabled by default in the mysqli extension. [...]
Comment: Why do you need many apache children ?
February 6, 2007 By 15 Comments
…at PHP Connections a while back http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ In reality I think persistent …many man thousands of connections for MySQL to handle – which is another reason people frequently avoid persistent connections. It is overhead of…
Comment: HandlerSocket on SSD
April 6, 2011 By 9 Comments
… limit when testing Handlersocket with both PHP and Perl, under certain conditions. i.e not persisting the connection / index objects. However, I… 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
… limit when testing Handlersocket with both PHP and Perl, under certain conditions. i.e not persisting the connection / index objects. However, I… 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: Are PHP persistent connections evil ?
December 28, 2009 By 32 Comments
… ago, it’s in a well-designed web application where persistent connections are beneficial. Badly-designed applications don’t use them… design themselves: having far too many client processes (think mod_php); forgetting to unlock tables and not cleaning up temporary tables… to 3000 threads), with fastCGI + PHP (1 process, 24 children), connecting to mysql via Unix sockets with persistent connections. I have not had…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… also note for many PHP applications abstraction layer is > not the main performance problem, also benefit from persistent > connections can be much… by people with traditional database background. > Things are different with MySQL. Good design will help dictate how many tables are required…
Comment: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… application chance of going from MySQL to something else is probably less than rewriting them from PHP to something else 
4) It… implement connection pooling daemon implemented as a proxy for MySQL protocol supporting persistent connections would automatically allow to take advantage of it…
Comment: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
February 3, 2013 By 8 Comments
… the bug of RPM rhel5 packages conflicting with mysql/mysql-server/mysql-libs is still persistent in some form, I’ll try finding the… rpm_check_debug ERROR with rpm_check_debug vs depsolve: mysql conflicts with Percona-XtraDB-Cluster-client-5.5.29-23… report this error in http://bugs.centos.org/set_project.php?project_id=16&ref=http://bugs.centos.org/bug_report…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main… would be really cool if someone would come up with “Persistent DRAM” memory device, which would offer some small amount, say… – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent…
