How to update the command timeout in mysql database. I know how to do it at application level but I want to change the command timeout at db end. So that I have to change it only at one place. At application end I am using
"default command timeout = 0"
and it is working fine. But can anyone tell me how to do the same at db end?
The answer is: you cannot. Why? Because command timeout is specific to the MySQL .Net Connector:
As MySQL documentation on MySqlCommand object says:
So, before 6.2 the command timeout included client side processing time - this obviously cannot be taken into account on the server side.
Since 6.2, the behaviour has changed and does not include client side processing time. However, it is now defined as "cumulative timeout for all network reads and writes". In MySQL server you can configure various timeouts, but those are not cumulative, nor apply to both reads and writes. There are separate read and write timeouts only. So, there is no mapping of this connector parameter to the MySQL configuration.