[MCOL-541] Amazon AMI set vm.swappiness = 0 as default for MariaDB-ColumnStore-1.0.7 image Created: 2017-02-02  Updated: 2017-12-01  Resolved: 2017-02-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: Documentation
Affects Version/s: 1.0.7
Fix Version/s: 1.0.7

Type: New Feature Priority: Minor
Reporter: Richard Stracke Assignee: David Hill (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

Amazon Community AMI MariaDB-ColumnStore-1.0.7
https://mariadb.com/kb/en/mariadb/installing-and-configuring-a-columnstore-system-using-the-amazon-ami/



 Description   

Default value for Cent OS 7 is
vm.swappiness = 30, but
vm.swappiness = 0
is recommended.

mariadb configuring-swappiness
Performance Tuning on EC2

User awaits a ready to use preinstalled image.

Request:
vm.swappiness = 0
as default value for Amazon Community AMI MariaDB-ColumnStore-1.0.7.



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-02-02 ]

30 is actually quite low already considering the kernel recommended default of 60. A swappiness of 0 could cause premature kernel OOM triggers with ColumnStore. If we were going down that route then it would likely be set to 1. Setting it to 0 for any modern Linux distribution should be done with extreme caution.

Comment by David Hill (Inactive) [ 2017-02-02 ]

This setting is a default setting that is currently at 30. It can be dangerous to set it to low, so the setting will remain 30 as the default.

I have updated the document to explain. So if the customer wants change this setting, then they can do that.

https://mariadb.com/kb/en/mariadb/installing-and-configuring-a-columnstore-system-using-the-amazon-ami/

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