Hey everyone, I've been dealing with some intense traffic surges that lead to high connection counts on my RDS database. To keep tabs on this, I've set up CloudWatch metrics for the database connection count since it can sometimes hit the default limit. However, I'm wondering if there's a way to increase the frequency of updates for the connection count metric, as the default is every 60 seconds? I tried reducing the Enhanced Monitoring rate to 10 seconds, but it seems like that only updates OS metrics, not the database connections. I know I can raise the connection limit, but I'd prefer to avoid that until I've exhausted other options. So, is there any way to get more timely updates on database connection counts?
1 Answer
It sounds like you're trying to monitor your connections in real-time, which is totally valid. However, metrics are mainly meant for spotting trends and issues over time, rather than real-time monitoring. If you’re hitting the max connections, logs are your best bet for diagnosing that, and you might want to focus on your averages and resource usage instead. If those look okay, then consider increasing your max connections. Just remember, real-time counting might not solve your underlying issues.
I get that, but I really need to see how close I am to the limit in real-time. If I only update every minute, I might miss a critical point where it jumps from manageable to critical.