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

avoid OOM by linux kernel co-operative memory management

    XMLWordPrintable

    Details

      Description

      Allocating sufficiently available memory but not too much has been a challenge for MariaDB and MySQL users for a significant time.

      The overallocation results in a risk of OOM killing of the server process.

      Linux kernel this interface:
      https://www.kernel.org/doc/html/latest/accounting/psi.html

      By receiving a memory event of memory pressure options are:

      • madvice(DONT_NEED/FREE) on buf_pool.free
      • Moving innodb buffer LRU pool chunks to free
      • Resizing down innodb buffer pool
      • Kill off thread cache thread(s)?
      • table caches (are these large?)

      So configuration would need a trigger values, "<some|full> <stall amount in us> <time window in us>", from the kernel interface. And a response for "some"/"full".

        Attachments

          Issue Links

          relates to

          Task - A task that needs to be done. MDEV-25340 innodb buffer pool - lazy initialization

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-25341 innodb buffer pool soft decommit of memory

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-29431 SQL interface and Storage Engine interface for reclaiming memory

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

          Task - A task that needs to be done. MDEV-29432 innodb huge pages reclaim

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-19895 Support "autoset" in SET GLOBAL for AUTO_SET system variables

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-25342 autosize innodb_buffer_pool_chunk_size

          • 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-27772 Performance regression with default configuration in 10.6

          • Major - Major loss of function.
          • Open

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              danblack Daniel Black
              Votes:
              2 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.