Jump to content

Jason & Co...


Steff

Recommended Posts

  • Replies 75
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

max_connections=eleventy billion

 

Web sites like this that use Mysql have a hard time hanging up connections. You could have some serious hardware and still have problems during a spike. Its hard for them to plan the sites server size based on a few times a year. Some maintenance might clean some of it up, but unless they have been seeing issues for a while it could be just isolated to all of the traffic lately due to the sox slumping and the close games.

Link to comment
Share on other sites

QUOTE(southsideirish71 @ Aug 25, 2005 -> 09:23 PM)
max_connections=eleventy billion

 

Web sites like this that use Mysql have a hard time hanging up connections.  You could have some serious hardware and still have problems during a spike.  Its hard for them to plan the sites server size based on a few times a year.  Some maintenance might clean some of it up, but unless they have been seeing issues for a while it could be just isolated to all of the traffic lately due to the sox slumping and the close games.

When you people hit refresh 15 bazillion times to find out what happens in a game thread, you get too many connections.

 

Trust me, the server's fine. Waaaay fine. It's the database and the response time from it.

Link to comment
Share on other sites

QUOTE(kapkomet @ Aug 25, 2005 -> 04:29 PM)
When you people hit refresh 15 bazillion times to find out what happens in a game thread, you get too many connections.

 

Trust me, the server's fine.  Waaaay fine.  It's the database and the response time from it.

I do content mgmt for some of the largest companies in the world, if you would like some help......... :P

Link to comment
Share on other sites

QUOTE(kapkomet @ Aug 25, 2005 -> 05:29 PM)
When you people hit refresh 15 bazillion times to find out what happens in a game thread, you get too many connections.

 

Trust me, the server's fine.  Waaaay fine.  It's the database and the response time from it.

:huh: You couldn't just say "posters"? Some take offense to that.

 

Not me, but some do.

Link to comment
Share on other sites

QUOTE(kapkomet @ Aug 25, 2005 -> 03:29 PM)
When you people hit refresh 15 bazillion times to find out what happens in a game thread, you get too many connections.

 

Trust me, the server's fine.  Waaaay fine.  It's the database and the response time from it.

 

 

I have two highly hit servers on the net for work that have the same issue. They have plenty I mean plenty of everything. Its the refresh issue and connections getting hung up.

 

You can throw lots of hardware at it, for a spike that happens during a game once in a great while or when the sox lose a few and everyone is cranky.

Link to comment
Share on other sites

QUOTE(southsideirish71 @ Aug 25, 2005 -> 09:34 PM)
I have two highly hit servers on the net for work that have the same issue.  They have plenty I mean plenty of everything.  Its the refresh issue and connections getting hung up. 

 

You can throw lots of hardware at it, for a spike that happens during a game once in a great while or when the sox lose a few and everyone is cranky.

The load on the server is 0.50 during the spikes. The processor(S) and the bandwidth is fine. MySQL is a piece of crap. That's all.

Link to comment
Share on other sites

QUOTE(SoxFan1 @ Aug 25, 2005 -> 09:31 PM)
:huh: You couldn't just say "posters"? Some take offense to that.

 

Not me, but some do.

Dude, I was hitting refresh like a man possessed too. That's what happens.

 

If you hit refresh, and then you hit refresh AGAIN while that command was being processed against the database, your first refresh hangs the software up. That's what makes it bog down and get too many connection errors. Does that explain it a little better?

 

Unless we go to a full version of SQL, ya'll are going to have to deal with it, because we don't exactly have $5K sitting around to do that.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.

×
×
  • Create New...