I want to load data into a MySQL table using Load/Insert statement. Is there a way to use parallelism for performance benefit?
Something like this in Oracle :-
alter session enable parallel dml
P.S :- I am using
JDBC connection for connecting to
Per this Bug thread When will Mysql have parallel query and partitioning; there is no support for Parallel query in MySQL.
See this similar post in So equivalent of parallel query of ORACLE in mysql
There isn't really a way to parallel from the statements themselves, it's more about the underlying architecture. If you are working with a cluster you can shard a database to improve performance. However, sharding is not the same as parallelizing statements in the sense of what you are asking.