hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : MySQL server has gone away
Reply

Forum Jump

MySQL server has gone away

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 09-04-2008, 08:02 AM
mogsub mogsub is offline
Junior Guru Wannabe
 
Join Date: Oct 2006
Location: Greece
Posts: 54

MySQL server has gone away


Hi,

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
Date: xxx

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?

Thank you

Reply With Quote


Sponsored Links
  #2  
Old 09-04-2008, 12:33 PM
superprogram superprogram is online now
Web Hosting Master
 
Join Date: Dec 2003
Posts: 933
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: sancusa@hotmail.com
AIM: superprg

Reply With Quote
  #3  
Old 09-04-2008, 01:45 PM
mogsub mogsub is offline
Junior Guru Wannabe
 
Join Date: Oct 2006
Location: Greece
Posts: 54
I have the following in red:

Handler_read_rnd
Handler_read_rnd_next
Created_tmp_disk_tables
Opened_tables

thanks

Reply With Quote
Sponsored Links
  #4  
Old 09-04-2008, 01:49 PM
Jonathan Kinney Jonathan Kinney is offline
WHT Addict
 
Join Date: Aug 2008
Location: Shoreline WA
Posts: 160
Server info?

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.

__________________
Jonathan Kinney
Data Systems Specialist
Advantagecom Networks, Inc.
http://www.simplywebhosting.com

Reply With Quote
  #5  
Old 09-04-2008, 01:56 PM
Jonathan Kinney Jonathan Kinney is offline
WHT Addict
 
Join Date: Aug 2008
Location: Shoreline WA
Posts: 160
PHP?

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.

__________________
Jonathan Kinney
Data Systems Specialist
Advantagecom Networks, Inc.
http://www.simplywebhosting.com

Reply With Quote
  #6  
Old 09-04-2008, 03:51 PM
koolcards koolcards is offline
Junior Guru Wannabe
 
Join Date: Aug 2004
Location: Tampa, Fl
Posts: 51
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):

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

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.

Reply With Quote
Reply

Related posts from TheWhir.com
Title Type Date Posted
Tesora's OpenStack DBaaS Supports MongoDB, Cassandra, Redis, and MySQL Web Hosting News 2014-05-23 14:53:11
Uhuru Joins Effort to Bring .NET and SQL Server to OpenShift Web Hosting News 2014-03-06 10:33:15
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2014-04-24 13:27:35


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?