Slow query stops apache from getting answer

Question

I have a problem where I can not query my mysql db until other queries are done. This happens when I run a heavy sql-query (30s) from apache, or when I ran a series of sql-querys from within the same apache-request.

Since my queries are only selects (no updates or modifications and no transactions) I think it should be possible to run simulatanious queries. How can I make this possible?

I am using Zend_Db::factory($config->db->adapter, $dbConfig); I am not sure if this limits the connections or try to re use same connection always. I manually close the connection between each call in the "serie of calls".

/Peter

Answer 1

You probably have a connection pool set up in Apache which is running out of connections. I'm not sure which module you're using in apache, but if its mod_dbd then check your DBDMax parameter.