← Back to team overview

maria-discuss team mailing list archive

Re: Exceeding configured memory

 



Am 12.04.21 um 08:31 schrieb Sig Pam:
Hi all!

I run into problems with the memory configuration of MariaDB 10.3.27 on Debian 10. It looks as if it exceeds the configured memory.

The server hat 4 GB of memory. It runs MariaDB and a Kopano (Mail/Collaboration) server. The configuration I believe I have made is 2GB for MariaDB, plus 1 GB for Kopano. The rest is for reserved for the OS.

If I look at the process list, I can see that mysql greatly exceeds the configured 2GB limit:

root@exchange64:~# ps -e -o "vsz rss pid comm" | grep mysql

4933304 1604212 852 mysqld

The virtual process size is 4.9 GB, with 1.6 GB resident in RAM

VIRT is pointless

Firefox: 45 GB VIRT (main prcoess and 9 workers)
VM1: 9 GB VIRT
VM2: 6 GB VIRT
VM2: 6 GB VIRT
QtWebEngine: 5 GB VIRT
MariaDB: 4 GB VIRT
X11: 3 GB VIRT

[harry@srv-rhsoft:~]$ free -h
total used free shared buff/cache available Mem: 31Gi 3,3Gi 2,1Gi 757Mi 25Gi 26Gi
Swap:         6,2Gi       7,0Mi       6,2Gi



References