Tuesday, June 5, 2012

Find out how many concurrent connections Amazon RDS can support

So you have a running RDS (mysql) instance for which you want to find out:


1. Number of Concurrent connections this RDS can support. 


    From command line login to the RDS DB. 
    Now run the command: 


    show variables like '%conn%';


      This command will list down the max concurrent sessions that can be made to this RDS DB.
      This is quite useful when you want to see and tune your applications connection pools for DB. 


2. List down the current concurrent connections. 


    Try: 


    show processlist;


    This lists down various processes that are connected to this RDS currently. 

No comments:

Post a Comment