…a MySQL connection pool handling system for the application level via a lightweight python app (using multi threading and internal queues) that accepted connections from the app (php, java, python, etc) and then passed the …
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…3 partitions tend to stay in the buffer_pool.) If I recall correctly, any INSERT/DELETE/…_ parallel queries (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one … details (and code) here: http://mysql.rjweb.org/doc.php/partitionmaint The third use case for …
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is … or have MySQL starting to swap aggressively. This is where connection pooling would be extremely helpful but with default Processed based PHP installations it…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… of memcached connections. Few MySQL connections (to the same host, which if usually bad idea) and connection to… example found the process is stuck in pool() system call reading from network. Using netstat… which can connect to PHP process or apache with mod_php and provide backtrace in PHP terms not…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… $numconn idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh… $numconn idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh…, this time looking at the number active connections. For these benchmarks, I use pools of 4 connections, basically to match the number of…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you… but the page also resides in the buffer pool and it can serve subsequent queries. This allow… connections can help with that. By the way, we’re seeing reports that MySQL 5.6 non-persistent connections…
Comment: Are PHP persistent connections evil ?
January 17, 2007 By 32 Comments
… X number of Oracle (or MySQL) connections and strives to maintain that number continually. Then, your PHP app connects and disconnects from the SQL… your SQL Relay connections. If you have leaky code that doesn’t disconnect properly, you can still flood your connection pool, no pun…
Comment: Why do you need many apache children ?
February 6, 2007 By 15 Comments
…PHP Connections a while back http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ In reality I think persistent connections…close relative of persistent connections – connection pooling is almost always used. Connection creation is not as expensive in MySQL but it is …
Comment: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…application chance of going from MySQL to something else is probably less than rewriting them from PHP to something else 
4) …many connection to get in trouble. Also if someone would implement connection pooling daemon implemented as a proxy for MySQL protocol supporting persistent connections …
Comment: Wishes for new "Pure PHP" MySQL driver
October 30, 2006 By 17 Comments
… the PHP/MySQL world that persistent connections were a bad thing. I would think with appropriate limits on the maximum number of persistent connections, Apache itself would essentially act as a connection-pooling daemon. Am I totally off base…
