design: decide a better strategy for mysql client timeouts

[andreabadesso]

Motivation

Currently, we have the default timeout set for the mysql client (10s), this is an issue because we have lambdas with multiple queries, like the onNewTxRequest lambda. We have a rollback mechanism in place, so if the lambda timeouts, the transaction never gets committed, but we should have a better mechanism for detecting timeouts in the mysql client so we can get better errors indicating which query is timing out

Task breakdown

• Propose a design with a solution to improve the mysql client timeout - 1 day