Hi
We are using v3.55 of the MyDirect.Net drivers to connect to MySQL version 5.0.22 pro. When running an ALTER query on a large table, we run in to "Lost connection to MySQL server during query" error.
The error occurs exactly 2 mins after executing the command against the database. If I use another MySQL client like SQLYog, the query executes fine but does take about 8 mins to complete.
The connection string looks like this:
User Id=userId;Password=pwd;Port=3306;Host=hostName;Database=dbName
Is there a way to increase the 2 min timeout value somehow? The timeout values on the server side are abundant and are definitely way more than 2 minutes so this has to be a client issue. Is there a way to specify auto reconnect using Corelab drivers?
This issue is critical for us to fix asap. Please help.