问题描述:

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 MySQL .

网友答案:

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.

相关阅读:
Top