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

[Thomas Meyer]

Am Samstag, den 17.09.2011, 12:57 +0200 schrieb Reindl Harald:
hello harald,

> with sysv/lsb you could include the follwoing script via "source"
> and hughe TLB in mysqld worked like a charme
> 
> [root at rh:~]$ cat /etc/my.memory.cnf
> # Large-Memory-Pages
> echo 200 > /proc/sys/vm/nr_hugepages
> echo 27 > /proc/sys/vm/hugetlb_shm_group
> echo 2097152 > /proc/sys/kernel/shmall

these are system wide config parameters and can be set via systemd.

see man page "sysctl.d"

> ulimit -l unlimited
> ulimit -n 30000

man systemd.exec says that these rlimits can be set in the unit:

       LimitCPU=, LimitFSIZE=, LimitDATA=, LimitSTACK=, LimitCORE=, LimitRSS=, LimitNOFILE=, LimitAS=,
       LimitNPROC=, LimitMEMLOCK=, LimitLOCKS=, LimitSIGPENDING=, LimitMSGQUEUE=, LimitNICE=,
       LimitRTPRIO=, LimitRTTIME=
           These settings control various resource limits for executed processes. See setrlimit(2) for
           details. Use the string infinity to configure no limit on a specific resource.

> _____________
> 
> calling this via "ExecStartPre" does not work
> so HOW do this on a systemd-environment if your mysqld
> has a hughe key_buffer size?
> 
> 110917 12:53:55 InnoDB: Initializing buffer pool, size = 256.0M
> InnoDB: HugeTLB: Warning: Failed to allocate 274726912 bytes. errno 12
> InnoDB HugeTLB: Warning: Using conventional memory pool
> 
> _______________________________________________
> systemd-devel mailing list
> systemd-devel at lists.freedesktop.org
> http://lists.freedesktop.org/mailman/listinfo/systemd-devel