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

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.15, 10.4.16, 10.4.17
    • None
    • Replication, Server
    • 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. massif_ps_off.txt
          117 kB
        2. massif_ps_on_rep_ign.txt
          118 kB
        3. massif_ps_on.txt
          39 kB
        4. mem.png
          mem.png
          60 kB

        Activity

          People

            Unassigned Unassigned
            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.