'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.

innodb_buffer_pool_size

  • key_buffer_size
  • max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size +2MB)