21310 Posts in 5739 Topics by 2604 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 2036 Views |
-
MYSQL server has gone away [SOLVED]
30 July 2009 at 5:20pm Last edited: 28 May 2010 3:46pm
For each of my sites, I get the same Error a few times each day.
"MYSQL server has gone away"I always assumed I was getting this error because I'm on shared webhosting. My webhost tells me its not their server causing the problems.
Anyone else get this issue occuring semi-frequently like myself?
According to MySQL, there are a number of reasons it could be occuring:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.htmlI wonder if SilverStripe could retry a query if it fails like this. Perhaps there could be a choosable number of times it retries.
-
Re: MYSQL server has gone away [SOLVED]
30 July 2009 at 6:07pm
Hi
I never had this issue, and I have been running websites with MySQL on dozens of different shared hosts. Maybe there's too much load on the server and MySQL times out... although that's unlikely.
Do you happen to have some huge DB tables your querying? Something outside of SilverStripe?If not, I suggest you change to a different hosting provider.
-
Re: MYSQL server has gone away [SOLVED]
31 July 2009 at 6:07am
Hi,
I'm also getting this on my shared webhosting.
FWIW,
Juan -
Re: MYSQL server has gone away [SOLVED]
1 August 2009 at 10:01pm
That is why it is better to use good shared hosting like 1and1.com or webthosting.com which are cheap and best
-
Re: MYSQL server has gone away [SOLVED]
2 August 2009 at 11:38pm
Some more info, I don't know if it applies: http://bugs.mysql.com/bug.php?id=28359
-
Re: MYSQL server has gone away [SOLVED]
3 August 2009 at 12:21pm Last edited: 3 August 2009 12:24pm
mindreader: I do consider my webhost a good one.
If I knew why I was getting this error, I would inform them, and they'd likely take action.
banal: My tables aren't very big, at least not the ones I query. Nothing outside of SS.
-
Re: MYSQL server has gone away [SOLVED]
28 May 2010 at 3:45pm Last edited: 28 May 2010 3:46pm
Just to update on this thread, it turned out the particular web hosting server I was on had disk I/O issues, causing the MySql server has gone away error. I've now moved to more reliable hosting (from the same provider).
| 2036 Views | ||
|
Page:
1
|
Go to Top |
