Heya, vkvkvk.
I suppose you could run two instances of mysqld on the same server, open two connections in your application, and attempt to run two queries concurrently.
The problems with this, though, are:
- mysqld checks for other running instances of mysqld, so you'd have to do something... unsupported... to get it to work.
- With two instances of mysqld running, you'll probably experience data corruption at some point, since mysqld was never designed to run more than one instance at a time.
- Many programming languages do not support threading, so your script would wait for the first query to finish before starting the second one anyway.
Now you could in theory set up a MySQL Cluster, but pretty much for the reasons above, you'd need at least 3 separate computers, and at that point, the overhead would just about outweigh any benefits. At least, when it came to trying to make MySQL use some kind of threading.