… 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 traffic over… but it offered an easy way to handle connection pooling and throttling so that connection spikes could be smoothed out; perhaps one day…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… want a connection pool. They’re just built that way (I’m looking at you, Java). And many others use persistent connections by default…, rather than being shared with whichever request needs a connection. Connection pools and persistent connections combined with a large number of application servers can…
Comment: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
For the Java connection pool issue you mention, it’s considered bad form to keep many unused connections in the pool. The normal solution is to tune the pools to drop them, say after 60 seconds and also to put an upper limit on the number of connections the pool…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
May 22, 2007 By 117 Comments
… are not typical; more typical are 1000 alive connections from Connection Pool (I am primarily Java developer). I set all thread-related numbers on…… Client application is a standalone Java process running concurrently 300 threads (each one has own connection), it’s not a web application…
Comment: Why do you need many apache children ?
February 6, 2007 By 15 Comments
… think persistent connections are good thing… if they are implemented properly. For example in Java World the close relative of persistent connections – connection pooling is almost always used. Connection creation is not as expensive…
Comment: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
I agree with Robert…Connection pools aren’t the anti-pattern, in fact I usually recommend … rate-limiting queue for a Java application. The anti-pattern is a connection pool configured to have idle connections for any longer than it…
Post: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
… * innodb_ibuf_max_size (default [the half of innodb_buffer_pool_size](bytes)) – This parameter is startup parameter. If the lower value is set than the half of innodb_buffer_pool_size, it is used as maximum size of insert buffer… visible only on new established connection, which is problem if you have pre-established connection pool, say in Java or Ruby on Rails application…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
… quite fine while having ACTIVE measured in hours. It is JAVA applications which often run in AUTOCOMMIT=0 mode and do… is really the killer. If you can’t fix your connection pool to rollback transactions when they are recycled it might be…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…Q: Are there similar plugins or resources for Java based applications? A: The recent versions of …but the page also resides in the buffer pool and it can serve subsequent queries. This …database instances. Q: Isn’t opening multiple database connections to the master and then subsequently potentially …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… this benchmark ? Now lets look at Java Settings: JDBC Pool (for EJBs): max-pool-size=100 steady-pool-size=50 cachePrepStmts=true prepStmtCacheSize=512… transaction-isolation = READ-COMMITTED max_allowed_packet = 1M max_connections=300 max_connect_errors=100 table_cache = 6000 read_rnd_buffer_size…
