brashquido Posted March 6, 2007 Share Posted March 6, 2007 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? Quote Link to comment https://forums.phpfreaks.com/topic/41450-finding-the-min-max-ram-needed-by-mysql/ Share on other sites More sharing options...
fenway Posted March 7, 2007 Share Posted March 7, 2007 I've never seem such a calculation... could you post the link? Quote Link to comment https://forums.phpfreaks.com/topic/41450-finding-the-min-max-ram-needed-by-mysql/#findComment-202018 Share on other sites More sharing options...
brashquido Posted March 12, 2007 Author Share Posted March 12, 2007 It's in the Drupal snippet; http://drupal.org/node/50291 Quote Link to comment https://forums.phpfreaks.com/topic/41450-finding-the-min-max-ram-needed-by-mysql/#findComment-205428 Share on other sites More sharing options...
fenway Posted March 13, 2007 Share Posted March 13, 2007 Why is this such a concern? It'll use as much memory as it has. Quote Link to comment https://forums.phpfreaks.com/topic/41450-finding-the-min-max-ram-needed-by-mysql/#findComment-205947 Share on other sites More sharing options...
brashquido Posted March 13, 2007 Author Share Posted March 13, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/41450-finding-the-min-max-ram-needed-by-mysql/#findComment-206438 Share on other sites More sharing options...
fenway Posted March 13, 2007 Share Posted March 13, 2007 True, I've never run on anything but a dedicated server.. .but I'd imagine that any VPS has intelligent limits that you can't change anyway. Quote Link to comment https://forums.phpfreaks.com/topic/41450-finding-the-min-max-ram-needed-by-mysql/#findComment-206462 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.