Skip to content

Instantly share code, notes, and snippets.

@lichti

lichti/ MySQL-RAM-Usage.md

Last active November 18, 2015 15:49
Show Gist options
  • Save lichti/6e58f01bbd25c850f491 to your computer and use it in GitHub Desktop.
Save lichti/6e58f01bbd25c850f491 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL RAM Usage
Raw
MySQL-RAM-Usage.md

MySQL RAM Usage:

server_buffers + total_per_thread_buffers * max_connections

server_buffers = key_buffer_size + innodb_buffer_pool_size + innodb_additional_mem_pool_size + innodb_log_buffer_size + query_cache_size

total_per_thread_buffers = read_buffer_size + read_rnd_buffer_size + sort_buffer_size + thread_stack + join_buffer_size
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment