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

          Activity

            People

              danblack Daniel Black
              danblack Daniel Black
              Votes:
              2 Vote for this issue
              Watchers:
              13 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.