'MySQL: Innodb Memory Usage Formula'

I hate looking for this….

This will give you a rough idea of your innodb memory usage. I know it’s in a hundred spots, but i hate looking for it when i double check things.


  • key_buffer_size
  • max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size +2MB)
If you found this post helpful, please consider sharing to your network. I'm also available to help you be successful with your distributed systems! Please reach out if you're interested in working with me, and I'll be happy to schedule a free one-hour consultation.