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

Enable Innodb NUMA interleave - (and only use available nodes)

Details

    Description

      innodb_numa_interleave is dormant because of missing cmake tests to enable it.

      If enabled innodb_numa_interleave=1 by default tries to interleave over all nodes.

      Due to user defined constraints in systemd, containers or otherwise mysqld could of been limited to a smaller set of cpus.

      By doing the function call numa_get_mems_allowed rather than assuming all nodes are available the allowed number nodes can be allocated from.

      See linked github pull requests.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18860 innodb_numa_interleave is not available in CentOS7 packages

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11195 NUMA does not get enabled even when checks are passed

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-5774 Enable numa interleaving by default when required conditions are met

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black added a comment -

            Seems the cmake components needed to detect numa and enable the innodb_numa_interleave variable/feature are missing.

            I'll get these prepared.

            danblack Daniel Black added a comment - Seems the cmake components needed to detect numa and enable the innodb_numa_interleave variable/feature are missing. I'll get these prepared.
            danblack Daniel Black added a comment -

            github pr 238 enables the dormant innodb_numa_interleave that is already in xtradb/innodb

            github pr 236 alters the existing xtradb/innodb implementation of the innodb_numa_interleave to use all available nodes rather than all nodes.

            danblack Daniel Black added a comment - github pr 238 enables the dormant innodb_numa_interleave that is already in xtradb/innodb github pr 236 alters the existing xtradb/innodb implementation of the innodb_numa_interleave to use all available nodes rather than all nodes.
            danblack Daniel Black added a comment -

            too invasive to do static libnuma against 10.1 - just 10.2 is fine.

            danblack Daniel Black added a comment - too invasive to do static libnuma against 10.1 - just 10.2 is fine.

            People

              jplindst Jan Lindström (Inactive)
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.