Calculate ram usage of max_connections?


I need to calculate how much memory a raise of max_connections the mysqld will consume. Got any tips?

Increasing number of max_connections does not cause more RAM usage (while connections are not used).

But they do if they are in use, and I’d like to calculate the consequence of a significant raise.

based on a case where nearly all are in use…

Hmm, it depends on what are clients really doing… Without knowing it it’s not possible to say anything about RAM usage. Just imagine, for example, one client can do select which will create temporary table, and it will use a lot of RAM. And another client can do nothing, just keep connection open, and so on…