当前位置: 动力学知识库 > 问答 > 编程问答 >

java - Does MySQL support parallelism while loading into a database?

问题描述:

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: