Petey Pablo Posted October 29, 2012 Share Posted October 29, 2012 how to fix mysql server has gone away?(Always disconnected) See the image below. Im using CentOS 6 64bit. Quote Link to comment Share on other sites More sharing options...
Dastgir Posted October 29, 2012 Share Posted October 29, 2012 Maybe you have offloaded sql or mysql timeout time is too less.(no activity in mysql for long time) Quote Link to comment Share on other sites More sharing options...
Petey Pablo Posted October 29, 2012 Author Share Posted October 29, 2012 Maybe you have offloaded sql or mysql timeout time is too less.(no activity in mysql for long time) How to set or configure properly for offloaded sql or mysql timeout time? Quote Link to comment Share on other sites More sharing options...
Petey Pablo Posted October 31, 2012 Author Share Posted October 31, 2012 @bump Quote Link to comment Share on other sites More sharing options...
Brian Posted November 3, 2012 Share Posted November 3, 2012 How much RAM does your server have? free -m Is MySQL Server running on the same machine or a separate VPS? What is the 'wait_timeout' config on your MySQL Server? (connect to MySQL and execute this query) SHOW VARIABLES LIKE 'wait_timeout'; Quote Link to comment Share on other sites More sharing options...
Petey Pablo Posted November 3, 2012 Author Share Posted November 3, 2012 (edited) How much RAM does your server have? free -m Is MySQL Server running on the same machine or a separate VPS? What is the 'wait_timeout' config on your MySQL Server? (connect to MySQL and execute this query) SHOW VARIABLES LIKE 'wait_timeout'; MySQL is running on same machine. For the RAM? See the image below For the wait_timeout. See the image below Edited November 3, 2012 by WillSuranol Quote Link to comment Share on other sites More sharing options...
Brian Posted November 4, 2012 Share Posted November 4, 2012 hmm both look fine to me: 2 GB ram and 8 hours wait_timeout (the default). I don't know what could be causing it. If you have a separate machine, or even your own computer to test on, can you run rAthena and see if you get "MySQL Server has gone away" ? Quote Link to comment Share on other sites More sharing options...
Winz Posted December 20, 2012 Share Posted December 20, 2012 I don't know but seems that if there's nothing to do, rA server will ping the MySQL server to keep him alive.. Quote Link to comment Share on other sites More sharing options...
how to fix mysql server has gone away?(Always disconnected) See the image below. Im using CentOS 6 64bit.
Link to comment
Share on other sites