背景
flink通过jdbcsink将数据流插入到TiDB
objDataStream.addSink(JdbcSink.sink(
getInsertSql(),
(statement, row) ->
{
preparedStatementMap(statement, row);
},
JdbcConnectionOptionsUtil.getJdbcConnectionOptions(
url,
name,
password
)
));
问题
插入效率很低,大概几十条每秒
解决方案
url后面加上
?rewriteBatchedStatements=true