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

[bplex]

Ask them which timeout limit they actually changed and if they restarted mySQL after the change. By default, BTW, the limit is set to 8 hours. They are telling you that it is set to 30 minutes, but if it is timing out before 30 minutes, it is obviously not set to 30 minutes.

[cybra]

I asked them to increase the MySQL server timeout and I actually restarted the server myself. So you said by default the limit is set to 8 hours. That would mean they actually would have decreased the limit to 30 minutes? Should I ask them then to set the limit to 8 hours?

[bplex]

Are you on a dedicated server (or virtual server)? If so, you can actually check the my.cnf file yourself (usually /etc/my.cnf) and see what they set the wait_timeout limit to. By default, it's 8 hours. However, setting it that high hurts performance which is why most host set it to something much lower than that (usually 5-10 minutes).

[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