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



Numa Architecture

What's Numa Architecture
Numa is the abbreviation of "non-uniform memory access".
The objective of Numa is parallelization of *bus.
Numa is an alternative approach that links several small *nodes.

*bus to connect between cpu and RAM.
*node means a pair of processor and RAM.

Features
If Numa architecture is adopted, RAM is divided by the number of bus and accessed.

e.g.
If there are 2 buses on the machine which has 32GB RAM, RAM is divided per 16GB and accessed.



Front End Development Tools

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