We have a long running service that uses servicestack and ormlite with mysql. We are experience timeouts after leaving the service running overnight. I'm not sure if this is an ORMlite issue or a MySQL issue.
We have attempted setting a keepalive in the mysql connection string, but that did not work.
We see that the default system idletimeout is 8 hours or 28800 sec.
We could set that timeout longer, but would rather have a more proactive approach.
Is there a variable to check on the IDBConnection?
Whats the best way to manage this.
In OrmLite you can set
OrmLiteConfig.CommandTimeout (in seconds) which will populate ADO.NET's IDbCommand CommandTimeout property.