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

[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 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


-- 

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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freedesktop.org/archives/systemd-devel/attachments/20110917/c8737ff6/attachment-0001.pgp>