I am building a selenium test suite which pulls a list of tests to run and then forks those tests to multiple parallel processes. Each process needs its own connection to the database because of two reasons: one, when the child process ends the connection is closed and two, when you have several processes sharing a connection and all running queries at the same time, sometimes mysql can generate some strange errors. The problem that I am running into is that since each process is going to need its own connection, I am worried about running out of connections. Is there a way to have PDO wait for an avaialbe connection if max connections is hit?
Jump to Post
Some info on number of connections here: http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html
But you've probably read that. Are you running more than 150 concurrent connections?
All 3 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.