Forum Moderators: open
I have community site (vbulletin forum - PHP scripts and MySQL database) hosted in a shared server environment. I also have a customized PHP page with automated queries connecting to the forums MySQL database.
My site performance has gone down very badly and I have been receiving the following MySQL errors:
1) exceeded the 'max_questions' resource (current value: 50000) Error Number : 1226
2) mysql_connect(): Too many connections
The 1st error indicates the restriction imposed by my host on the max queries allowed for a database user. The 2nd error indicates that there are too many connections to the database again exceeding the limit set for the day by the host.
But my site is fairly small site. I have no more than 50 concurrent site users logged into my forums at any point of time. Even if I consider the crawling done by yahoo slurp spider, google bot, etc. they cannot be even anywhere closer to making 50,000 queries on the database. However, I have also introdcued craw delay in the robots.txt file.
Whenever I ask my host, they refuse to increase the max_resources limit and ask me to upgrade to private server.To my knowledge, I am not convinced from my site traffic that it requires to be hosted on a private server.
Please can someone advise what needs to be done.
1) Server optimisation?
2) Database optimization?
When I recieve the max_questions resource exceed limit error, it is the customized homepage alone that fails to work. While the forum pages are still working.
If the db has hit the max queries limit, how is my forum pages connecting to the same db still working?
3) Shifting to a good hosting company?
Are there hosting companies allowing max limit more than 50000 queries or really flexible in a shared server?
If yes, please let me know the name of those companies. I will give them a try.
Thank you in advance for all the responses I receive here.
