1 1
metalslug

Too many connections ?

Recommended Posts

On 11/1/2019 at 2:39 AM, Administrator said:

t's a bit of an annoyance we've been dealing with related to the MySQL server. We are working with the hosts to determine the cause and fix any future occurrences.

this is still happening. is there a fix planned?

Share this post


Link to post
Share on other sites

i looked into it a little, but couldn't find much specific about it, other than to raise the limit of concurrent connections.  ms sql has a limit of 32767 connections on a windows server, but i couldn't find anything specific on mysql, other than linux servers are limited to 1024 concurrent connections.  honestly, it sounds like a bandwidth issue.  since dz.com lost popularity, it may be that the bandwidth was decreased for some reason (not necessarily by you) and now needs increased, at least during peak times.  that is all just a guess though and i've been wrong before.

Share this post


Link to post
Share on other sites
2 hours ago, sfzombie13 said:

honestly, it sounds like a bandwidth issue. 

no it doesn't sound like that to me. bandwidth issues usually result in things running slow, taking too long to load etc. this problem is not like that.

if the result is a database connection issue, then it does seem to be persistent for some time. I don't know how number of database connections relate to how many users are making requests. 

Share this post


Link to post
Share on other sites

i am not that familiar with databases, but have been a network guy for years now.  researching this has led me to find that in mysql, the max number of connections is defaulted at 151, but can be increased to the limit of the os, and linux was listed as having 1024 max.  it didn't give the max for windows and that took a lot to find.  turns out that it depends on the number of cpu cores and amount of ram and that is is theoretically limited to 26+ billion connections but ms sql is limited to 32767 connections, but that isn't mysql.  after researching further, it looks like it may be reaching an os limit if hosted on a linux server instead of a windows server. 

Share this post


Link to post
Share on other sites
(edited)

I'm getting this almost every day.

 

I do wonder if people accessing the site via mobile and leaving their browser running on their phone is keeping a connection open.

 

Maybe try a timeout option that closes connections if they're inactive?

Edited by yoink
  • Like 5

Share this post


Link to post
Share on other sites
(edited)

Youink says in part:

Quote

'Maybe try a timeout option that closes connections if they're inactive?'

Good suggestion. Many websites do this to prevent Denial of Service attacks. In a simple version, it's when some jerk hacker opens a website so many times, and leaves those 'opens'...OPEN...that the server gets overloaded and crashes. This latest downtime lasted a while, between 18-22 hours I think. 

Edited by RobertMBlevins

Share this post


Link to post
Share on other sites

I noticed that when I log out of one computer, dz.com doesn't necessarily log me out of any other places where I was logged on. I wonder if people who use dynamic or semi-dynamic IP address locations have countless sessions left out there tying up our connection resources?

I've been out of this world for over 20 years, so please be gentle if this is a ridiculous suggestion.

Wendy P.

Share this post


Link to post
Share on other sites
On 8/13/2020 at 11:12 AM, wmw999 said:

I noticed that when I log out of one computer, dz.com doesn't necessarily log me out of any other places where I was logged on. I wonder if people who use dynamic or semi-dynamic IP address locations have countless sessions left out there tying up our connection resources?

I've been out of this world for over 20 years, so please be gentle if this is a ridiculous suggestion.

Wendy P.

you're close.  you don't have to be logged out when it closes, it just sends the connection specific info back to the server, sometimes the password, sometimes an authentication token, depending on how it's setup.  you are close though, as simply holding a window open can hold the connection, like when you forget to logout of an rdp session and was mentioned above as a dos attack.  like if you have a mobile browser open as someone else above said, it could keep a window open and active, which would cause them to fill up.  it seems to me that with the amount of posts on here, it may have something to do with changing the hosting or limiting the number of connections somehow due to the switch in forum software when they changed up, but it could be the new forum software itself.  l liked the look of the old site way better, that was how i will forever judge forums.

Share this post


Link to post
Share on other sites
On 2/15/2021 at 12:02 PM, wmw999 said:

There never are posts as far as I know. This is a periodic issue, and it seems mysterious to everyone. I know that Meso has looked at it a lot.

Wendy P.

ya know, it could be connections held open by internet scans or something like that.  some sort of a dos attack exploiting a vulnerability in the software that needs patched.  i have done that before with a scanner sending malformed packets that open a connection and hold it when the server is waiting on a response that never comes.  i'd be curious to see a packet capture from the server when it happens. 

Share this post


Link to post
Share on other sites

The latest example of the site being unavailable lasted about 24 hours. And no one is willing to comment on WTF the problem is. Does no one monitor the site? What makes it come back? If I was buying advertising here I would start reconsidering that decision.
 

Is there anything I can do to help?

Share this post


Link to post
Share on other sites
On 2/27/2021 at 11:02 AM, JoeWeber said:

Inconvenient for us, yes, but such a loss for the greater world is just heartbreaking.

Wow, this is disappointing. If you want a healthy membership, this attitude won't get you one or help you maintain it.

Share this post


Link to post
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.
Note: Your post will require moderator approval before it will be visible.

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.

1 1