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

/usr/bin/mysqld_safe doesn't have NUMA options support

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.33a
    • 5.5.34
    • None
    • None

    Description

      MariaDB-server 5.5.33a doesn't support NUMA options in /usr/bin/mysqld_safe

      http://www.percona.com/doc/percona-server/5.5/performance/innodb_numa_support.html

      Note that these options present in MariaDB-Galera-server 5.5.33a

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-5507 Add the possibility set default parameters passed to mysqld_safe on the init script

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

          Activity

            Ascending order - Click to sort in descending order
            aleksey.sanin Aleksey Sanin (Inactive) created issue -
            elenst Elena Stepanova added a comment -

            Assigned to Jan as apparently InnoDB-related, not as Galera-related.

            elenst Elena Stepanova added a comment - Assigned to Jan as apparently InnoDB-related, not as Galera-related.
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Fix Version/s 5.5.34 [ 13700 ]
            Assignee Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) added a comment - - edited

            Yes, there is general new numa option for mysqld_safe that launches mysqld with numactl using numactl --interleave=all. I have not experience how useful that option is because it requires hardware supporting numactl.

            Percona has introduced some additional configuration parameters for InnoDB to further support numa. All these options are available if you use xtradb storage engine not Oracle InnoDB storage engine.

            I will leave the decision about mysqld_save for someone else.

            jplindst Jan Lindström (Inactive) added a comment - - edited Yes, there is general new numa option for mysqld_safe that launches mysqld with numactl using numactl --interleave=all. I have not experience how useful that option is because it requires hardware supporting numactl. Percona has introduced some additional configuration parameters for InnoDB to further support numa. All these options are available if you use xtradb storage engine not Oracle InnoDB storage engine. I will leave the decision about mysqld_save for someone else.
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Rasmus Johansson [ ratzpo ]
            elenst Elena Stepanova made changes -
            Assignee Rasmus Johansson [ ratzpo ] Sergei Golubchik [ serg ]
            aleksey.sanin Aleksey Sanin (Inactive) added a comment -

            These options are very useful: http://blog.jcole.us/2010/09/28/mysql-swap-insanity-and-the-numa-architecture/

            We've had numerous swap usage alerts on the standalone MariaDB machine until we figured out that these options are not implemented in "pure" MariaDB (and are implemented in MariaDB-Galera):

            • Before the change (N0 is overloaded when N1 is empty)
            1. perl numa-maps-summary.pl < /proc/24432/numa_maps
              N0 : 8034951 ( 30.65 GB)
              N1 : 2288796 ( 8.73 GB)
              active : 69235 ( 0.26 GB)
              anon : 10301726 ( 39.30 GB)
              dirty : 10301756 ( 39.30 GB)
              mapmax : 400 ( 0.00 GB)
              mapped : 22074 ( 0.08 GB)
            • After the change (N0 and N1 are roughly equal)
            1. perl numa-maps-summary.pl < /proc/1670/numa_maps
              N0 : 5138584 ( 19.60 GB)
              N1 : 5138174 ( 19.60 GB)
              active : 46102 ( 0.18 GB)
              anon : 10274076 ( 39.19 GB)
              dirty : 10274084 ( 39.19 GB)
              mapmax : 457 ( 0.00 GB)
              mapped : 2735 ( 0.01 GB)

            As I said, we've had daily swap usage alerts before the change and we have no alerts for about a week which proves that these options made the difference

            aleksey.sanin Aleksey Sanin (Inactive) added a comment - These options are very useful: http://blog.jcole.us/2010/09/28/mysql-swap-insanity-and-the-numa-architecture/ We've had numerous swap usage alerts on the standalone MariaDB machine until we figured out that these options are not implemented in "pure" MariaDB (and are implemented in MariaDB-Galera): Before the change (N0 is overloaded when N1 is empty) perl numa-maps-summary.pl < /proc/24432/numa_maps N0 : 8034951 ( 30.65 GB) N1 : 2288796 ( 8.73 GB) active : 69235 ( 0.26 GB) anon : 10301726 ( 39.30 GB) dirty : 10301756 ( 39.30 GB) mapmax : 400 ( 0.00 GB) mapped : 22074 ( 0.08 GB) After the change (N0 and N1 are roughly equal) perl numa-maps-summary.pl < /proc/1670/numa_maps N0 : 5138584 ( 19.60 GB) N1 : 5138174 ( 19.60 GB) active : 46102 ( 0.18 GB) anon : 10274076 ( 39.19 GB) dirty : 10274084 ( 39.19 GB) mapmax : 457 ( 0.00 GB) mapped : 2735 ( 0.01 GB) As I said, we've had daily swap usage alerts before the change and we have no alerts for about a week which proves that these options made the difference
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            jb-boin Jean Weisbuch made changes -
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 29422 ] MariaDB v2 [ 43986 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 43986 ] MariaDB v3 [ 63232 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 63232 ] MariaDB v4 [ 147164 ]

            People

              serg Sergei Golubchik
              aleksey.sanin Aleksey Sanin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.