Announcement

Announcement Module
Collapse
No announcement yet.

Calculate ram usage of max_connections?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Calculate ram usage of max_connections?

    Hi,

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

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

    Comment


    • #3
      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


      • #4
        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

        Working...
        X