var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
MySQL server has gone away
I have a dedicated server that I run a video hosting site. Sometimes when people upload files I get the error
MySQL Query Error: xxx
SQL error: MySQL server has gone away
SQL error code: 2006
I have searched the internet and found that most people change the max_allowed_packet
I changed it also to something like 32MB but still sometimes I get this error.
Why does this happen? What else do you suggest me to change?
go to phpmyadmin and click on status (or issue the command 'show status')
what all entries do you see in red?
Primary email: advanced dot programmer at gmail dot com .. MSN/Email:
I have the following in red:
I was wondering what version of MySQL you were running. Other server specs and OS specs could help as well. I know I have seen that error with much older systems, but it has been a while.
Also, from what I am guessing, your clients are using a PHP script to upload files, is that correct? If so, what version of PHP, and what PHP commands are you using to open a MySQL connection? There are all kinds of possible reasons for this error, just trying to get a bit more info just in case I can help.
I don't recall seeing that error before but found this link that describes it pretty well. (too much info to post the entire thing here):
It sounds a lot like either the "wait_timeout" value (particularly when your clients are connecting from a WinDoze OS) or, as you mentioned, the "max_allowed_packet".
The text also describes some ways of troubleshooting the problem. Good luck.
Related Posts from theWHIR.com