MySQL CDC: fail to create mysql source if upstream has many tables

[StrikeW]

Describe the bug

The mysql connector will read schema of all tables from upstream mysql, if the mysql instance has many tables the debezium connector streaming source will fail to start because of the timeout of our internal status check.

Error message/log

2024-01-05 09:09:54,941 INFO  [debezium-mysqlconnector-RW_CDC_4326-change-event-source-coordinator] relational.RelationalSnapshotChangeEventSource:115 - Snapshot step 5 - Reading structure of captured tables
2024-01-05 09:09:54,941 INFO  [debezium-mysqlconnector-RW_CDC_4326-change-event-source-coordinator] mysql.MySqlSnapshotChangeEventSource:327 - All eligible tables schema should be captured, capturing: xxx
2024-01-05 09:09:57,024 INFO  [debezium-mysqlconnector-RW_CDC_4326-change-event-source-coordinator] mysql.MySqlSnapshotChangeEventSource:349 - Reading structure of database 'bi_test'
2024-01-05 09:10:04,288 ERROR [Thread-24507] common.DbzSourceUtils:48 - Debezium streaming source of RW_CDC_4326 failed to start

To Reproduce

No response

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

No response