Re: How many connections are possible with Aiven for MySQL?
By connections, do you mean those that occur simultaneously? Because that is a bit difficult to answer.
The maximum number of concurrent connections in Aiven for MySQL depends on the total memory on the server.
In Aiven, as far as I know, 75 connections are allowed per 1 gibibyte of usable memory. -> Usable memory = total memory of the node - operating system and management overhead (about 350 mebibytes).
For example, if a server has 4 gibibibytes of memory, you get 75 * 4 = 300 connections maximum.
You should note that the setting in MySQL max-connections is always set 1 higher (in the example in this case 301 connections max). This is because normally there is always a system process that needs one of the connections. More information can be found on the official site:
https://aiven.io/mysql
Subject
Views
Written By
Posted
659
November 24, 2020 08:51AM
Re: How many connections are possible with Aiven for MySQL?
417
November 24, 2020 11:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.