I have two mysql db on one machine. db1 and db2. If db1 is intensive in use, is querys for db2 wait for db1 querys finish? in other words is mysql use paralell computing for querys in different databases?
For example big query1 comes to db2. It computes 5 seconds. And after 1 sec comes little query2 for db1, it computes 1 second. Will query2 result be returned after 5 sec. (wait for query1) or returned after 1 sec. immediately?