I don't think you can controll it through my.cnf. You'll have to edit the init script to add the LD_PRELOAD environment variable when mysqld/mariadbd loads.
On Sat, 21 Mar 2026 at 20:06, Ruben Safir <[email protected]> wrote: > > On Sat, Mar 21, 2026 at 07:47:20PM +0200, Gordan Bobic via discuss wrote: > > yum install gperftools-libs > > > > ``` > > systemctl edit mariadb > > ``` > > and add this: > > ``` > > [Service] > > Environment="LD_PRELOAD=libtcmalloc_minimal.so.4" > > ``` > > > > Then: > > ``` > > systemctl daemon-reload > > systemctl restart mariadb > > ``` > > > This can not be controlled through my.conf > or is this kernel/system environment issue. > > I don't use systemd > > > > > On Sat, 21 Mar 2026 at 19:38, Ruben Safir <[email protected]> wrote: > > > > > > On Sat, Mar 21, 2026 at 02:42:48PM +0200, Gordan Bobic via discuss wrote: > > > > Assuming you don't have your memory for MariaDB set too high for your > > > > RAM size (check using one of the many online MariaDB/MySQL memory > > > > calculators), it could be glibc's malloc() that has less than stellare > > > > fragmentation/occupancy characteristics. You might want to LD_PRELOAD > > > > tcmalloc and see of the OOM problem goes away. > > > > > > Aside from altering header files and recompiling :) > > > > > > how would I go about and do that. > > > > > > > > > > > > > I have seen this > > > > problem manifest looking like a memory leak on several database > > > > estates I look after. > > > > > > > > On Sat, 21 Mar 2026 at 14:28, Ruben Safir via discuss > > > > <[email protected]> wrote: > > > > > > > > > > On Sat, Mar 21, 2026 at 08:53:49AM -0300, Arlindo Neto wrote: > > > > > > It looks like apache is also getting killed by OOM in your 4GB VM. > > > > > > > > > > Where do you see apache getting killed? Apache seems to always be > > > > > running and mariadbd is killed. And it won't restart. > > > > > > > > > > I often pound the heck out of apache http://www.brookln-fishing.com > > > > > alone is my master peice of stupid web design with thousand of images > > > > > on > > > > > it which swells apaches connecitons and cached memory in modperl. > > > > > > > > > > It is only maria which seems to be crashing. It is used for a simple > > > > > text mailing list which stores emails in mariadb and serves them > > > > > read-only. Mailing list entries are live stored on a back end > > > > > database > > > > > on another machine where the mail is running and perdiodically I just > > > > > rsync the entire database from /usr/locl/var to the webserver. > > > > > > > > > > The mailing list gets hammered by bots and that seems to be the source > > > > > of the problem. > > > > > > > > > > > > > > > > > > > > > > MariaDB could be the victim here. I believe your next move should > > > > > > be tuning > > > > > > Apache so it uses less memory, > > > > > > or move your db server to a spare VPS, so you can better > > > > > > troubleshoot who > > > > > > is eating up your RAM. > > > > > > > > > > > > Cheers. > > > > > > > > > > > > On Sat, Mar 21, 2026 at 8:28 AM Ruben Safir via discuss < > > > > > > [email protected]> wrote: > > > > > > > > > > > > > Not sure if this is much help > > > > > > > > > > > > > > Mar 17 21:03:13 www3 kernel: Out of memory: Killed process 14642 > > > > > > > (mariadbd) total-vm:4142548kB, anon-rss:13008kB, file-rss:440kB, > > > > > > > shmem-rss:0kB, UID:60 pgtables:1612kB oom_score_adj:0 > > > > > > > Mar 18 05:41:20 www3 mariadb[25757]: start-stop-daemon: no > > > > > > > matching > > > > > > > processes found > > > > > > > Mar 18 08:41:16 www3 kernel: Out of memory: Killed process 25788 > > > > > > > (mariadbd) total-vm:3217532kB, anon-rss:9196kB, file-rss:328kB, > > > > > > > shmem-rss:0kB, UID:60 pgtables:1080kB oom_score_adj:0 > > > > > > > > > > > > > > Mar 17 21:03:13 www3 kernel: > > > > > > > > > > > > > > oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=68,mems_allowed=0,global_oom,task_memcg=/openrc.mariadb,task=mariadbd,pid=14642,uid=60 > > > > > > > Mar 18 05:41:24 www3 mariadb[25767]: WARNING: mariadb is already > > > > > > > stopped > > > > > > > Mar 18 08:41:16 www3 kernel: [ 25788] 60 25788 804383 > > > > > > > 2381 > > > > > > > 2299 82 0 1105920 91680 0 mariadbd > > > > > > > Mar 18 08:41:16 www3 kernel: > > > > > > > > > > > > > > oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=68,mems_allowed=0,global_oom,task_memcg=/openrc.mariadb,task=mariadbd,pid=25788,uid=60 > > > > > > > Mar 18 21:45:07 www3 kernel: mariadbd invoked oom-killer: > > > > > > > gfp_mask=0x140dca(GFP_HIGHUSER_MOVABLE|__GFP_COMP|__GFP_ZERO), > > > > > > > order=0, > > > > > > > oom_score_adj=0 > > > > > > > Mar 18 21:45:07 www3 kernel: CPU: 1 UID: 60 PID: 29866 Comm: > > > > > > > mariadbd > > > > > > > Not tainted 6.12.71-1-lts #1 > > > > > > > 0c6f64fd677899b1f215535073935a6275af35f3 > > > > > > > Mar 18 21:45:07 www3 kernel: [ 29866] 60 29866 441047 > > > > > > > 22216 > > > > > > > 22186 30 0 303104 0 0 mariadbd > > > > > > > Mar 18 21:45:07 www3 kernel: > > > > > > > > > > > > > > oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=openrc.mariadb,mems_allowed=0,global_oom,task_memcg=/68,task=/usr/local/apac,pid=14730,uid=2 > > > > > > > > > > > > > > Mar 18 21:46:30 www3 kernel: > > > > > > > > > > > > > > oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=openrc.mariadb,mems_allowed=0,global_oom,task_memcg=/openrc.mariadb,task=mariadbd,pid=29990,uid=60 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Sat, Mar 21, 2026 at 06:52:51AM -0400, Ruben Safir via discuss > > > > > > > wrote: > > > > > > > > I'll see what I can do on the next crash, but I haven't been > > > > > > > > able to > > > > > > > > get anything from the logs > > > > > > > > > > > > > > > > > > > > > > > > On Sat, Mar 21, 2026 at 05:57:31AM -0400, Ruben Safir wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > mariadb, which I am running at Artix Linux, has been set up > > > > > > > > > and > > > > > > > > > flawlessly running for decades with Perl DBI:DBD > > > > > > > > > > > > > > > > > > Of late, it has regularly been crashing and I can't find even > > > > > > > > > log > > > > > > > > > entries as to the cause, but suspect that the server is > > > > > > > > > getting > > > > > > > hammered > > > > > > > > > by AI robots stressing the system. A LONG time ago I had a > > > > > > > > > similar > > > > > > > > > problem with memory allcoation being excusted and Monty > > > > > > > > > showed me how > > > > > > > to > > > > > > > > > increase the memory allocation. I don't know if a similar > > > > > > > > > thing will > > > > > > > > > help as I am sure that these f***king robots will steal as > > > > > > > > > many > > > > > > > > > resources as you will feed them. Once it crashed, it will > > > > > > > > > not restart. > > > > > > > > > Sometimes I need to kill apache as well to restart. > > > > > > > > > Occasionally I've > > > > > > > > > had to do a complete system reboot. > > > > > > > > > > > > > > > > > > Do I have a solution to this? > > > > > > > > > > > > > > > > > > Reuvain > > > > > > > > > > > > > > > > > > -- > > > > > > > > > So many immigrant groups have swept through our town > > > > > > > > > that Brooklyn, like Atlantis, reaches mythological > > > > > > > > > proportions in the mind of the world - RI Safir 1998 > > > > > > > > > http://www.mrbrklyn.com > > > > > > > > > > > > > > > > > > DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 > > > > > > > > > http://www.nylxs.com - Leadership Development in Free Software > > > > > > > > > http://www2.mrbrklyn.com/resources - Unpublished Archive > > > > > > > > > http://www.coinhangout.com - coins! > > > > > > > > > http://www.brooklyn-living.com > > > > > > > > > > > > > > > > > > Being so tracked is for FARM ANIMALS and extermination camps, > > > > > > > > > but incompatible with living as a free human being. -RI Safir > > > > > > > > > 2013 > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > So many immigrant groups have swept through our town > > > > > > > > that Brooklyn, like Atlantis, reaches mythological > > > > > > > > proportions in the mind of the world - RI Safir 1998 > > > > > > > > http://www.mrbrklyn.com > > > > > > > > > > > > > > > > DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 > > > > > > > > http://www.nylxs.com - Leadership Development in Free Software > > > > > > > > http://www2.mrbrklyn.com/resources - Unpublished Archive > > > > > > > > http://www.coinhangout.com - coins! > > > > > > > > http://www.brooklyn-living.com > > > > > > > > > > > > > > > > Being so tracked is for FARM ANIMALS and extermination camps, > > > > > > > > but incompatible with living as a free human being. -RI Safir > > > > > > > > 2013 > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > > > discuss mailing list -- [email protected] > > > > > > > > To unsubscribe send an email to [email protected] > > > > > > > > > > > > > > -- > > > > > > > So many immigrant groups have swept through our town > > > > > > > that Brooklyn, like Atlantis, reaches mythological > > > > > > > proportions in the mind of the world - RI Safir 1998 > > > > > > > http://www.mrbrklyn.com > > > > > > > > > > > > > > DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 > > > > > > > http://www.nylxs.com - Leadership Development in Free Software > > > > > > > http://www2.mrbrklyn.com/resources - Unpublished Archive > > > > > > > http://www.coinhangout.com - coins! > > > > > > > http://www.brooklyn-living.com > > > > > > > > > > > > > > Being so tracked is for FARM ANIMALS and extermination camps, > > > > > > > but incompatible with living as a free human being. -RI Safir 2013 > > > > > > > > > > > > > > _______________________________________________ > > > > > > > discuss mailing list -- [email protected] > > > > > > > To unsubscribe send an email to [email protected] > > > > > > > > > > > > > > > > > -- > > > > > So many immigrant groups have swept through our town > > > > > that Brooklyn, like Atlantis, reaches mythological > > > > > proportions in the mind of the world - RI Safir 1998 > > > > > http://www.mrbrklyn.com > > > > > > > > > > DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 > > > > > http://www.nylxs.com - Leadership Development in Free Software > > > > > http://www2.mrbrklyn.com/resources - Unpublished Archive > > > > > http://www.coinhangout.com - coins! > > > > > http://www.brooklyn-living.com > > > > > > > > > > Being so tracked is for FARM ANIMALS and extermination camps, > > > > > but incompatible with living as a free human being. -RI Safir 2013 > > > > > > > > > > _______________________________________________ > > > > > discuss mailing list -- [email protected] > > > > > To unsubscribe send an email to [email protected] > > > > > > > > > > > > > > > > -- > > > > Gordan Bobic > > > > Database Specialist, Shattered Silicon Ltd. > > > > https://shatteredsilicon.net > > > > Follow us: > > > > LinkedIn: https://www.linkedin.com/company/shatteredsilicon > > > > X: https://x.com/ssiliconbg > > > > _______________________________________________ > > > > discuss mailing list -- [email protected] > > > > To unsubscribe send an email to [email protected] > > > > > > -- > > > So many immigrant groups have swept through our town > > > that Brooklyn, like Atlantis, reaches mythological > > > proportions in the mind of the world - RI Safir 1998 > > > http://www.mrbrklyn.com > > > > > > DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 > > > http://www.nylxs.com - Leadership Development in Free Software > > > http://www2.mrbrklyn.com/resources - Unpublished Archive > > > http://www.coinhangout.com - coins! > > > http://www.brooklyn-living.com > > > > > > Being so tracked is for FARM ANIMALS and extermination camps, > > > but incompatible with living as a free human being. -RI Safir 2013 > > > > > > > > > -- > > Gordan Bobic > > Database Specialist, Shattered Silicon Ltd. > > https://shatteredsilicon.net > > Follow us: > > LinkedIn: https://www.linkedin.com/company/shatteredsilicon > > X: https://x.com/ssiliconbg > > _______________________________________________ > > discuss mailing list -- [email protected] > > To unsubscribe send an email to [email protected] > > -- > So many immigrant groups have swept through our town > that Brooklyn, like Atlantis, reaches mythological > proportions in the mind of the world - RI Safir 1998 > http://www.mrbrklyn.com > > DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 > http://www.nylxs.com - Leadership Development in Free Software > http://www2.mrbrklyn.com/resources - Unpublished Archive > http://www.coinhangout.com - coins! > http://www.brooklyn-living.com > > Being so tracked is for FARM ANIMALS and extermination camps, > but incompatible with living as a free human being. -RI Safir 2013 > -- Gordan Bobic Database Specialist, Shattered Silicon Ltd. https://shatteredsilicon.net Follow us: LinkedIn: https://www.linkedin.com/company/shatteredsilicon X: https://x.com/ssiliconbg _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
