'MySQL: Innodb Memory Usage Formula'
RustyRazorblade Consulting
1 min read
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)
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)
Related Posts
Need Expert Help with Apache Cassandra?
Get professional consulting for your distributed systems challenges. Performance optimization, architecture design, and troubleshooting.