Jump to content

Finding the min & max RAM needed by MySQL


brashquido

Recommended Posts

Hi All,

 

Trying to size a server for MySQL and looking for equations to use to figure out the minimum amount of RAM MySQL is going to use, and more importantly what the maximum amount of RAM is going to be used. I can't seem to find anything about finding the minimum amount of RAM required, but I found this equation for finding the maximum amount of RAM on the Drupal website;

 

key_buffer + innodb_buffer_pool + innodb_log_buffer + innodb_additional_mem_pool + net_buffer + max_connections * (read_buffer + join_buffer + sort_buffer + myisam_sort_buffer + thread_stack + tmp_table_size + read_rnd_buffer)

 

I'm not sure how accurate that is though, as according to my math (which isn't great) that would mean I need somewhere around 8.8 million gigbytes of RAM. Could someone please point me in the right direction?

Link to comment
https://forums.phpfreaks.com/topic/41450-finding-the-min-max-ram-needed-by-mysql/
Share on other sites

It's a concern because if you configure MySQL to be able to consume more physical memory than what you have got then at some stage you are going to hit a brick wall. Especially when MySQL is not on a dedicated server you are headed for all sorts of contention issues if you don't do your homework. I've since been looking at Monyog, which although still only in beta uses a different equation for calculating the max;

 

key_buffer + innodb_buffer_pool + max_connections * (read_buffer + sort_buffer + binlog_cache_size) + max_connections * 2MB

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.