… but creating connections will still waste resources and add latency. The other problem with persistent connections is using too many MySQL server connections. Some people…. The real reason is – you could get much more problems with it. Persistent connections were added to PHP during times of MySQL 3.22…
Comment: How much memory can MySQL use in the worst case?
February 13, 2009 By 17 Comments
…-sleeping connections; but even without sleepers, if your appserver uses persistent connections, they tend to not always be perfectly “clean” when reset. Persistent connections with MySQL… ideas of where “missing memory” tends to hide in the real world.
Comment: Configuring MySQL For High Number of Connections per Second
January 10, 2012 By 23 Comments
… ended up with the two lines supplied by the MySQL documentation. Obviously the real cause behind our problem is that we do… of many processes spawning on the webservers and not using persistent connections. However given our webserver pool size, the short ttl of… processes it would be very dangerous to actually go for persistent connections. We’ll just have to solve this issue in our…
Comment: Are PHP persistent connections evil ?
November 14, 2006 By 32 Comments
… badly need connection to be persistent but you can’t have so many connections to MySQL. Would be interesting however to see some real benchmarks…
