PDA

View Full Version : My DB goes down every day for an hour

Mekis
9-8-09, 06:27 AM
Every day, between 02:00am (EDT) and 03:00am (EDT) my DB goes down for an hour aprox. Pased this time, the database seems to work again and DB goes fine again.

I contacted a lot of times with support and i never get a "final" solution so i came here hoping someone could help me.

This is the last response i got from technichal support:

We apologize for any inconvenience this has caused you. The issue you are experiencing is temporary. You will experience the issue while our server gets rebooted. We have some server reboot at the time 02:00am (EDT) and 03:00am (EDT) due to which you are getting database connection error. Unfortunately, we can not do much about this issue as we have set the Cron on our server which reboots the server at that time. But the issue is only for small period of time.

Is that true?

Someone can help with more information or a solution?

Thanks in advance ;).
HalfaBee
9-8-09, 08:44 AM
What error are you getting?
Maybe you are exceeding some limit at that time.
Mekis
9-8-09, 11:30 AM
The error is: "Error stablishing a database connection".

When this occurs im able to open simple .html pages or images.

The problem is not because the database exceeding any limits.
HalfaBee
9-8-09, 12:19 PM
Does it give a mysql error number?

That looks like a generic error message.
Mekis
9-8-09, 12:30 PM
No, just shows "Error establishing a database connection".

It repeats every day at the same hour. I'ts very strange.

Some idea?

Thanks.
entrecon
9-8-09, 12:54 PM
I haven't checked recently, but I know I used to see issues with my websites around 4-5 am....might be some kind of maintenance window and might have shifted little earlier.
Dbrazzell
9-8-09, 03:50 PM
hmm that's an odd situation.

There inst any daily maintenance that goes on with mysql. Most of the servers hum along for weeks/months at a time without any issues.

Im not so sure about that cron response. Ive never heard of anything like that before. I checked a mysql server at random and the mysql server itself has been up for 63 days.

Can you post an example URL. I might be able to catch as it happens. I am on shift at the time you have reported the issue happening.
Mekis
9-8-09, 07:09 PM
My URL is http://wow-info.es. Try to visit between 2:00am (EDT) to 3:00 (EDT).

Thanks.
Mekis
9-9-09, 03:42 AM
Okay you can chek my website now. Its happening again, you are unable to enter it.

"Error establishing a database connection".

Any ideas?
Mekis
9-11-09, 01:52 PM
I've changed my database and is still happening.

Please some help.

Thanks.
Dbrazzell
9-11-09, 04:05 PM
Hi,

Sorry I missed your posts. The forums doesn't seem to count your posts as new posts if you reply to your own thread.

Ill take a look at your issue today.
Croc Hunter
9-11-09, 04:10 PM
..The forums doesn't seem to count your posts as new posts if you reply to your own thread.. Nah, that's just the caching problem.. ~poke~ lmbo.
Dbrazzell
9-11-09, 07:00 PM
Just wanted to update Mekis here in the thread.

Things dont appear to be going very well for your blog. This issue actually looks self inflicted.

You are getting a fairly large amount of traffic to your site. Not so much that you've outgrown a shared hosting environment. But close.
This issue is made worse by the fact that every hit that makes it to your site is a cgi/mysql request. This is a lot overhead and it looks like at points you are exceeding the maximum number of simultaneous mysql connections you are allowed to have.
This is when you get the database errors.

If its possible. I would recommend that you look into some of the caching modules available for wordpress. There are quite a few and they all work well.
http://wordpress.org/extend/plugins/wp-super-cache/
Might work for you. Its a pretty extreme plugin. But it works wonders on wordpress sites that I have installed it to.
Mekis
9-11-09, 09:08 PM
I just installed it and i will try some days. I hope it fixes the issue.

Thanks Dbrazzell.
evanescent
10-8-09, 02:56 AM
I have the same problem. My database is inaccessible for an hour between 2am (EDT) and 3am (EDT). Support claimed that I had exceeded the max number of queries and said I could purchase more queries for some large sum of money.

Did you solve your problem? If so, how?
Dbrazzell
10-8-09, 12:08 PM
What type of software are you running on your site?

In Mekis's case he was using word press which conveniently has a plug-in available that can drastically reduce php/mysql overhead and prevent mysql queries from being generated in the first place.

Its possible an option might be possible for you if your using a different type of software.