0
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

I got the "too many connections" message most of the day yesterday, and it seems that there's a 22 hour gap in posts on every forum, so it seems there's something more going on than too many people being connected.

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

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.

0