database error!

[bosanci28]

for few days i get this database error coming in my email...

and i did not do any mod,or anything to the site in the last week or so,
and i get this error:

Database error in vBulletin :
 
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User xxxxxx_xxxxxx  already has more than 'max_user_connections' active connections
/home/xxxxx/public_html/xxxxxxx/includes/class_core.php on line 314
 
MySQL Error   :
Error Number  :
Request Date  : Tuesday, August 23rd 2011 @ 07:12:55 PM
Error Date    : Tuesday, August 23rd 2011 @ 07:12:55 PM
Script        : http://xxxxxxxxxx.com/forumdisplay.php?35-Filme-Engleza
Referrer      :
IP Address    : xxxx.xx.xx.xxx
Username      :
Classname     : vB_Database
MySQL Version :

any idea why?
thanks,

[HMBeaty]

User xxxxxx_xxxxxx already has more than 'max_user_connections' active connections

Contact your host about this. This is not an issue with vBulletin

[bosanci28]

ok,i will thanks friend,for clarifying this for me!

--------------- Added [DATE]1314154229[/DATE] at [TIME]1314154229[/TIME] ---------------

Originally Posted by HMBeaty

Contact your host about this. This is not an issue with vBulletin

also can you see this error that i got about a week ago,
and i have asked my host and they said that is from the script ,they said that vb script is using
"simultaneous database connections"

and this was the error:

Database error in vBulletin :
 
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home5/xxxxx/public_html/xxxx/includes/class_core.php on line 314
 
MySQL Error   :
Error Number  :
Request Date  : Friday, August 12th 2011 @ 04:27:17 AM
Error Date    : Friday, August 12th 2011 @ 04:27:17 AM
Script        : http://xxxxxxx.com/calendar.php?month=3&year=2007&c=1&do=displaymonth
Referrer      :
IP Address    : xxxxx
Username      :
Classname     : vB_Database
MySQL Version :

thank you,for any help...

[nhawk]

This isn't a problem with vBulletin, this is a problem with your shared server limits as set by your host.

If it continues, then you have outgrown the use of the shared server you have and you need to look for a better server.

[bosanci28]

Originally Posted by nhawk

This isn't a problem with vBulletin, this is a problem with your shared server limits as set by your host.

If it continues, then you have outgrown the use of the shared server you have and you need to look for a better server.

are you talking about the first problem,or the one bellow...

thanks friend

[nhawk]

They are both related.

From what I can recall bluehost limits connections to mysql to 30 simulaneous connects. All it takes to trip that limit is 31 people, spiders, bots, whatever to access the site at the same moment in time. That accounts for the first error.

Also, bluehost had (don't know if they still do have) a 60 second real-time CPU usage limit over a 3 minute period. That can account for the second error.

Those are simplified explanations, but close enough for this purpose.

You can lower the connections a bit by not allowing spiders and unregistered users access to things like the calendar, who's online, member profiles and any other info that might be useless to them.

[bosanci28]

:::::You can lower the connections a bit by not allowing spiders and unregistered users access to things like the calendar, who's online, member profiles and any other info that might be useless to them.:::::


and how do i do that?


i have notice something on my forum,when i go to see whos online ,i get 14 users/guest

but one ip stands out ,starting with 119....

and if i go here and trace it it comes from japan ,and my site does not have nothing to do with japan,and also see that pic bellow there are a lot of 119.xxx.xxx and finishing with other numbers from the same place!,

thanks

[Max Taxable]

Originally Posted by bosanci28

:::::You can lower the connections a bit by not allowing spiders and unregistered users access to things like the calendar, who's online, member profiles and any other info that might be useless to them.:::::


and how do i do that?


i have notice something on my forum,when i go to see whos online ,i get 14 users/guest

but one ip stands out ,starting with 119....

and if i go here and trace it it comes from japan ,and my site does not have nothing to do with japan,and also see that pic bellow there are a lot of 119.xxx.xxx and finishing with other numbers from the same place!,

thanks

The baidu spider, one of the nastiest there is.

[bosanci28]

so i guess ,that whats trriger all that on my site?

is there any mod to stop that?

i mean ,those ip's come with different numbers to the end all the time...

i did install this mod here

but dont know if will it work,it looks like i have to add those ip's all the time..

thanks for any advice!

[Eric]

Originally Posted by bosanci28

so i guess ,that whats trriger all that on my site?

is there any mod to stop that?

i mean ,those ip's come with different numbers to the end all the time...

i did install this mod here

but dont know if will it work,it looks like i have to add those ip's all the time..

thanks for any advice!

If I am not mistaken, Baidu Spider will respect robots.txt. So you may want to add this to your robots.txt fle (or create a new file if you do not have one) - this file should be in the root of your website, and add:

User-agent: Baiduspider
Disallow: /

Other than that, vB 4 is not going to last on shared hosting long. You may want to look into a VPS to start out, or possibly a dedicated server if warranted.