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.