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…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…. The application connects to the database using persistent connection technique to avoid creating new connections for every request so it just recycle old connections. The… with the name ML*. Here is the problem. Until the connection is closed those files won’t disappear, even after committing… report to follow this issue: http://bugs.mysql.com/bug.php?id=66237
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you can still…: Connecting to a MySQL database isn’t a great performance cost, compared to the queries themselves. If it is, then persistent connections can help with that. By the way, we’re seeing reports that MySQL 5.6 non-persistent connections are much…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 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 13 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: 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…
Comment: Are PHP persistent connections evil ?
January 17, 2007 By 32 Comments
… of Oracle databases. Persistent connections are certainly evil once you have enough Web servers maintaining X number of persistent connections per Web server to… comparable to PHP‘s persistent connections. The reason is because SQL Relay has already established X number of Oracle (or MySQL) connections and strives…
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 managed… lookups in Perl/PHP, I hit an almost identical limit (10,500), and then got failed connects… So using persistent connection objects for both…
