I have 100G of RAM and 70G configured as innodb buffer pool. But after few days of usage swapping started.
I wanted to enable NUMA support in percona mysql server 5.6.50-90.
As per PerconaLink “Variables innodb_buffer_pool_populate and numa_interleave were reverted to their original implementation due to upstream variant being less effective in memory allocation.”
Now I am confused about which variables to use in my.cnf in order to enable NUMA.
My current my.cnf is as below. Do i need flush_caches,numa_interleave and innodb_buffer_pool_populate along with innodb_numa_interleave OR just innodb_numa_interleave is enough to handle NUMA stuff.
[mysqld_safe] flush_caches = 1 numa_interleave = 1 [mysqld] innodb_buffer_pool_populate = ON innodb_numa_interleave = ON
Please point me in the right direction.