…). This post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple… (I’m looking at you, Java). And many others use persistent connections by default, so that a connection isn’t really closed when it…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… and slides. Q: Are there similar plugins or resources for Java based applications? A: The recent versions of Connector/J include…? A: 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 faster…
Comment: Why do you need many apache children ?
February 6, 2007 By 15 Comments
… example in Java World the close relative of persistent connections – connection pooling is almost always used. Connection creation is not as expensive in MySQL but it… connections for MySQL to handle – which is another reason people frequently avoid persistent connections. It is overhead of dealing with these thousands of stale connection…
