Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18860

innodb_numa_interleave is not available in CentOS7 packages

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.2.19, 10.2.22, 10.3.22, 10.2
    • N/A
    • Compiling
    • CentOS 7, CentOS 6, Ubuntu 18.04

    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   |
      +------------------------+-------+
      

      Attachments

        Issue Links

          Activity

            People

              dbart Daniel Bartholomew
              oli Oli Sennhauser
              Votes:
              3 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.