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

Deprecate and ignore options for InnoDB concurrency throttling

    XMLWordPrintable

    Details

      Description

      The variable innodb_thread_concurrency was useful years ago when computing resources were limited, but nowadays setting this value to anything than unlimited (0) makes little sense and actually makes things worse ,because queries have to wait outside InnoDB.

      We have seen many customers mistakenly setting this to a small value like 16 or 64 and then complaining the server was slow.

      In the latest instantation of the above problem I've seen (just today), the available slots were all taken by long running transactions (left open) and the server was stalled as a result.

      So, a dangerous config option and IMHO a good candidate for deprecation/removal.

      Thanks
      Rick

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              rpizzi Rick Pizzi
              Votes:
              4 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: