DBMS connection read timeout interval - what variable is this?
In the Workbench Preferences > SQL Editor > MySQL Session section, there are two settings that play a role in keeping the DB connection alive for very long running queries. But I would like to know to what session or server variables these settings relate to.
DBMS connection keep-alive interval (in seconds): 600 (default)
(Time interval between sending keep-alive messages to DBMS)
DBMS connection read timeout interval (in seconds): 30 (default)
(The maximum amount of time the query can take to return data from the DBMS)
Especially the 2nd one is important; and how e.g. can I use that same setting when using the regular MySQL command client?
Subject
Views
Written By
Posted
DBMS connection read timeout interval - what variable is this?
878
July 04, 2023 02:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.