Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Software Development
Programming
Programming Q&A
What is causing these insane database connection spikes?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Markshall" data-source="post: 466982" data-attributes="member: 1872"><p>This was the most appropriate section I could find for this post, feel free to move if not.</p><p></p><p>My issue is that I maintain a few websites that are all built on WordPress (I know...), which for the most part is good at what it does. The servers are EC2 instances on AWS and the database is an RDS instance, also on AWS. Every now and again, I notice a huge increase in connections to the database coming from one of the websites.</p><p></p><p>What I want to know is, what <em>counts</em> as a connection? How is a connection actually <em>established</em>? At what point is a connection <em>made</em>? Hopefully finding this out will possibly help me understand how this issue is happening. I’ve been programming for over 15 years now so you’d think I should know this, well, I think I should know this.</p><p></p><p>The only users who should see dynamic content are logged in users—thus should be connected to the database, as they are editing content and viewing the pages as an admin. Any unauthorised users see static HTML pages generated by a plugin (W3TC), so I’m under the assumption that no connection is being made to the database there.</p><p></p><p>Due to this, I’ve ruled out the possibility of there being too many people viewing the website at 1 time. So I’m stuck thinking if it’s a plug-in being used that is faulty? Maybe WordPress itself is running jobs in the background that is causing it?</p><p></p><p>These spikes in connections are huge, I can often see 200-300+ connections just spawn out of nowhere. I have an alarm set up in RDS to email me when the connections are rising, that’s when I go to check and see that it’s coming from just one website.</p><p></p><p>Any help from you lovely bunch of nerds would be great. Thanks.</p><p></p><p>Edit: paging the expertise of the likes of [USER=8605]@TesoMayn[/USER], [USER=24874]@Ecko[/USER], [USER=1]@RastaLulz[/USER], [USER=591]@Sledmore[/USER] and [USER=6113]@Macemore[/USER] here</p></blockquote><p></p>
[QUOTE="Markshall, post: 466982, member: 1872"] This was the most appropriate section I could find for this post, feel free to move if not. My issue is that I maintain a few websites that are all built on WordPress (I know...), which for the most part is good at what it does. The servers are EC2 instances on AWS and the database is an RDS instance, also on AWS. Every now and again, I notice a huge increase in connections to the database coming from one of the websites. What I want to know is, what [I]counts[/I] as a connection? How is a connection actually [I]established[/I]? At what point is a connection [I]made[/I]? Hopefully finding this out will possibly help me understand how this issue is happening. I’ve been programming for over 15 years now so you’d think I should know this, well, I think I should know this. The only users who should see dynamic content are logged in users—thus should be connected to the database, as they are editing content and viewing the pages as an admin. Any unauthorised users see static HTML pages generated by a plugin (W3TC), so I’m under the assumption that no connection is being made to the database there. Due to this, I’ve ruled out the possibility of there being too many people viewing the website at 1 time. So I’m stuck thinking if it’s a plug-in being used that is faulty? Maybe WordPress itself is running jobs in the background that is causing it? These spikes in connections are huge, I can often see 200-300+ connections just spawn out of nowhere. I have an alarm set up in RDS to email me when the connections are rising, that’s when I go to check and see that it’s coming from just one website. Any help from you lovely bunch of nerds would be great. Thanks. Edit: paging the expertise of the likes of [USER=8605]@TesoMayn[/USER], [USER=24874]@Ecko[/USER], [USER=1]@RastaLulz[/USER], [USER=591]@Sledmore[/USER] and [USER=6113]@Macemore[/USER] here [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Software Development
Programming
Programming Q&A
What is causing these insane database connection spikes?
Top