[MDEV-24417] Memory leak issue with replication performance_schema between 10.1 and 10.4 Created: 2020-12-16  Updated: 2020-12-16

Status: Open
Project: MariaDB Server
Component/s: Replication, Server
Affects Version/s: 10.4.15, 10.4.16, 10.4.17
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Max Irgiznov Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: replication
Environment:

hardware


Attachments: Text File massif_ps_off.txt     Text File massif_ps_on.txt     Text File massif_ps_on_rep_ign.txt     PNG File mem.png    

 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.


Generated at Thu Feb 08 09:29:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.