Connection 'going away' problems

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    4688
Current database: foo_bar

is the constant complaint of this db. I mean the query succeeds but that phenomenon is at least irritating. How to stop it?

Perhaps it's something to do with the settings? Please see attached file.
vars.txt
LVL 87
CEHJAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

karl-henrikCommented:
This problem is often because you have to small resources to run the Mysql server
But this is a sample configuration that might help

[mysqld]

port       = 3306
socket       = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 64M
table_cache = 4096
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 64M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M

This can also be a problem that you are running a to old version of Mysql with a 3:d party application (like drupal perhaps?) that require a more modern version of Mysql then you are running

Hope it helps
//Karl.
0
CEHJAuthor Commented:
>>This problem is often because you have to small resources to run the Mysql server

I have around 3GB ram, plenty of disk space and the dbs total about 225MB in size.  The version is  5.0.92-community
0
karl-henrikCommented:
Alright then you should not have much of a problem if not the timeouts are very short? This is a quite good guide to fault search this problem.. it's a hassle to find but it have helped me in the past

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CEHJAuthor Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.