PDA

View Full Version : MySQL Downtimes?

Zacarias
10-6-05, 05:26 AM
I'm just wondering about something...

Nearly every day, I get about 8-16 e-mails from my forums that the MySQL database is down. It's really starting to get annoying. Is mysql05.powweb.com constantly being serviced, or is it crashing frequently...? Or is it a cron job that's restarting it regularly? :confused:
RTH10260
10-6-05, 12:44 PM
I'm just wondering about something...

Nearly every day, I get about 8-16 e-mails from my forums that the MySQL database is down. It's really starting to get annoying. Is mysql05.powweb.com constantly being serviced, or is it crashing frequently...? Or is it a cron job that's restarting it regularly? :confused:
Are you running a successful forum site ? Your database is likely not 'down' (you didn't show the actual error message), but I guess you are hitting the hourly resource limits. The limits are defined per database username. The workaround for this situation is to define the additional two database usernames permitted per database and randomly use any to connect to the server. This will triple your hourly usage.

Sample code: http://forum.powweb.com/showthread.php?s=&threadid=28309
Zacarias
10-6-05, 03:20 PM
mysql_connect(): Can't connect to MySQL server on 'mysql05.powweb.com' (49)

That's the error I get. I refreshed the page, and it works fine...
RTH10260
10-6-05, 08:08 PM
mysql_connect(): Can't connect to MySQL server on 'mysql05.powweb.com' (49)

That's the error I get. I refreshed the page, and it works fine...Couldn't find the error code '49' :( (which does not mean its documentation doesn't exist).

The intermittent error could be an indication that you are hitting the limits. It's a rolling one hour count, so s short time after failure a request would pass. If you haven't done it, I recommend that you try the three username approach.
Zacarias
10-13-05, 07:08 PM
I tried the three username approach.

Same thing. I'm beginning to think this is a server issue.

Oh, and the errors are all different sometimes.

mysql_connect(): Can't connect to MySQL server on 'mysql05.powweb.com' (60)
/htdocs/forum/includes/class_core.php on line 273


And for a forum with maybe a max of 10-12 users on at a time, this is pathetic.