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

2011-09-19 Thread Jóhann B. Guðmundsson
On 09/19/2011 08:30 PM, Lennart Poettering wrote: Well, but there's an equivalent fix here, just use LimitXXX= in the unit files. Long story put short what you need to do to match what Lennart has been saying. Add LimitMEMLOCK=infinity To the unit file instead of using /etc/security/limits

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

2011-09-19 Thread Lennart Poettering
On Mon, 19.09.11 21:29, Reindl Harald (h.rei...@thelounge.net) wrote: > > > Am 19.09.2011 20:48, schrieb Lennart Poettering: > > On Mon, 19.09.11 20:42, Reindl Harald (h.rei...@thelounge.net) wrote: > >>> limits.conf is generally only applied to logins, not to system services > >> > >> i remeber

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

2011-09-19 Thread Reindl Harald
Am 19.09.2011 20:48, schrieb Lennart Poettering: > On Mon, 19.09.11 20:42, Reindl Harald (h.rei...@thelounge.net) wrote: >>> limits.conf is generally only applied to logins, not to system services >> >> i remeber that was the reaso include it in the /etc/initd./service because >> started processe

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

2011-09-19 Thread Lennart Poettering
On Mon, 19.09.11 20:42, Reindl Harald (h.rei...@thelounge.net) wrote: > > > Am 19.09.2011 19:39, schrieb Lennart Poettering: > >> /etc/security/limits.conf and set the desired setting there which is > >> the proper way of doing this stuff since you rarely change them. > > > > limits.conf is gen

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

2011-09-19 Thread Reindl Harald
Am 19.09.2011 19:39, schrieb Lennart Poettering: >> /etc/security/limits.conf and set the desired setting there which is >> the proper way of doing this stuff since you rarely change them. > > limits.conf is generally only applied to logins, not to system services i remeber that was the reaso i

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

2011-09-19 Thread Lennart Poettering
On Sat, 17.09.11 11:36, "Jóhann B. Guðmundsson" (johan...@gmail.com) wrote: > > On 09/17/2011 10:57 AM, Reindl Harald wrote: > >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-M

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

2011-09-19 Thread Lennart Poettering
On Sat, 17.09.11 13:39, Thomas Meyer (tho...@m3y3r.de) wrote: > > Am Samstag, den 17.09.2011, 13:22 +0200 schrieb Reindl Harald: > > /etc/sysctl.conf: > > # Hughe TLB for mysqld > > vm.nr_hugepages = 200 > > vm.hugetlb_shm_group = 27 > > kernel.shmall = 2097152 > > > > mysqld says: > > InnoDB: H

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

2011-09-19 Thread Lennart Poettering
On Sat, 17.09.11 12:57, Reindl Harald (h.rei...@thelounge.net) wrote: > with sysv/lsb you could include the follwoing script via "source" > and hughe TLB in mysqld worked like a charme Hmpf. Global system settings hidden away in specific services is not a nice solution I'd say. > [root@rh:~]$ ca

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

2011-09-17 Thread Reindl Harald
thank you! after a reboot the changes in "/etc/security/limits.conf", "/etc/sysctl.conf" and "mysqld.service" are working, what i never understood is "hugetlb_shm_group" because what if you have more thane one software wanting use Hughe TLB, anyways this is off topic regards from vienna Am 1

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

2011-09-17 Thread Thomas Meyer
Am Samstag, den 17.09.2011, 13:22 +0200 schrieb 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: Warn

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

2011-09-17 Thread Tom Gundersen
On Sat, Sep 17, 2011 at 1:22 PM, Reindl Harald wrote: > /etc/sysctl.conf: > # Hughe TLB for mysqld > vm.nr_hugepages = 200 > vm.hugetlb_shm_group = 27 > kernel.shmall = 2097152 Did you reboot (or "systemctl restart systemd-sysctl.service") to make sure these things were picked up? Could you veri

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

2011-09-17 Thread Jóhann B. Guðmundsson
On 09/17/2011 10:57 AM, Reindl Harald wrote: 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

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

2011-09-17 Thread 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 F

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

2011-09-17 Thread 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

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

2011-09-17 Thread 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 > e

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

2011-09-17 Thread Reindl 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 ulimit -l unl