[systemd-devel] systemd and mysql with large memory pages

["Jóhann B. Guðmundsson"]

On 09/19/2011 08:30 PM, Lennart Poettering wrote:
> Well, but there's an equivalent fix here, just use LimitXXX= in the unit
> files.

Long story put short what you need to do to match what Lennart has been 
saying.

Add

LimitMEMLOCK=infinity

To the unit file instead of using /etc/security/limits.conf

So you now have in the mysql unit file

LimitMEMLOCK=infinity
LimitNOFILE=30000

and add an config file to /etc/sysctl.d/mysql-tweaks.conf ( or create 
seperate config for each parameter )...

Which contained

# My mysql tweaks
vm.nr_hugepages=200
vm.hugetlb_shm_group=27
kernel.shmal=2097152l

As opposed to be editing /etc/sysctl.conf directly

JBG