MySQL down... alot!

Hi, I'm getting pretty upset with all the problems at Hostgator the last few days with First my server being down, and the last couple of days with the MySQL databases being down OFTEN. Is it possible to move from a server with MySQL 5 to one with MySQL 4? I need something more stable.

Here are some of the times I've been down:

Hi Support:
Following is a list of the times when my server (mainly MySQL) has been down. There are more reports, but these are a good sampling. The processes are checked by more than one company, from several different areas/locations. I have submitted a ticket for moving my site to a different server if this issue can't be resolved today. The only issue I see in moving is moving from MySQL 5 to MySQL 4 databases.
Here are some of the down times/info:


Down Times for the Server and MySQL database process:


Alert Type: Site Not Available
Result: Failed
Time: November 4, 2006 04:09:31 PST
HostName/URL: www.broadmanchurch.org
Monitor Name: BroadmanChurch
Alert Time: [2006-11-04] 08:40:15


Hostname: akronchessclub.com
Service: http (80)

is currently unreachable.
________________________________________
This is an automated message from SiteUptime.

Alert Type: Site Not Available
Result: Failed
Time: November 4, 2006 04:03:12 PST
HostName/URL: www.wczone.com
Monitor Name: WCZone


Alert Type: Site Not Available
Result: Failed
Time: November 4, 2006 05:03:19 PST


Alert Type: Site Not Available
Result: Failed
Time: November 4, 2006 08:33:29 PST
_________________________________________________

Alert Type: Site Not Available
Result: Failed
Time: November 4, 2006 04:04:06 PST
HostName/URL: www.akronchessclub.com
Monitor Name: Akronchessclub
Service: http

Alert Type: Site Not Available
Result: Failed
Time: November 4, 2006 05:04:15 PST

Alert Type: Site Not Available
Result: Failed
Time: November 4, 2006 08:34:39 PST
- Hide quoted text -
HostName/URL: www.akronchessclub.com
Monitor Name: Akronchessclub
Service: http
______________________________________________
The system confirmed 1 failed checks with your check interval
of every 30 min. starting from 04/11/2006 07:06:28 (GMT+05:00).

Host name : broadmanchurch.org
Port : 80
Service : http
Result : Ok
Time : 04/11/2006 07:35:19 (GMT+05:00)
--------------------------------------------------------------
The system confirmed 1 failed checks with your check interval
of every 30 min. starting from 04/11/2006 08:37:16 (GMT+05:00).

Host name : broadmanchurch.org
Port : 80
Service : http
Result : Ok
Time : 04/11/2006 09:05:22 (GMT+05:00)

--------------------------------------------------------------
The system confirmed 1 failed checks with your check interval
of every 30 min. starting from 04/11/2006 10:37:54 (GMT+05:00).

Host name : broadmanchurch.org
Port : 80
Service : http
Result : Ok
Time : 04/11/2006 11:06:02 (GMT+05:00)
----------------------------------------------------------------------
The system confirmed 2 failed checks with your check interval
of every 30 min. starting from 04/11/2006 11:37:36 (GMT+05:00).

Host name : broadmanchurch.org
Port : 80
Service : http
Result : Ok
_________________________________________


Alert Time: [2006-11-04] 13:33:58

This alert is to inform you that your service :

Hostname: broadmanchurch.org
Service: mysql (3306)

is currently unreachable. We will send you another email as soon as your service is available.


This alert is to inform you that your service :

Hostname: broadmanchurch.org
Service: mysql (3306)

is currently unreachable. We will send you another email as soon as your service is available.

Main site: http://www.uppanel.com
Your public stats: http://www.uppanel.com/showinfo?8204

_______________________________________
Dear Rebecca Friend,

This is an automated message from www.serviceuptime.com to inform
you that your service went down.

Host name : www.wczone.com
Port : 3306
Service : mysql
Result : Failed (mysql_connect(): Can't connect to MySQL server on 'www.wczone.com' (115))
Time : 04/11/2006 07:36:25 (GMT+05:00)

Checks failed from the following monitoring locations:
Brisbane, Australia (221.133.206.175)
Atlanta, GA, United States (72.232.37.110)


--------------------------------------------------------------Dear Rebecca Friend,

This is an automated message from www.serviceuptime.com to inform
you that your service went down.

Host name : www.wczone.com
Port : 3306
Service : mysql
Result : Failed (Can't connect to MySQL server on 'www.wczone.com' (4))
Time : 04/11/2006 10:36:44 (GMT+05:00)

Checks failed from the following monitoring locations:
Florence, Italy (194.242.61.24)
Washington, United States (65.98.100.218)


For further assistance, please contact support@serviceuptime.com.

--------------------------------------------------------------
Dear Rebecca Friend,

This is an automated message from www.serviceuptime.com to inform
you that your service went down.

Host name : www.wczone.com
Port : 3306
Service : mysql
Result : Failed (Can't connect to MySQL server on 'www.wczone.com' (4))
Time : 04/11/2006 12:07:19 (GMT+05:00)

Checks failed from the following monitoring locations:
Stratford, UK (85.13.206.9)
Singapore, Singapore (203.211.135.106)

--------------------------------------------------------------
Dear Rebecca Friend,

This is an automated message from www.serviceuptime.com to inform
you that your service went down.

Host name : www.wczone.com
Port : 3306
Service : mysql
Result : Failed (mysql_connect(): Lost connection to MySQL server during query)
Time : 04/11/2006 13:07:23 (GMT+05:00)

Checks failed from the following monitoring locations:
Stratford, UK (85.13.206.9)
Miami, United States (64.187.101.38)

--------------------------------------------------------------
Dear Rebecca Friend,

This is an automated message from www.serviceuptime.com to inform
you that your service went down.

Host name : www.wczone.com
Port : 3306
Service : mysql
Result : Failed (Lost connection to MySQL server during query)
Time : 05/11/2006 00:07:53 (GMT+05:00)

Checks failed from the following monitoring locations:
Michigan, United States (69.16.203.83)
Amsterdam, Netherlands (81.171.98.100)
__________________________________________________ ____________

Alert Time: [2006-11-05] 17:44:33

This alert is to inform you that your service :

Hostname: broadmanchurch.org
Service: mysql (3306)

is currently unreachable. We will send you another email as soon as your service is available.

__________________________________________________ __
Alert Time: [2006-11-06] 11:56:01

This alert is to inform you that your service :

Hostname: broadmanchurch.org
Service: mysql (3306)

Alert Time: [2006-11-06] 13:44:25
- Hide quoted text -

This alert is to inform you that your service :

Hostname: broadmanchurch.org
Service: mysql (3306)

--------------------
(This is a one-time automated response. Please do not reply.)

--------------------

Alert Time: [2006-11-06] 15:51:31
- Hide quoted text -

This alert is to inform you that your service :

Hostname: broadmanchurch.org
Service: mysql (3306)

_________________________________________
Dear Rebecca Friend,

This is an automated message from www.serviceuptime.com to inform
you that your service went down.

Host name : www.wczone.com
Port : 3306
Service : mysql
Result : Failed (Can't connect to MySQL server on 'www.wczone.com' (4))
Time : 06/11/2006 06:40:46 (GMT+05:00)

Checks failed from the following monitoring locations:
Parsippany, NJ, United States (205.234.182.234)
Washington, United States (65.98.100.218)

--------------------------------------------------------------
Dear Rebecca Friend,

This is an automated message from www.serviceuptime.com to inform
you that your service went down.

Host name : www.wczone.com
Port : 3306
Service : mysql
Result : Failed (mysql_connect(): Lost connection to MySQL server during query)
Time : 06/11/2006 16:44:24 (GMT+05:00)

Checks failed from the following monitoring locations:
Singapore, Singapore (203.211.135.106)
Brisbane, Australia (221.133.206.175)

[Serra]

Third party monitoring isn't very trust worthy.... so I'm not going to comment on the system being up or down based on that.

Moving from mySQL 5 to mySQL 4 could be a bit of a problem.

[Cropsy]

I'm on the same sever as Rebecca and I'm having the same problems. MySQL just randomly stops working some times. It's hard to lodge a support ticked about because the problem is intermittent and prone to fixing itself before a ticket can be lodged.

I'm not using any third party monitoring I just have a cron job on the server that fails reporting mysql errors periodically.

I am also having a problem. Joestrucks.net ... I was going to update the site this evening and I discovered the database was down... I promised my client I would update and now it can't happen - worse, the database is down and now no inventory is displaying.

Please reference the ticket you have open regarding the situation.
Also note that as the server is both mysql 5 and php 5 there will be more frequent flukes than a tried and tested mysql4/php4 system.

With that said I cannot see any outstanding problems on the server. Most (if not all) of your mysql issues are probably directly in relation to maintenance which could add "downtime" if you have your monitors checking every minute.

Cropsy,

Problems rarely resolve themselves: Fairy tales like that don't exist for us behind the helpdesk. We have a very thorough monitoring system in place that allows us to take care of most issues before users even notice them.

Hi GatorDave:
My Ticket Number was: XIY-81261. Tech Support acknowledged there was a problem (and as of today 11/17/06) is a problem as it has been down off and on all day long.

I understand Serra that 3rd party site monitors can sometimes give false positives for a variety of reasons. To help prevent that... I am signed up with 5 different free monitoring companies. (Each monitoring several different ports). If just one, or even two showed a problem I might not think much of it. Several of these though check from several different regions, so if all of them are showing the site (or a MySQL) is down, and then I check... and its down...its having problems. I think part of the issue is that I had asked to be on a server with MySQL 5 (and only PHP 5 is offered on that server) so I think the support team still has a lot of kinks to work out of this server system.
Rebecca

[ghettopixel]

This could be a problem with somones script and somone else trying to inject them. If it fixes its self before you can lodge a ticket that is most likely the problem, somone is getting injected.

[Mirrorball]

I'm getting lots of "Mysql server has gone away" error messages from my vBulletin forum. It's getting really bad.

[Serra]

What is the actual error message?

[Mirrorball]

Originally Posted by Serra

What is the actual error message?

"MySQL server has gone away."

[cjnoyes]

Originally Posted by Mirrorball

"MySQL server has gone away."

Is this a persistent connection?

This was being cause by the wait_timeout being set at 25. This has been modified and all should be better now.

[nukerocks]

Originally Posted by GatorBilly

This was being cause by the wait_timeout being set at 25. This has been modified and all should be better now.

i have the same problem but where do you change the wait_timeout and what did you change it too? thanks