Announcement

**BirdOPrey5** · Thu 24 Nov '11, 11:25am

Those are just basic queries, nothing that should slow down any server under usual circumstances. Unfortunatately shared hosts are quick to point the finger to scripts like vBulletin even when the problem is their own over-loaded servers.

How many users do you get daily on a daily basis?

**gnrx** · Thu 24 Nov '11, 3:22pm

Hello.
I was supposed to the server pointed out to me very quickly, without my forum a loading server problem.

Now, I tell them reasons to see that my forum is not a server loading problem.

How many users do you get daily on a daily basis?

Awstats indicates an average of 5.000 number of visits a day.

Thanks and regards!

**gnrx** · Thu 24 Nov '11, 4:34pm

I don't know if the problem is related, but in the last weeks, I receive this error message from the forum by e-mail about 5 or 10 times a day (especially in the last days):

Database error in vBulletin 4.1.8:
Invalid SQL:
SELECT searchcore.searchgroupid, searchgroup.dateline
FROM searchcore AS searchcore
JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)
JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid)

WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('fastcert') LIMIT 500; MySQL Error :
MySQL server has gone away
Error Number : 2006
Request Date : Thursday, November 24th 2011 @ 06:44:41 PM
Error Date : Thursday, November 24th 2011 @ 06:45:03 PM
Script : http://www.xxxx/foro/search.php?do=process
Referrer : http://www.xxx/foro/threads/53030-hola-a-todos-necesito-ayuda-para-subir-un-5101
IP Address : xxx
Username : xxx
Classname : vB_Database
MySQL Version :

Thanks and regards!

**Mr.Tampax** · Fri 25 Nov '11, 12:58am

MySQL server has gone away

Contact your hosting provider - mysql server is overloaded. Or change virtual hosting to VPS-hosting - you can see load (and make changes in server) in "live" mode.

**BirdOPrey5** · Fri 25 Nov '11, 10:23am

If you're really getting 5,000 visitors a day you've probably outgrown shared hosting. As was said the error message is something you need to talk to your host about, the server is likely overloaded.

How many users online does the forum report throughout the day? In other words in any given day what is the max users online as reported by your forum (guests + members)?

**gnrx** · Fri 25 Nov '11, 3:01pm

Originally posted by BirdOPrey5 View Post

If you're really getting 5,000 visitors a day you've probably outgrown shared hosting. As was said the error message is something you need to talk to your host about, the server is likely overloaded.

Ok, but, if I need talk with my host because, the server is overloaded by my forum, or only because, the server, its overloaded (and my forum isn't the cause of this overload).(sorry, but my technical english isn't very good and when I talk, I know exactly tell my hosting so they can see that my forum is not the problem, if that is the case).

How many users online does the forum report throughout the day?
In other words in any given day what is the max users online as reported by your forum (guests + members)?

Normally, most users activity on the day I see are about 400 users (guests + members), but I don't know how view the reported by forum the max users online in a day, I view this value in Active users.
This value I have configured for 60 minutes.

Thank you very much for your help and attention, and sorry if any phrase isn't correct by me.

**BirdOPrey5** · Fri 25 Nov '11, 3:17pm

400 simultaneous users is pushing it for shared hosting- the best shared hosting could handle that but most will have the problems you are having. You will either need to upgrade your hosting package or find a new host.

**gnrx** · Mon 28 Nov '11, 3:37pm

In the day, the max users connect are 400 (more or less) but in the last 60 minutes, not at the same moment (I have configured the forum for view de users online in the last 60 minutes).
I don't know how view what users are connected simultaneous in the same minute.

Thanks and regards.

**Mr.Tampax** · Mon 28 Nov '11, 5:05pm

See "max-connetions limit:XX\XX" in mysqltuner.pl report. Will indicate how many users simultaneously access the database.

**gnrx** · Tue 29 Nov '11, 4:43pm

Hi.
Sorry, but I don' know how view mysqltuner.pl report...sorrys..

Edit: I search in google, I need install MySQLTuner, when I have install, I report the value.

Thanks and regards!

**gnrx** · Wed 14 Dec '11, 1:32pm

After several days of contact with the hosting, I am informed that, can not install MySQLTuner because my account is a shared account.
Hosting indicate that, my forum now works fine (I have dissabled all pluggins and mods), but I received, by mail, mails notifications of my forum with sql connects errors, like this:

Database error in vBulletin 4.1.8: Invalid SQL: SELECT searchcore.searchgroupid, searchgroup.dateline FROM searchcore AS searchcore JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid) JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid) WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('como hacer cable jtag') LIMIT 500;
...

For this reasson, I can't view how users online simultaneously acces to database, but I think like Mr.Tampax that, the mysql server is overloaded.

But I don't know that I need to tell the hosting so they can see the problem.

Thanks and regards.

**Wayne Luke** · Wed 14 Dec '11, 1:40pm

What is the entire error that you received? That just shows a query but not the specific error. There doesn't appear to be anything wrong with the syntax of the query.

**gnrx** · Wed 14 Dec '11, 2:13pm

This is the entire mail that I received:

Database error in vBulletin 4.1.8: Invalid SQL: SELECT searchcore.searchgroupid, searchgroup.dateline FROM searchcore AS searchcore JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid) JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid) WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('cmnonexp') LIMIT 500; MySQL Error : MySQL server has gone away Error Number : 2006 Request Date : Wednesday, December 14th 2011 @ 10:02:30 AM Error Date : Wednesday, December 14th 2011 @ 10:03:01 AM Script : http://www.myforum.com/foro/search.php?do=process Referrer : http://www.myforum.com/foro/forums/62-Software IP Address : xxx.xxx.xxx.xxx Username : zonerocks Classname : vB_Database MySQL Version :

Thanks and regards.

**Trevor Hannant** · Thu 15 Dec '11, 2:31am

This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

https://www.vbulletin.com/forum/show...265#post310265

Also from the MySQL site:

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

vBulletin 4 End of Life

Announcement

Problem script load server or problem with hosting?

[Forum] Problem script load server or problem with hosting?

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment