[MXS-4713] 大量插入导致maxscale 内存占用不断增大 最后oom Created: 2023-08-14  Updated: 2023-08-18  Resolved: 2023-08-18

Status: Closed
Project: MariaDB MaxScale
Component/s: None
Affects Version/s: 6.2.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: yufengzhou Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: bug
Environment:

Centos7.6.1810 MaxScale 6.2.1 4核 16G 内存


Attachments: PNG File maxscale.png    

 Description   

大量插入(400w-800w 表数据) 导致maxscale 内存占用不断增大 最后oom

目前修改了以下参数 没有看到任何效果 有没有手动回收内存的方法？
query_classifier_cache_size 102400000
writeq_low_water 1024
writeq_high_water 65535

 Comments   
Comment by yufengzhou [ 2023-08-14 ]

每个小时的05 分钟开始有大量insert 定时任务 10点之前被关掉了，10重新开启 发现内存不停的增长而不回收

Comment by markus makela [ 2023-08-14 ]

Would it be possible to write the issue description in english? 请写英文，谢谢

Comment by markus makela [ 2023-08-14 ]

If you're facing OOM problems, I'd suggest upgrading to the latest 6.4 release: there have been bug fixes related to the memory usage of MaxScale.

Comment by markus makela [ 2023-08-18 ]

These bugs have been fixed since MaxScale 6.2.1:

The most likely bug that would cause this problem is MXS-4515. Doing lots of inserts and then closing the connection will suffer from this problem.

Please upgrade to the latest release (MaxScale 6.4.8) to verify that the problem is fixed.

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