mysql server is always disconnected

[Petey Pablo]

how to fix mysql server has gone away?(Always disconnected) See the image below. Im using CentOS 6 64bit.

[Dastgir]

Maybe you have offloaded sql or mysql timeout time is too less.(no activity in mysql for long time)

[Petey Pablo]

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?

[Petey Pablo]

@bump

[Brian]

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';

[Petey Pablo]

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

[Brian]

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" ?

[Winz]

I don't know but seems that if there's nothing to do, rA server will ping the MySQL server to keep him alive..