MySQL Forums
Forum List  »  Router & Proxy

Advanced Search
New Topic

Database select failure with > max_idle connections
Posted by: simon elliston ball
Date: September 06, 2007 05:24AM

I'm seeing a weird phenomenon with trunk r218.

When I fire more than max_idle_connections at the proxy from php, connecting to random databases, I occasionally (tiny percentage of the time) get a Lost Connection error on the database selection phase.

I'm testing in jmeter, calling a php page, which connects to a random db (one of ten), and does a simple select, my max_idle_connections is 8, and as soon as I ramp up to 9 test threads, I start to get a small percentage of failures. When taking the randomness out of the equation (ie, connected to db1, db2... db10) the problem does not occur.

Has anyone else seen this behaviour, or got any insights before I submit this properly as a bug?

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.