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

Reindl Harald h.reindl at thelounge.net
Sat Sep 17 03:57:32 PDT 2011


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
ulimit -l unlimited
ulimit -n 30000
_____________

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

-------------- 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/b1186aa8/attachment.pgp>


More information about the systemd-devel mailing list