Hi, Derick, According to your SHOW GLOBAL STATUS
Memory_used 15460922288 That is the server thinks it uses about 15GB The difference could be due to memory fragmentation, when the server frees the memory, but it cannot be returned to the OS. In this case using a different memory allocator could help (try system or tcmalloc). Regards, Sergei Chief Architect, MariaDB Server and [email protected] On Mar 17, Derick Turner via discuss wrote: > Hi all, > > I was pointed to this list from a question I raised on StackExchange > (https://dba.stackexchange.com/questions/345743/why-does-my-mariadb-application-use-more-memory-than-configured) > > I have a cluster of MariaDB (11.4.5) primary/primary servers running on > Ubuntu. I updated the OS on Saturday to 24.04 from 22.04 (and patched > the DB to the 11.4.5 noble version) as we were occasionally hitting an > OOM event which was causing the database process to be killed. Since > then, the DB process takes all of the available server memory before > being killed by the OOM killer. > > DB is configured to use about 15GB of RAM (from config calculations) > Servers currently have 50GB of RAM and 95% of this is used within about > an hour an a half. > > Link to document with configuration settings, global status, > mariadb.service override and InnoDB status is here - > https://docs.google.com/spreadsheets/d/1ev9KRWP8l54FpRrhFeX4uxFhJnOlFkV4_vTCZWipcXA/edit?usp=sharing > > Any help would be gratefully received. > > Thanks in advance. > > Derick > > -- > Derick Turner - He/Him > > _______________________________________________ > discuss mailing list -- [email protected] > To unsubscribe send an email to [email protected] _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
