MySQL Forums
Forum List  »  MySQL Workbench

DBMS connection read timeout interval - what variable is this?
Posted by: Abraham Guyt
Date: July 04, 2023 02:35AM

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?

Options: ReplyQuote

Written By
DBMS connection read timeout interval - what variable is this?
July 04, 2023 02:35AM

Sorry, only registered users may post in this forum.

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.