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