… persistent-connections. The global variable long_query_time is checked when the connection is created, so if you are using a connection pool or persistent connections this will not be useful because it will not affect to the connections that were already…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… problem with persistent connections is using too many MySQL server connections. Some people simply do not realize you can increase max_connections variable and…. Lets talk now about why Persistent connections were disabled in mysqli extension. Even though you could misuse persistent connections and get poor performance that…
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…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… use persistent connections by default, so that a connection isn’t really closed when it’s closed; it’s kind of like a connection… connection is persisted from request to request within the same process, rather than being shared with whichever request needs a connection. Connection pools and persistent connections…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If you have connects timed in your… up and tearing down connections. Consider using persistent connections or connection pool at least for applications which are responsible for most of connections being created.
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 23 Comments
… connections waiting on connection instead of failing quickly and potentially connecting to different server, but that can be fixed by setting the client connect… limit and you should consider techniques to reduce number of connections. Namely persistent connections and connection pools might be good solution for many applications.
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… has couple of memcached connections. Few MySQL connections (to the same host, which if usually bad idea) and connection to some external web…
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 connections are good thing… if they are implemented properly. For example in Java World the close relative of persistent connections – connection pooling…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… easily recreated. Anything that needs to be persistent, store it more deliberately in a persistent database. Q: Can you compare / contrast this…: 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…
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… a certain point! The nice thing about persistent connections is that they reduce latency on the connect/disconnect/reconnect which, for Oracle, is…
