This blog moved to medium->https://medium.com/@cocoamaemae

Sunday, May 6, 2018

Numa Architecture and innodb_buffer_pool_size

Event
e.g.
The machine spec
the number of processors: 2
RAM: 32GB

MySQL configuration
innodb_buffer_pool_size = 24GB

If these configurations, Numa architecture divide RAM each16GB. But innodb_buffer_pool_size is over 16GB, so there is possibility that swap occurs.
This event is called as "Swap Insanity".

How to solve

  • Deactivate Numa
  • Decrease innodb_buffer_pool_size

etc...

Reference
http://d.hatena.ne.jp/fat47/20121121/1353495937



No comments:

Post a Comment

Front End Development Tools

TaskRunner Tool executing multiple tasks by only one execution. Tasks are like CSS preprocessor, Transpire, Module Bundler, etc... e.g. ...