/etc/sysctl.conf: # Hughe TLB for mysqld vm.nr_hugepages = 200 vm.hugetlb_shm_group = 27 kernel.shmall = 2097152
mysqld says: InnoDB: HugeTLB: Warning: Failed to allocate 274726912 bytes. errno 12 InnoDB HugeTLB: Warning: Using conventional memory pool so how get the same behavior working until F15 since years? Am 17.09.2011 13:14, schrieb Reindl Harald: > "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 > > > > _______________________________________________ > 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
