Sample Header Ad - 728x90

What is the meaning of "available RAM" for calculating MySQL max_connections

1 vote
4 answers
898 views
The question was asked previously, "how do I calculate MySQL max_connections" and this was the answer: > max_connections = (Available RAM - Global Buffers) / Thread Buffers Since I don't have enough reputation to add a comment to the existing question I had to ask a brand new question. I can get the buffer values by executing : SHOW VARIABLES LIKE '%buffer%'; but what is the available RAM part of this equation exactly? Is this value in bytes, kilobytes, megabytes? Something else? Also, do I use the available RAM shown in the resource monitor while my site is being used, or do I need to use the total amount of RAM installed on the machine?
Asked by Vincent (389 rep)
Oct 8, 2014, 02:13 PM
Last activity: Jun 14, 2023, 12:55 PM