From 62946f9ef643e33adbb0b4fe1d5139a1cb37dae1 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Sat, 25 Sep 2010 01:05:24 +0200 Subject: 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. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Update issue #4062 --HG-- branch : trunk --- src/server/shared/Database/MySQLConnection.h | 1 + 1 file changed, 1 insertion(+) (limited to 'src/server/shared/Database/MySQLConnection.h') diff --git a/src/server/shared/Database/MySQLConnection.h b/src/server/shared/Database/MySQLConnection.h index 09c30e7073e..93812421c8a 100644 --- a/src/server/shared/Database/MySQLConnection.h +++ b/src/server/shared/Database/MySQLConnection.h @@ -50,6 +50,7 @@ class MySQLConnection void CommitTransaction(); operator bool () const { return m_Mysql != NULL; } + void Ping() { mysql_ping(m_Mysql); } protected: MYSQL* GetHandle() { return m_Mysql; } -- cgit v1.2.3