This is because some of the memory out of the total DBInstanceClassMemory is reserved for the underlying OS operations. Note that the default number of max_connections calculated using the formula might vary slightly from the number of default connections returned from the preceding command. A DB instance class with more available memory supports a larger number of database connections. The default value of max_connections for both RDS for MySQL and RDS for PostgreSQL depends on the instance class used by the Amazon RDS instance. To check the current value for max_connections, run the following command after connecting to your Amazon RDS for PostgreSQL instance: postgres=> show max_connections By default, the max_connections parameter is based on the following formula in Amazon RDS for PostgreSQL (calculated from the DBInstanceClassMemory value): max_connections = LEAST(, 5000) In Amazon RDS for PostgreSQL, the max_connections metric monitors the set maximum number of concurrent connections. To check the current value of max_connections, run the following command after connecting to your Amazon RDS for MySQL instance: SHOW GLOBAL VARIABLES LIKE 'max_connections' In Amazon RDS for MySQL, the max_connections metric monitors the set maximum number of (allowed) simultaneous client connections.īy default, the max_connections parameter is based on the following formula in Amazon RDS for MySQL (calculated from the DBInstanceClassMemory value): max_connections = DBInstanceClassMemory/12582880 Resolution View the current max_connections value
0 kommentar(er)
