[
https://issues.apache.org/jira/browse/FLINK-35291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruan Hang reassigned FLINK-35291:
---------------------------------
Assignee: LiuZeshan
> Improve the ROW data deserialization performance of
> DebeziumEventDeserializationScheme
> --------------------------------------------------------------------------------------
>
> Key: FLINK-35291
> URL: https://issues.apache.org/jira/browse/FLINK-35291
> Project: Flink
> Issue Type: Improvement
> Components: Flink CDC
> Affects Versions: 1.20.0
> Reporter: LiuZeshan
> Assignee: LiuZeshan
> Priority: Minor
> Labels: pull-request-available
> Fix For: cdc-3.3.0, cdc-3.2.1
>
> Attachments: 25ff4084-b7b5-488a-8665-cfb5062b7e54.png,
> a96b54e6-7736-434b-bd40-0a7a59300375.png, cdc-3.0-1c-2.html, cdc-3.0-1c.html,
> image-2024-05-06-00-29-34-618.png, image-2024-05-06-00-37-16-028.png
>
>
> We are doing performance testing on Flink cdc 3.0 and found through the
> arthas profile that there is a significant performance bottleneck in the
> deserialization of row data. The main problem lies in the String. format in
> the BinaryRecordDataGenerator class, so we have made simple performance
> optimizations.
> test environment:
> * flink: 1.20-SNAPSHOT master
> * flink-cdc: 3.2-SNAPSHOT master
> * 1CU minicluster mode
> {code:java}
> source:
> type: mysql
> hostname: localhost
> port: 3308
> username: root
> password: 123456
> tables: test.user_behavior
> server-id: 5400-5404
> #server-time-zone: UTC
> scan.startup.mode: earliest-offset
> debezium.poll.interval.ms: 10
> sink:
> type: values
> name: Values Sink
> materialized.in.memory: false
> print.enabled: false
> pipeline:
> name: Sync MySQL Database to Values
> parallelism: 1{code}
>
> *before optimization: 3.5w/s*
> !a96b54e6-7736-434b-bd40-0a7a59300375.png|width=575,height=285!
>
> [^cdc-3.0-1c.html]
> ^Analyzing the flame chart, it can be found that approximately 24.45% of the
> time is spent on string.format.^
> !image-2024-05-06-00-29-34-618.png|width=583,height=171!
>
> *after optimization: 5w/s*
> !25ff4084-b7b5-488a-8665-cfb5062b7e54.png|width=575,height=275!
>
> [^cdc-3.0-1c-2.html]
> After optimization, 4.7%(extractBeforeDataRecord+extractAfterDataRecord) of
> the time is still spent on
> org/apache/flink/cdc/runtime/typeutils/BinaryRecordDataGenerator.<init>.
> Perhaps we can further optimize it.
> !image-2024-05-06-00-37-16-028.png|width=379,height=107!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
