Use DBeaver link to the mysql database, after a period of time, will connection timeout, DBeaver will feign death,
How can I set up the connection timeout, or how do you solve this feign death?

CodePudding user response:

If no operation for a long time, idle time is too long?

CodePudding user response:

The original poster hello,
In Mysql default Settings, if a database connection more than 8 hours didn't use (idle 8 hours, the 28800 s),
Mysql server will take the initiative to disconnect the connection, the subsequent query operation will fail in that connection,
Will appear: error 2006 (MySQL server has gone away)! ,


Look at the mysql server timeout:

Msyql> Show global variables like '% % timeout';

Set the mysql server timeout (in seconds) :

Msyql> The set global wait_timeout=10;
Msyql> The set global interactive_timeout=10;

CodePudding user response:

reference 1st floor ACMAIN_CHM response:

is not operating for a long time, idle time is too long?

Right, long time no operation, the connection is broken, the problem is disconnected after dbeaver easy to feign death,
Just like other database connection tools usually set the keepalive interal, but dbeaver couldn't find where to set, want to ask how to solve,

CodePudding user response:

Then how to solve the building Lord, this client is really hurt, badly even soon

CodePudding user response:

Then how to solve the building Lord, this client is really hurt, badly even soon

CodePudding user response:

EditConnection - & gt; The Connection Settings - & gt; The Driver properties - & gt; tcpKeepAlive

CodePudding user response:

refer to 6th floor kcetry response:

editConnection - & gt; The Connection Settings - & gt; The Driver properties - & gt; TcpKeepAlive

Nice

CodePudding user response:

refer to 7th floor xbox1994 response:

Quote: refer to the sixth floor kcetry response:

EditConnection - & gt; The Connection Settings - & gt; The Driver properties - & gt; TcpKeepAlive

Nice

A value tcpKeepAlive=??