"man sysctl.d" says exactly nothing how i get the same behavior as all the years before via /etc/init.d/mysqld
maybe YOU are knowing exactly what to do where
i do not and that is why i wrote my message :-(
Am 17.09.2011 13:04, schrieb 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@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
--
Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/
http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
_______________________________________________ systemd-devel mailing list systemd-devel@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/systemd-devel
