One Miffed Out Clay
Here is what I received from 1and1 and my response.
I am upset and don't think much of 1and1 right now. Any ideas?
Sent: Friday, February 29, 2008 10:11 AM
Dear Clay Boutwell,
Thank you for contacting us.
I have looked over your managed server and do see what our administrators were able to see. You can use the following link below to view the servers system logs http://xxx. It will require a user name and password to log in and you will want to use the default FTP login details. From this you will see that the server is maxing out its resources and this is causing the server to crash. I believe it is MySQL that is causing the issues as if you log into your databases and run the status command you will see the following.
Threads: 1 Questions: 118187 Slow queries: 0 Opens: 350 Flush
tables: 1 Open tables: 43 Queries per second avg: 81.734
You will want to find which database or site that is causing the server to go down.
If you have any further questions please do not hesitate to contact us.
Dedicated Server Support
AND, I didn't hesitate:
Sent: Friday, February 29, 2008 11:06 AM
I deleted four superfluous databases I had installed but wasn't using. But I can't think of anything that would cause trouble from them. All that is installed now is Drupal (a CMS), phpBB (a Forum), and a Flashchat program. The problems started occurring before both the phpBB and Flashchat were installed--albeit not as severe...
I need the server to be up and running ASAP. When I first signed up with the server, I noticed 500 errors even before anyone else had visited the site or had much installed (just Drupal). I called support and the server seemed to do alright. I thought it was fixed.
Three days ago, we moved a live site (www.thejapanesepage) to the server and almost immediately we got Error 500s, database outages and the occasional page time out. I called 1and1 three times on Wednesday and finally they said it was escalated to 'priority.' I thought it would be fixed (again).
Thursday morning, more troubles. I called 1and1 a total of ten times yesterday according to my phone--Every time the server or database crashed (a few times I only got a recording which made the matter even worse). Each time I got a human, the phone support said the issue was being tackled by the highest tech level--but I never until your email (thank you) received any updates.
This morning my developer in Australia called me to tell me the database was down yet again and he could do no work.
If you think it is a software problem, please tell me what it is. I chose the Managed Server package with the thought there would be support behind it. I can't imagine Drupal causing trouble like this. I am sure I would have heard about it from the thousands of other sites running it.
If it takes moving the data to a new server, please do so, but do it quickly. I'm losing money and I don't like to do that.
One more thing. I will be out of touch all day tomorrow (Saturday). I NEED this taken care of TODAY. If they need to move it to a new server and it costs money to do so, just send me a bill. I don't want to wake up Sunday with loads of people talking about the server being down yet again.
Thank you for your prompt attention,