PDA

View Full Version : mysql02 down?


jschleifer
11-2-03, 07:23 PM
getting the following error:


Warning: mysql_connect(): User 'jschleifer' has exceeded the 'max_connections' resource (current value: 3600) in /www/j/jschleifer/htdocs/forum/sources/Drivers/mySQL.php on line 65

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /www/j/jschleifer/htdocs/forum/sources/Drivers/mySQL.php on line 68
ERROR: Cannot find database jonhAndHisDog
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /www/j/jschleifer/htdocs/forum/sources/Drivers/mySQL.php on line 101



anyone else getting something like this?

tbonekkt
11-2-03, 07:25 PM
That means you've exceeded the connections per hour limit. It'll reset within an hour.

jschleifer
11-2-03, 07:27 PM
wow.. how'd I exceed that? there were ony like 7 people on the forum at that time..

jschleifer
11-2-03, 07:30 PM
ahh.. I think I see.

there was a robot crawling the site. it went through every link possible.. which probably caused mysql to serve it too much stuff.

so plop, it exceeded max connections.

note to self.. don't request a report from alexa.com

alphadesk
11-2-03, 07:39 PM
Use a robots.txt file ... it will keep "most" robots/spiders at bay.

http://www.searchengineworld.com/robots/robots_tutorial.htm

jschleifer
11-2-03, 07:43 PM
thanks!

I'll do that.. too bad I didn't know 'bout it before.

:(

hope this hour goes by quickly..

lego1990
11-2-03, 10:20 PM
I'll put one om my site too. I'm confused though, do you put it in htdocs or your root directory? It shows http://www.mydomain.com/robots.txt but if I put it in the root directory, I cannot get to it from the internet right?