Re:MySQL server memory usage troubleshooting tips
by isalmon on Friday January 24, 2014 @01:24PM
(#7116450)
I usually use this tool: http://www.mysqlcalculator.com/
It's not perfect by any means but gives you a pretty good idea
[ Parent
| on HN ]
Re:MySQL server memory usage troubleshooting tips
by morgo on Friday January 24, 2014 @02:46PM
(#7117437)
Yeah, the MySQL 5.6 defaults are quite different to the ones mentioned here. Also:
- the query cache is now off by default (but 1M)
- innodb_additional_mem_pool_size no longer applies.
- some of the per-session variables can actually allocate more than once (or not at all).
- There is fixed memory allocated for performance_schema per thread.