Core/DBLayer:

- Rewrite KeepAlive method for DatabaseWorkerPool. Use mysql_ping instead of explicit select queries, and also schedule KeepAlives for asynchronous threads.
NOTE: While the function is implemented and previous keepalive calls were transformed, it´s possible the keepalive call will need to be placed in several other locations in the code. Please leave feedback on whether or not this fixes your timeout issues.

Update issue #4062

--HG--
branch : trunk

1 files changed, 1 insertions, 1 deletions

diff --git a/src/server/authserver/Main.cpp b/src/server/authserver/Main.cpp
index dfc04f58512..d23aecf3313 100644
--- a/src/server/authserver/Main.cpp
+++ b/src/server/authserver/Main.cpp
@@ -314,7 +314,7 @@ extern int main(int argc, char **argv)
         {
             loopCounter = 0;
             sLog.outDetail("Ping MySQL to keep connection alive");
-            LoginDatabase.Query("SELECT 1 FROM realmlist");
+            LoginDatabase.KeepAlive();
         }
 #ifdef _WIN32
         if (m_ServiceStatus == 0) stopEvent = true;