[MDEV-18860] innodb_numa_interleave is not available in CentOS7 packages Created: 2019-03-08  Updated: 2020-03-31  Resolved: 2020-03-31

Status: Closed
Project: MariaDB Server
Component/s: Compiling
Affects Version/s: 10.2.19, 10.2.22, 10.3.22, 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Oli Sennhauser Assignee: Daniel Bartholomew
Resolution: Won't Fix Votes: 3
Labels: innodb_numa_interleave, numa
Environment:

CentOS 7, CentOS 6, Ubuntu 18.04

Issue Links:
Blocks
blocks MDEV-10829 Enable Innodb NUMA interleave - (and ... Closed
blocks MDEV-16483 Docu Bug innodb_numa_interleave Closed
Duplicate
is duplicated by MDEV-21399 Unknown variable 'innodb_numa_interle... Closed
Problem/Incident
causes MDEV-18954 numa dynamic dependency Closed

 Description   

The server variables innodb_numa_interleave is not available for CentOS 7 x86_64 bit packages but it is for generic binaryies.

Docu:
https://mariadb.com/kb/en/library/innodb-system-variables/#innodb_numa_interleave

CentOS 7:

MariaDB [(none)]> show global variables like '%version%';
 
+-------------------------+---------------------------------+
 
| Variable_name           | Value                           |
 
+-------------------------+---------------------------------+
 
| innodb_version          | 5.7.25                          |
 
| protocol_version        | 10                              |
 
| slave_type_conversions  |                                 |
 
| version                 | 10.2.22-MariaDB                 |
 
| version_comment         | MariaDB Server                  |
 
| version_compile_machine | x86_64                          |
 
| version_compile_os      | Linux                           |
 
| version_malloc_library  | system                          |
 
| version_ssl_library     | OpenSSL 1.0.1e-fips 11 Feb 2013 |
 
| wsrep_patch_version     | wsrep_25.24                     |
 
+-------------------------+---------------------------------+


MariaDB [(none)]> show global variables like '%numa%';
 
 
 
[root@centos7tpl log]# rpm -aq | grep mariadb -i
 
MariaDB-compat-10.2.22-1.el7.centos.x86_64
 
MariaDB-server-10.2.22-1.el7.centos.x86_64
 
MariaDB-common-10.2.22-1.el7.centos.x86_64
 
MariaDB-client-10.2.22-1.el7.centos.x86_64
 
[root@centos7tpl log]# yum info MariaDB-server
 
Loaded plugins: fastestmirror
 
Loading mirror speeds from cached hostfile
 
 * base: mirror.init7.net
 
 * extras: mirror.init7.net
 
 * updates: mirror.init7.net
 
Installed Packages
 
Name        : MariaDB-server
 
Arch        : x86_64
 
Version     : 10.2.22
 
Release     : 1.el7.centos
 
Size        : 467 M
 
Repo        : installed
 
From repo   : mariadb
 
Summary     : MariaDB: a very fast and robust SQL database server
 
URL         : http://mariadb.org
 
Licence     : GPLv2
 
Description : 
            : 
            : It is GPL v2 licensed, which means you can use the it free of charge under the
 
            : conditions of the GNU General Public License Version 2 (http://www.gnu.org/licenses/).
 
            : 
            : MariaDB documentation can be found at https://mariadb.com/kb
 
            : MariaDB bug reports should be submitted through https://jira.mariadb.org

But it is for generic Binaries on Ubuntu 16.04:

root@mariadb-102 [(none)] SQL> show global variables like '%version%';
 
+-------------------------+---------------------+
 
| Variable_name           | Value               |
 
+-------------------------+---------------------+
 
| innodb_version          | 5.7.22              |
 
| protocol_version        | 10                  |
 
| slave_type_conversions  |                     |
 
| version                 | 10.2.15-MariaDB-log |
 
| version_comment         | MariaDB Server      |
 
| version_compile_machine | x86_64              |
 
| version_compile_os      | Linux               |
 
| version_malloc_library  | system              |
 
| version_ssl_library     | YaSSL 2.4.4         |
 
| wsrep_patch_version     | wsrep_25.23         |
 
+-------------------------+---------------------+


root@mariadb-102 [(none)] SQL> show global variables like '%numa%';
 
+------------------------+-------+
 
| Variable_name          | Value |
 
+------------------------+-------+
 
| innodb_numa_interleave | OFF   |
 
+------------------------+-------+



 Comments   
Comment by Elena Stepanova [ 2019-03-09 ]

The headers aren't installed on CentOS 7 (at least 7.4):

Looking for include file numa.h
 
-- Looking for include file numa.h - not found
 
-- Looking for include file numaif.h
 
-- Looking for include file numaif.h - not found
 
-- WITH_NUMA=AUTO: NUMA memory allocation policy disabled

On Trusty bintar builder, they are:

-- Looking for include file numa.h
 
-- Looking for include file numa.h - found
 
-- Looking for include file numaif.h
 
-- Looking for include file numaif.h - found

Comment by Daniel Bartholomew [ 2019-03-11 ]

Looks like on rpm-based systems the package to install is numactl-devel

I assume we need this on all of our rpm builders, not just CentOS 7?

Comment by Daniel Bartholomew [ 2019-03-12 ]

Installed the numactl-devel on the following VMs:

  • centos6-amd64
  • centos6-i386
  • centos73-amd64
  • centos74-amd64
  • fedora28-amd64
  • fedora29-amd64
  • rhel8-amd64

Installed libnuma-devel on the following VMs:

  • sles123-amd64
  • sles150-amd64
  • opensuse423-amd64
  • opensuse150-amd64
Comment by Sergei Golubchik [ 2019-04-01 ]

libnuma is installed, but disabled by default in the server sources. To enable it, we need a different fix for MDEV-18954 first

Comment by brianr [ 2019-07-10 ]

Any ideas on when this innodb_numa_interleave will be available for centos7?

Comment by Daniel Bartholomew [ 2020-03-31 ]

Closing this (and MDEV-21399) as "Won't Fix" because enabling libnuma will add a dependency to our 10.2 and 10.3 packages, which is a big no-no for stable releases. If you really need this you'll need to compile your own packages or bintars.

Generated at Thu Feb 08 08:47:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.