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

[Reindl Harald]

/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 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
>
>
>
> _______________________________________________
> 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/174dfef6/attachment.pgp>