MySQL - keep connection alive
Posted: Sat Mar 05, 2016 1:56 amHello 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.
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.