[FLINK-18041] Make a little bit improvement for DEFAULT_FLUSH_MAX_SIZE and DEFAULT_FLUSH_INTERVAL_MILLS of AbstractJdbcOutputFormat

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.10.0, 1.10.1, 1.11.0
• Component/s: Connectors / JDBC
• Assignee: Unassigned
• Reporter: sunjincheng
• Created: 31/May/20 03:30
• Updated: 31/May/20 13:09
• Resolved: 31/May/20 13:08

Description

Recently, when some users are learning Flink, they encounter a big problem, that is, why Flink can't write to MySQL in real time.

The root cause is that there is little data when testing and the default value for DEFAULT_FLUSH_MAX_SIZE is 5000,  and DEFAULT_FLUSH_INTERVAL_MILLS is 0.

https://github.com/apache/flink/blob/release-1.10/flink-connectors/flink-jdbc/src/main/java/org/apache/flink/api/java/io/jdbc/AbstractJDBCOutputFormat.java

So, I think would be great to make a little bit improvement  for the default value. Such as 

DEFAULT_FLUSH_MAX_SIZE = 1. 

What do you think? 

Issue Links

• is duplicated by: FLINK-16497 Improve default flush strategy for JDBC sink to make it work out-of-box