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@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@lists.freedesktop.org > http://lists.freedesktop.org/mailman/listinfo/systemd-devel _______________________________________________ systemd-devel mailing list systemd-devel@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/systemd-devel