… not tell you which of apache children is handling request in question. If you just want to… for example found the process is stuck in pool() system call reading from network. Using netstat can… debugger which can connect to PHP process or apache with mod_php and provide backtrace in PHP terms not the…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
…i*20)) echo “Doing $numconn idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -… at the number active connections. For these benchmarks, I use pools of 4 connections, basically to … slowed down by handling all those connections. I tried generating the idle connections from a third …
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…number of connections is limited you start getting connection errors which are easy to handle, in case of large number of connections allowed …swap aggressively. This is where connection pooling would be extremely helpful but with default Processed based PHP installations it does not work. …
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… on “Read/Write Splitting with PHP” for Percona Webinars. If you missed… The bottom line is that PXC handles slave lag transparently, so the … page also resides in the buffer pool and it can serve subsequent queries…. Q: Isn’t opening multiple database connections to the master and then subsequently…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… app (using multi threading and internal queues) that accepted connections from the app (php, java, python, etc) and then passed the traffic… proxy but it offered an easy way to handle connection pooling and throttling so that connection spikes could be smoothed out; perhaps one day…
Comment: Why do you need many apache children ?
February 6, 2007 By 15 Comments
… in Java World the close relative of persistent connections – connection pooling is almost always used. Connection creation is not as expensive in MySQL but… these PHP connections almost always recycled. Plus you do not have the problem of many man thousands of connections for MySQL to handle – which…
