 Site occasionally on the blink |
|
|||||||||
  |
 Jan 11 2005, 03:06 AM
Post
#1
|
|
|
Advanced Member  Group: Advanced Members Posts: 588 Joined: 23-December 03 From: Sterling, IL Member No.: 7  |
On a couple different days, I get a sql error when I try to load the site. Any news?
|
 |
 
|
|
Jan 11 2005, 04:00 AM
Post
#2
|
|
|
FRRAX Owner/Admin Group: Admin Posts: 15,394 Joined: 13-February 04 From: Ohio Member No.: 196 |
I put in trouble tickets with the hosting company. They say all is well (all is not well). It comes back up when their server decides it's in the mood. I'm going to keep tabs on it for a while and if this keeps up, I may look at changing hosting compaines (I hate to move the board if I can avoid the hassle, but I hate the sudden downtime too).
|
|
|
|
|
Jan 11 2005, 04:52 PM
Post
#3
|
|
|
Really Old Corner Carver Group: Advanced Member Posts: 1,209 Joined: 24-December 03 From: Atlanta Ga Member No.: 21 |
I haven't had a problem. Wonder if it's another DNS issue?
|
|
|
|
|
Jan 11 2005, 04:56 PM
Post
#4
|
|
|
FRRAX Owner/Admin Group: Admin Posts: 15,394 Joined: 13-February 04 From: Ohio Member No.: 196 |
I've been seeing "My SQL" errors. One was "Too many connections" and I was advised that it looks like we may be sharing a server with something "big" and they maxed out the connections to the server. But, they have all been different, I've got some of the e-mails at home with the errors on them I can send you Steve.
It's a random server issue as far as I can tell. The host says it's fine. I'm watching it for now. I'm not sure where I'll go if I move though. |
|
|
|
|
Jan 11 2005, 05:07 PM
Post
#5
|
|
|
Advanced Member Group: Advanced Members Posts: 452 Joined: 12-January 04 From: Charleston, SC Member No.: 121 |
It seems that mysql isn't configured properly, and it just doesn't know how to handle many db connections in parallel. The server load itself is low, so I would rule out speed issues. Maybe mysql needs to get 'bumped up' to run of my-huge.cnf, or some socket/shared memory settings need to get adjusted. Who knows, I'd have to get on the box and look.
Can this board work with PostgreSQL? I've converted all my mysql stuff to that, and I haven't had a problem since. |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 27th April 2024 - 08:24 AM |