I have a list of queries that I use to warmup my InnoDB database tables. Currently, I run these queries sequentially and they take some time to run. I was wondering if there was a way I could run them in parallel to speed up the time it takes to run all the queries?
SnapOverflow
You can simply open multiple connections to the database server from the same host or from several hosts. Then, you can split the INDEPENDENT queries over the established connections.
The InnoDB engine will take care of the required locking. As you may know, InnoDB engine supports row-level locking which will speedup the queries (compared to MyISAM) when there is a high contention (concurrent update/select queries).