Page 1 of 1

MySQL - keep connection alive

PostPosted: Sat Mar 05, 2016 1:56 am
by Anderseta
Hello everyone,

I have been using DBeaver for some time now, i honestly can't find a better client that's free and works fine for linux.

The only problem that i don't find a solution is that, if i stop running queries for some time, the database connection gets lost, everytime i need to run a query i also need to reconnect.

Is there a way to "ping" the database, or send some "SELECT 1" somehow in an interval of lets say 2-3 minutes to not lose the connection?

If someone has a solution i'd appreciate it.

Thanks in advance.