Document setting interactive_timeout and wait_timeout for MySQL CDC

[subodh1810]

We use debezium for MySQL CDC.

While we have not observed any instances of this but its mentioned in the debezium docs https://debezium.io/documentation/reference/1.4/connectors/mysql.html#mysql-session-timeouts

When an initial consistent snapshot is made for large databases, your established connection could timeout while the tables are being read. You can prevent this behavior by configuring interactive_timeout and wait_timeout in your MySQL configuration file.

┆Issue is synchronized with this Asana task by Unito

[grishick]

We have not seen this happen yet, but we should update the documentation to reflect this.

[prateekmukhedkar]

Defaults are:
interactive_timeout : 28800 seconds (8 hours)
wait_timeout : 28800 seconds (8 hours)

Reference: MySQL’s documentation

@subodh1810 for the initial sync with CDC what would we recommend to customers? Or are defaults OK?

[akashkulk]

We no longer use debezium for initial snapshots, closing