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

doc about system variables say "max purge thread can only set 1" ,but it dose not

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.12
        • Fix Version/s: N/A
        • Component/s: Documentation
        • Labels:
          None
        • Environment:
          Centos6.4 ,MariaDB10.0.12

          Description

          in https://mariadb.com/kb/en/mariadb/documentation/storage-engines/xtradb-and-innodb/xtradbinnodb-server-system-variables/#innodb_purge_threads

          innodb_purge_threads

          Description: Number of threads dedicated to XtraDB purge operations. If set to 0, the default, purging is done with the master thread. If set to 1, the current maximum, purging is done on a separate thread with could reduce contention. Currently has minimal effect, but is a future area of improvement. See also innodb_purge_batch_size.
          Commandline: --innodb-purge-threads=#
          Scope: Global
          Dynamic: No
          Data Type: numeric
          Default Value: 0
          Range: 0 to 1
          Introduced: MariaDB/MySQL 5.5.4

          but i write "innodb-purge-threads=2" in /etc/my.cnf ,and restart server,and run "show variables like 'innodb-purge-threads'" ,it return 2 ,but document says "Range: 0 to 1"

            Gliffy Diagrams

              Attachments

                Activity

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

                fyi i checked the code and the 5.5 trunk still only has 1 innodb-purge-threads so it was introduced in 10.x somewhere

                Show
                danblack Daniel Black added a comment - fyi i checked the code and the 5.5 trunk still only has 1 innodb-purge-threads so it was introduced in 10.x somewhere
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                According to http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_purge_threads , the range changed in 5.6.2.

                Show
                elenst Elena Stepanova added a comment - According to http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_purge_threads , the range changed in 5.6.2.
                Hide
                Permalink
                greenman Ian Gilfillan added a comment -

                This was changed in MariaDB 10, I've updated the documentation. Leaving open for now as I also want to examine innodb_purge_bach_size.

                Show
                greenman Ian Gilfillan added a comment - This was changed in MariaDB 10, I've updated the documentation. Leaving open for now as I also want to examine innodb_purge_bach_size.

                  People

                  • Assignee:
                    greenman Ian Gilfillan
                    Reporter:
                    alexkim 黄春晖
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    5 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: