Skip to content

mysql8 性能提升注意事项

Jump to bottom
zhongxuchen edited this page Jul 28, 2023 · 2 revisions

1、mysql8 默认没有开启批量插入 需要设置:rewriteBatchedStatements=true

<property name="connectionProperties" value="defaultRowPrefetch=${jdbc.fetch_size};defaultBatchValue=${jdbc.batch_size};config.decrypt=false;rewriteBatchedStatements=true;useServerPrepStmts=true;cachePrepStmts=true" />

Clone this wiki locally