Hey Developers,
I'm looking for a developer to help me with an issue I'm having on my SEO Hosting account (this particular server has 50-60 of my sites on it).
I got an e-mail from Hostgator (SEO Hosting - same company) stating the following:
"I apologize, but I was forced to suspend SQL usage for the reseller account "melovemy" and all sub-accounts of said reseller as multiple scripts inside were causing the server to hit max_connections Due to it affecting all of the other accounts on the system, we had to take immediate action for the health of the server.
Please be aware, we do not normally disable accounts in mass except in rare cases where multiple scripts are causing issues. We believe this is the only way to prevent a server crash and potential loss of data.
Generally this is caused by a bot or bot(s) causing intense traffic across multiple sites within this directory (in which case you may be able to create a [login to view URL] to affect this, or if caused by a site-map system, slow down how many requests are made), or you simply have far too many CPU intensive sites under this same account.
Here are a few links that can help you understand [login to view URL] files as well as create one;
[login to view URL]
[login to view URL]
Aside from the above robots information we do not have any specific recommendations for these scripts, however, in general, adding some sort of caching mechanism, where the script does not need to generate a new page with every request, helps to lower the over load that a script will cause. Likely the original author or support group of the software that you are using will be able to help you to understand how to add something of this nature.
If you reply back to this with your IP address ([login to view URL]) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues. "
Now I don't know how to do what they are asking, so I am looking for someone who can fix this issue for me easily. I want someone who is an expert and can do this in a breeze. I probably could do it myself, but I want to make extra sure it's done right.
All of the sites have wordpress installed...again there are 50-60 sites on this server.
Also, this will likely lead to a bunch of other "developer" type\similar jobs for you down the road with me, as I have hundreds and hundreds of sites...and issues come up here and there.
Please be very specific with your bid and your experience with this stuff...thanks.
Am ready to correct this issue for you. As a reseller as well, i have had this issue before. There are # of elements to troubleshot and research besides the robot file.
check your pm for more details. Am ready to proceed immediately....