[MCOL-5479] Memory that cannot be swapped out grows higher with every query execution Created: 2023-04-18  Updated: 2023-05-24  Resolved: 2023-05-24

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: andreas eschbacher Assignee: Daniel Lee (Inactive)
Resolution: Not a Bug Votes: 0
Labels: EXECUTE, memory_exhaustion, query
Environment:

10.5.18
Columnstore_version | 5.6.8
Red Hat Enterprise Linux release 8.5

Attachments: PNG File image-2023-04-18-15-20-48-747.png     PNG File image-2023-04-18-15-21-24-349.png    

 Description   

with every run of a certain query the Memory that cannot be swapped out gets higher and higher. before 12:20 we had swappiness 1 and than switched to swappiness 10

here you can see the spikes while the query is running:

is there a possibility to clear RAM and to lower Memory that cannot be swapped out without to restart the Server?

 Comments   
Comment by andreas eschbacher [ 2023-04-18 ]

you can clear "Memory that cannot be swapped out" with: dbrmctl reload --> just found that out.
so there was a problem with swappiness 1 which could be solved by switching to swappiness 10 and has nothing to do with the amount of Memory that cannot be swapped out

Comment by andreas eschbacher [ 2023-04-18 ]

you can close this ticket.
ty andreas

Comment by Todd Stoffel (Inactive) [ 2023-05-15 ]

dleeyh can you test this on a newer version and close it?

Generated at Thu Feb 08 02:58:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.