MySQL Forums
Forum List  »  Other Migration

Re: How many connections are possible with Aiven for MySQL?
Posted by: Lisa Vielchen
Date: November 24, 2020 11:23AM

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:

Options: ReplyQuote

Written By
Re: How many connections are possible with Aiven for MySQL?
November 24, 2020 11:23AM

Sorry, only registered users may post in this forum.

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.