Enabling Numa on mysql 5.6.50

MySQL & MariaDB Percona Server for MySQL 5.6
1

Hi,

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.

my.cnf

[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.

Thanks,
Jayesh

2

Firstly, you should upgrade to 5.7 as soon as possible. 5.6 is completely dead, no bug fixes, no security fixes, nothing.
Secondly, set innodb_numa_interleave and flush_caches to 1 for best NUMA setup.

3

Thank you !!

Noted and will upgrade to MySQL 5.7 soon.

Jayesh