Buy Percona ServicesBuy Now!

Memory monitor seems wrong

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?
    Last edited by tasso85; 03-13-2019, 07:14 AM. Reason: added tags
Working...
X