Hi list.We have 2 tables, both have a few inserts, many updates and the occasional select. When running a select joining the 2 tables (which can take upto 20 seconds to complete, they are large tables) all updates are blocked and the maxconnections is quickly reached.
We tried copying the data to a 2nd database (in the same MySQL install) to run the select on that but for some reason that still prevents the updates on the original database, we watch the connections and we see them build up, when the select finishes they quickly clear. My question is how can we prevent this backing up of updates when running a select and why would doing a select on one database cause connections on another to back up? Thanks -- David
