[jira] [Updated] (FLINK-36044) In flink-connector-mysql-cdc-2.4.0 version, scan.snapshot.fetch.size does not take effect

["Yanquan Lv (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-36044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yanquan Lv updated FLINK-36044:
-------------------------------
    Fix Version/s:     (was: cdc-3.1.0)

> In flink-connector-mysql-cdc-2.4.0 version, scan.snapshot.fetch.size does not take effect
> -----------------------------------------------------------------------------------------
>
>                 Key: FLINK-36044
>                 URL: https://issues.apache.org/jira/browse/FLINK-36044
>             Project: Flink
>          Issue Type: Bug
>          Components: Flink CDC
>            Reporter: zhanghuaibei
>            Priority: Major
>              Labels: CDC
>
> In version 2.4 of the code, scan.snapshot.fetch.size was not read and loaded. In this version, how to implement MySQL stream reading, useCursorfetch=true, and debezium.snapshot.fetch.size for processing? can set Interger.MIN_VALUE?
> Is ResultSet.TYPE-FORWARD_ONLY necessary?
>  
> flink-connector-mysql-cdc/src/main/java/com/ververica/cdc/connectors/mysql/source/utils/StatementUtils.java, 
> private static PreparedStatement initStatement(JdbcConnection jdbc, String sql, int fetchSize)
> throws SQLException {
> final Connection connection = jdbc.connection();
> connection.setAutoCommit(false);
> final PreparedStatement statement = connection.prepareStatement(sql);
> statement.setFetchSize(fetchSize);
> return statement;
> },Is this writing method correct?
> This configuration does not work, and does it have a big impact on memory?



--
This message was sent by Atlassian Jira
(v8.20.10#820010)