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

          blocks

          Task - A task that needs to be done. MDEV-23397 Remove deprecated InnoDB options in 10.6

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

          Task - A task that needs to be done. MDEV-23382 Change DB_ROLL_PTR format to allow more than 128 concurrent START TRANSACTION

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25883 Galera Cluster hangs while "DELETE FROM mysql.wsrep_cluster"

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-11382 AliSQL: [Feature] Issue#9: PROVIDE ADAPTIVE ALGORITHM FOR INNODB CONCURRENCY TICKETS

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14462 Confusing error message: ib_logfiles are too small for innodb_thread_concurrency=0

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23369 False sharing in page_hash_latch::read_lock_wait()

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24759 Server hangs when innodb_thread_concurrency is reached and temporary sequences exist

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31220 MariaDB:performance seems to be limited when the value of parameter innodb_thread_concurrency is not zero

          • Major - Major loss of function.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              rpizzi Rick Pizzi
              Votes:
              4 Vote for this issue
              Watchers:
              6 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.