Not the answer you need?
Register and ask your own question!

Memory monitor seems wrong

Hi all,

I have recently setup a server with PMM to monitor our MariaDB servers (10.1.37), hoping that it could help us detect the cause of a problem related to high memory usage, however the memory stats seem a little off.

For example, for one of our server the "MySQL internal memory overview" shows:


System Memory
16652042240


InnoDB Buffer Pool Data
1278623744


InnoDB Log Buffer Size
67108864


InnoDB Additional Memory Pool Size
8388608


InnoDB Dictionary Size
641407506


Key Buffer Size
131072


Query Cache Size
0


Adaptive Hash Index Size
51562112



The total is a little less than 2 GB.

However, looking at the output of the "top" command, I see this:

top - 10:11:31 up 198 days, 7:38, 2 users, load average: 0.04, 0.07, 0.13
Tasks: 124 total, 1 running, 123 sleeping, 0 stopped, 0 zombie
%Cpu(s): 4.5 us, 0.3 sy, 0.0 ni, 94.5 id, 0.5 wa, 0.0 hi, 0.0 si, 0.2 st
KiB Mem : 16261760 total, 8185988 free, 6635724 used, 1440048 buff/cache
KiB Swap: 14679344 total, 13690704 free, 988640 used. 9188236 avail Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5164 mysql 20 0 8565736 5.8g 10188 S 3.3 37.3 5:34.69 mysqld

so here it seems that the database is actually using almost 6 GB of RAM.

How can I see where the "missing" 4 GB are allocated?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.