[MDEV-28028] PFS uncontrolled memory usage cap to OS memory until OOM Created: 2022-03-09  Updated: 2022-03-15

Status: Open
Project: MariaDB Server
Component/s: Performance Schema
Affects Version/s: 10.3.32
Fix Version/s: None

Type: Bug Priority: Major
Reporter: VAROQUI Stephane Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Debian Edge

Attachments: File malloc.svg     PNG File voila-enfin.png    

 Description   

After an upgrade to this 10.3.32 with performance_schema=ON default probe enable we notice a change in the memory usage of the mariadb process. The Sum of global buffers & dynamic allocation is estimated 10G but we end up with a 350G RSS size in a day and stabilized to physical memory of the server until it OOM. Truncate all PS tables without being able to get back the used memory only restart with disabling PFS limit the process RSS to around 10G see attached monitoring and a 10s perf malloc of the workload



 Comments   
Comment by VAROQUI Stephane [ 2022-03-09 ]

The os run some multi instances but most of the other instances do not use PFS and JEMalloc is preloaded

Comment by Richard DEMONGEOT [ 2022-03-09 ]

Previous version was 10.3.31 .
Performance Schema was running since 10.3.[3years ago] until 10.3.31 and we never had OOM Killer on the Mariadb server.

Comment by Richard DEMONGEOT [ 2022-03-15 ]

Ram consumption was stabilized by removing the performance schema.

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