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

Memory leak issue with replication performance_schema between 10.1 and 10.4

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4.15, 10.4.16, 10.4.17
    • Fix Version/s: None
    • Component/s: Replication, Server
    • Labels:
    • Environment:
      hardware

      Description

      Hi.

      I found a memory leak problem when setup replication from 10.1 to 10.4.17.
      This manifests itself in uncontrolled memory consumption regardless of the buffer pool settings on the slave instance. The replica was deployed with mariabackup-10.1 and then upgraded with mysql_upgrade.

      After analyzing the memory profiling data, the temporary solution was to disable performance_schema replication without turning off the schema itself, the leak remained, but memory consumption was significantly reduced.

      Server configuration: master 10.1 replica 10.4 (sql_mode=")
      Files in attachments: profiling enabled using performance_schema(massif_ps_on), disabled (massif_ps_off) and using replicate-ignore-db(massif_ps_on_rep_ign)

      A temporary workaround is turning off the slave instance’s performance_schema.

        Attachments

        1. mem.png
          mem.png
          60 kB
        2. massif_ps_on.txt
          39 kB
        3. massif_ps_on_rep_ign.txt
          118 kB
        4. massif_ps_off.txt
          117 kB

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            xeonvs Max Irgiznov
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.