3

What is meaning of DB Connections(Count) report on AWS RDS? I have gone through their documentation but didn't find my answer there.

I am quite confused with DB Connection report on my AWS. I can see their only 1 connection available but I am sure that there are always 100-150 concurrent users on my website on different pages which users database operation.

As the user concurrency is 100-150 then why it shows me only 1 connection on report.

Note : My website is working well on good performance. enter image description here

Bhushankumar Lilapara
  • 780
  • 1
  • 13
  • 26
  • 1
    Question your premises: Does a single user on your web application *necessarily* equate to a single database connection? Should you be using the 'Sum' statistic instead of 'Maximum'? Is it reasonable that, at any given instant that this 1-minute sampling would occur, that only 1 or 2 connections would be open? Have you accounted for things like connection pooling? – Anthony Neace Jan 22 '15 at 18:45

1 Answers1

5

The database connection count is exactly what it sounds like: "The number of database connections in use."

It's a count, so it shouldn't be summed. Maximum or averaging are recommended. It may be registering low because you have a very efficient database pool, have server-level caching, or are looking at the wrong database in your statistics.

tedder42
  • 23,519
  • 13
  • 86
  • 102