MySql is Gone a Way!

[serra00]

Hello I have a problem long ago, it shows me the error of " MySQL is gone to way" all along. i reach my hosting and they've told me that they didnt know, that could be that error. I hope know to help me.

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT post.postid
FROM post AS post

WHERE post.threadid = 338
AND post.visible = 1


ORDER BY post.dateline
LIMIT 10, 10;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, September 1st 2008 @ 10:35:40 PM
Error Date : Monday, September 1st 2008 @ 10:36:09 PM
Script : http://www.miforo.com/tema.hmml
Referrer :
IP Address : 201.250.5.236
Username : No Registrado
Classname : vB_Database
MySQL Version :

[TeelK]

<a href="http://dev.mysql.com/doc/refman/5.0/en/gone-away.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/gone-away.html</a>

[serra00]

it already enters that subject and I do not include/understand what can be the solution

[Dismounted]

<a href="http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway" target="_blank">http://www.vbulletin.com/docs/html/t...mysql_goneaway</a>

[Lynne]

Unless you have access to change the my.cnf file (your mysql settings file), you will have to ask your host to fix this issue.

[serra00]

then it would have to say hosting to him that it changes that file modifies or it? exactly they who must do? that it is a right answer since to only copy and sticks a Link does not serve, so that itself without understanding the problem. and if they respond on hosting they say exactly that they deberian to do, since they do not know.

[SEOvB]

Find a new host if your current host can not fix it.

[serra00]

I believe that she will be able if you detail better to the error thus my to me host will have but facility to solve the error to me

[Lynne]

One thing they can change is the wait_timeout which is talked about in the link we provided. It may be that the wait_timeout is too low for your server/site.

[serra00]

the stranger has been that not always I had east problem, empesó to appear to me for 2 months and not so that, hosting can cambiarte " wait_timeout" only?

[Lynne]

I don't know if they only need to change the wait_timeout. A good hosting company should be familiar with the error "MySQL has gone away" and know what it means and know the different variables that come into play to fix it.

[serra00]

and if it is not good company? jajaja. the stranger is that recently who happens constantly, before he did not happen. then like it was the subject? That he would have to say to them to hosting?

[Lynne]

It could be happening more recently because you either have more users on your site (bots count as users too) or because something else changed on the server.

What did your hosting company say when you told them about the errors?

[serra00]

they say to me that they do not know so that of the error and say that he is mine so that this in my data base

[Lynne]

You can always asked for server optimization here - Server Configuration (http://www.vbulletin.com/forum/forumdisplay.php?f=14)
But, you need to read this thread first - [Required]: Info for optimisation / troubleshooting requests [31/03/08 update] (http://www.vbulletin.com/forum/showthread.php?t=70117)

[serra00]

they suspended the page to me by these errors, they always ask to me that them of the Link of when happens and they do not understand that always happens, that I do?

[serra00]

it is possible that this causes consumption of resources of the system of my server?

[snakes1100]

yes & no, mysql has gone away, its NOT answering anymore, your users will still request the pages and apache will continue to answer even tho mysql isn't, so yes it will cause resources to be used even tho the site is not functioning anymore.

you need to modify my.cnf and make some adjustments to the mysql settings, but without looking at the server itself, we can not really tell you what settings need to be changed to help compensate for the mysql issue.

you can either post for a paid request to have the server checked by a capable person here or post at vb.com and wait for George/Eva to answer your post.