If you use InnoDB, make sure to set innodb_buffer_pool_populate to 1. This will do a real allocation of all the buffer pool size to avoid further imbalance. -GL 2015-08-05 4:12 GMT+02:00 Jean Weisbuch <jean@phpnet.org>:
You might want to enable "numa interleave" for Maria (if your instance will use more than the memory of a single physical CPU for example), for that you can pass the option "--numa-interleave" to mysqld_safe or simply add "numa_interleave" in the configuration under the "[mysqld_safe]" section. Dont forget to install the "numactl" package before if you dont want to end up having MariaDB to fail to (re)start as its required to enable the "numa_interleave" option.
Its usually better to use this approach to inverleave only what you decide to rather than forcing it system-wide on the bios.
Le 05/08/2015 03:55, Daniel Black a écrit :
----- On 5 Aug, 2015, at 8:24 AM, roberto roberto@spadim.com.br wrote:
Hi guys i'm comfiguring linux kernel, there's some valid numa comfig at
kernel to check?
Why? Most distro kernels have most options enabled including NUMA support.
It's a xeon server with 2 cpu and 10cores each
$ numactl --hardware
shows hardware. E.g the following from a non numa.
available: 1 nodes (0) node 0 cpus: 0 1 2 3 node 0 size: 11905 MB node 0 free: 437 MB node distances: node 0 0: 10
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp