# Enabling Numa on mysql 5.6.50

**URL:** <https://forums.percona.com/t/enabling-numa-on-mysql-5-6-50/9177>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [February 9, 2021, 8:55am UTC](https://forums.percona.com/t/enabling-numa-on-mysql-5-6-50/9177 "2021-02-09T08:55:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jayesh\_Labade](https://avatars.discourse-cdn.com/v4/letter/j/ce73a5/32.png) [@Jayesh\_Labade](https://forums.percona.com/u/Jayesh_Labade)\
**Post date:** [February 9, 2021, 8:55am UTC](https://forums.percona.com/t/enabling-numa-on-mysql-5-6-50/9177/1 "2021-02-09T08:55:12Z")

</div>

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](https://www.percona.com/doc/percona-server/5.6/performance/innodb_numa_support.html) “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

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [February 9, 2021, 2:37pm UTC](https://forums.percona.com/t/enabling-numa-on-mysql-5-6-50/9177/2 "2021-02-09T14:37:30Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Jayesh\_Labade](https://avatars.discourse-cdn.com/v4/letter/j/ce73a5/32.png) [@Jayesh\_Labade](https://forums.percona.com/u/Jayesh_Labade)\
**Post date:** [February 9, 2021, 3:30pm UTC](https://forums.percona.com/t/enabling-numa-on-mysql-5-6-50/9177/3 "2021-02-09T15:30:20Z")

</div>

Thank you !!

Noted and will upgrade to MySQL 5.7 soon.

Jayesh