… timeout is other story 
Handling Keep Alive – Keep alive connection in Apache keeps child busy and especially if you have KeepAliveTimeout high… as requiring a lot of connections to the database and then if database slows down all these hundreds of connections may start running queries…
Post: Why do you need many apache children ?
February 5, 2007 By 15 Comments
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
… with most other databases. Not only connects are expensive but you also may run into the trouble establishing number of connections you need. The problem is there can be only so many connections active between Host “Apache” and Host “MySQL”: Port 3306 as connection…
Comment: Why do you need many apache children ?
February 5, 2007 By 15 Comments
… dynamic data, a persistent connection can actually hurt scalability because the database connection resource gets tied to the Apache child process and cannot be… for connecting to MySQL is relatively low compared to other databases, I usually recommend not using persistent connections with Apache web servers so that database connections…
Comment: Debugging sleeping connections with MySQL
May 20, 2009 By 28 Comments
…apache connections start to wait on slow mysql queries 5. apache connections take longer to close 6. more apache connections are opened 7. with each apache … a connection to the database only when the first query occurs – e.g: function query ($query) { if (!mysql_connection) mysql_connect(); return …
Post: Speedup your LAMP stack with LigHTTPD
May 21, 2006 By 14 Comments
… can limit number of Apache children (MaxClients 50) , disable keep alive (KeepAlive Off) and relay on Operation System connection buffering (ListenBacklog 1024… database server slowdowns may cause overload. Use LingerD. I have not ever used this one, but in theory it should relieve apache from closing connection which is part of the job, however it does…
Comment: Are PHP persistent connections evil ?
January 17, 2007 By 31 Comments
… a production environment to pool connections between 12 Apache Web servers and a handful of Oracle databases. Persistent connections are certainly evil once you… number of persistent connections per Web server to your database(s). Pretty soon, you’ve got thousands of connections to the database, most of…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… and might wander into Apache, networking config, caching layers, etc…everything people throw at databases Many people assume their… Variable_name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 |…
Comment: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
… databases, and then use persistent connections. Now, the blog, the user counter, the ad program and the forum all make their own connection. So, each Apache process has 4 persistent connections to the database. Solve that user error issue (and…
Comment: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
Hi, I second that! We are using apache commons-dbcp for pooling connections to a mysql database. After setting the config “testOnBorrow” from… load on the database server dropped dramatically. This config specifies if a connection test should be done before using a connection for the…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…projects such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in …manually chop your data to the multiple databases and handle data merging on application together… support for query timeouts, parallel query execution, CONNECT BY support and various performance related features….
