Source mysql: update docs to include increase slave_net_timeout and t…

…hread_pool_idle_timeout in case of errors (airbytehq#20438) * Source mysql: mark unknown column exception as config error * Source mysql: format code * Source mysql: increase slave_net_timeout and thread_pool_idle_timeout to 120 * update doc rather than attempting to set global server properties --------- Co-authored-by: nataly <nataly@airbyte.io> Co-authored-by: Prateek Mukhedkar <123108018+prateekmukhedkar@users.noreply.github.com> Co-authored-by: Rodi Reich Zilberman <867491+rodireich@users.noreply.github.com>
samos123 · Mar 29, 2023 · 3c343f5 · 3c343f5
1 parent fdce724
commit 3c343f5
Showing 1 changed file with 5 additions and 0 deletions.
diff --git a/docs/integrations/sources/mysql.md b/docs/integrations/sources/mysql.md
@@ -137,6 +137,11 @@ In this case, you can configure the server timezone to the equivalent IANA timez
 
 When a sync runs for the first time using CDC, Airbyte performs an initial consistent snapshot of your database. Airbyte doesn't acquire any table locks \(for tables defined with MyISAM engine, the tables would still be locked\) while creating the snapshot to allow writes by other database clients. But in order for the sync to work without any error/unexpected behaviour, it is assumed that no schema changes are happening while the snapshot is running.
 
+If seeing `EventDataDeserializationException` errors intermittently with root cause `EOFException` or `SocketException`, you may need to extend the following *MySql server* timeout values by running:
+```
+set global slave_net_timeout = 120;
+set global thread_pool_idle_timeout = 120;
+```
 ## Connection via SSH Tunnel
 
 Airbyte has the ability to connect to a MySQl instance via an SSH Tunnel. The reason you might want to do this because it is not possible \(or against security policy\) to connect to the database directly \(e.g. it does not have a public IP address\).