Petey Pablo Posted October 29, 2012 Group: Members Topic Count: 152 Topics Per Day: 0.03 Content Count: 569 Reputation: 11 Joined: 11/24/11 Last Seen: March 7, 2022 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 Group: Members Topic Count: 26 Topics Per Day: 0.01 Content Count: 331 Reputation: 63 Joined: 11/29/11 Last Seen: Saturday at 10:21 AM 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 Group: Members Topic Count: 152 Topics Per Day: 0.03 Content Count: 569 Reputation: 11 Joined: 11/24/11 Last Seen: March 7, 2022 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 Group: Members Topic Count: 152 Topics Per Day: 0.03 Content Count: 569 Reputation: 11 Joined: 11/24/11 Last Seen: March 7, 2022 Author Share Posted October 31, 2012 @bump Quote Link to comment Share on other sites More sharing options...
Brian Posted November 3, 2012 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 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 Group: Members Topic Count: 152 Topics Per Day: 0.03 Content Count: 569 Reputation: 11 Joined: 11/24/11 Last Seen: March 7, 2022 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 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 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 Group: Members Topic Count: 22 Topics Per Day: 0.00 Content Count: 1479 Reputation: 174 Joined: 12/14/11 Last Seen: November 21, 2016 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...
Question
Petey Pablo
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
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.