Unable to execute query ....MySQL server has gone away

[cybra]

Im on a vps right now. Can it bee seen from WHMpanel? I can't find it from /etc/my.cnf

[bplex]

I'm not sure about the WHMPanel (don't use Cpanel or Cpanel products). However, you can see it from SSH (logging in via SSH as root).

[cybra]

So it looks like I can't get access that way. Unless I put in the wrong command
It says
root@server [~]# /etc/my.cnf
-bash: /etc/my.cnf: Permission denied

I can browse around and see if I can find away to find that file. I am pretty sure the limit is not set to 30minutes.

[bplex]

You have to open the file in a text editor of some sort (such as vi or nano). I.e. "vi /etc/my.cnf" or "nano -w /etc/my.cnf".

[cybra]

Ok I got in there. Heres what Im looking at. What do I need to change :)


skip-locking
character-sets-dir=/usr/share/mysql/charsets/
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
max_user_connections=100
max_connections=250
interactive_timeout=120
wait_timeout=30
connect_timeout=3000
thread_cache_size=96
key_buffer=16M
join_buffer=2M
max_allowed_packet=16M
table_cache=1024
record_buffer=2M
sort_buffer_size=1024K
read_buffer_size=1024K

I used nano /etc/my.cnf

[bplex]

wait_timeout=30

There is the problem right there. Basically, that is saying that after 30 seconds, close mySQL. That is obviously not set to 1800 like your host stated. I would sit it to 900 (15 minutes) and see if that works. If not, you can increase it further.

[cybra]

Ah I see. How would I actually change it using putty. Is it just like setting a cron command?

[cybra]

I just got a response from my host so lets see if they will do it
Now that they have been busted..:)

[cybra]

I accidentally deleted some important lines because I tried to just change the time out command but didn't realize I had to change them all at once.
Al my sites were down that hole time, and I almost had a brain spasm. But thanks for the info. Although I havent tested it yet Im sure it works.

skip-locking
character-sets-dir=/usr/share/mysql/charsets/
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
max_user_connections=100
max_connections=250
interactive_timeout=120
wait_timeout=1800
connect_timeout=3000
thread_cache_size=96
key_buffer=16M
join_buffer=2M
max_allowed_packet=16M
table_cache=1024
record_buffer=2M
sort_buffer_size=1024K
read_buffer_size=1024K

[cybra]

Yep :) Even went to my remote server.