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

Subscribe to: Post Comments (Atom)

Front End Development Tools

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

  • MySQL, MariaDB partitioning
    What is partitioning? The structure which divides one table data to multiple data. When not using partitioning, one table data is aggrega...
  • Best practice when merging multiple git branches
    It is general to create multiple branches and manage them parallel when we do the development by using git. Multiple branches should be mer...
  • Regarding URL encode
    What's URL encode? URL can be sent only ASCII characters over internet. When doing http request with query parameters, query parameter...