Hi,
I need to calculate how much memory a raise of max_connections the mysqld will consume. Got any tips?
I need to calculate how much memory a raise of max_connections the mysqld will consume. Got any tips?
-
Contributor- Apr 2008
- 12
-
Advisor
- Mar 2008
- 95
Increasing number of max_connections does not cause more RAM usage (while connections are not used). -
Contributor
- Apr 2008
- 12
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..Comment
-
Advisor
- Mar 2008
- 95
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..Comment
Comment