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

10.8.3 seems to be using a lot more swap memory, always increasing (every time mariabackup runs daily)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.8.3
    • N/A
    • Server
    • None

    Description

      I don't remember having this issue with 10.5, as although it was using a good amount of swap memory, I never had to do an emergency database restart because of it.

      Since a few days ago, I had been receiving alerts about too much swap being used on the server, and it's been getting worse. I had to restart MariaDB yesterday, because it was getting full.

      Before the restart, this was the usage:

      Resident RAM:
      mariadbd – 89387556 (85.25 GB)

      Swap:
      mariadbd – 26975616 (25.73 GB)

      And by the way, my server's sysctl has this config:

      vm.swappiness=1
      (which means to only use Swap if absolutely necessary; while =0 would disable it)

      My innodb_buffer_pool_size is 80G.

      Are you aware of any reason so much Swap would be used by MariaDB?

      There was plenty of resident free RAM that could be used instead.
      I understand that some Swap can be used, but I don't understand why so much Swap, instead of resident RAM.

      Since the restart yesterday, it's already using 2GB swap, and increasing.

      Thank you.

      Attachments

        1. screenshot-1.png
          screenshot-1.png
          14 kB
        2. screenshot-2.png
          screenshot-2.png
          18 kB
        3. screenshot-3.png
          screenshot-3.png
          15 kB
        4. screenshot-4.png
          screenshot-4.png
          28 kB
        5. screenshot-5.png
          screenshot-5.png
          88 kB
        6. screenshot-6.png
          screenshot-6.png
          24 kB
        7. screenshot-7.png
          screenshot-7.png
          16 kB

        Activity

          People

            danblack Daniel Black
            nunop Nuno
            Votes:
            0 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.