[
https://issues.apache.org/jira/browse/HIVE-23032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17060384#comment-17060384
]
Peter Vary commented on HIVE-23032:
-----------------------------------
By my tests on the openTxn speedup, I feel that we will have a performance
degradation in mysql. Nothing conclusive yet (need some rechecks etc), but even
with optimization settings below the generated sql seems to executing slower
than the original one:
{code:title=HikariCPDataSourceProvider.java}
if (determineDatabaseProduct(driverUrl) == MYSQL) {
config.setConnectionInitSql("SET @@session.sql_mode=ANSI_QUOTES");
config.addDataSourceProperty("cachePrepStmts","true");
config.addDataSourceProperty("prepStmtCacheSize","250");
config.addDataSourceProperty("prepStmtCacheSqlLimit","2048");
config.addDataSourceProperty("useServerPrepStmts","true");
config.addDataSourceProperty("useLocalSessionState","true");
config.addDataSourceProperty("rewriteBatchedStatements","true");
config.addDataSourceProperty("cacheResultSetMetadata","true");
config.addDataSourceProperty("cacheServerConfiguration","true");
config.addDataSourceProperty("elideSetAutoCommits","true");
config.addDataSourceProperty("maintainTimeStats","false");
}
{code}
> Add batching in Lock generation
> -------------------------------
>
> Key: HIVE-23032
> URL: https://issues.apache.org/jira/browse/HIVE-23032
> Project: Hive
> Issue Type: Improvement
> Components: Locking
> Reporter: Denys Kuzmenko
> Assignee: Denys Kuzmenko
> Priority: Major
> Attachments: HIVE-23032.1.patch
>
>
> Replace multi-row insert in Oracle with batching. Performance tests showed
> significant performance improvement after turning batching on.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
