[CentOS] mariadb server memory usage

hw

hw at gc-24.de
Sat Nov 4 14:05:59 UTC 2017


Hi,

is this ok for a database server, or do I need to turn the memory allowance
down?  The machine has 48GB and mariadb is allowed about 40. The
machine is a dedicated database server.

Mysql seems to go up to what top says is virtually allocated under some
circumstances; I don´t know what mariadb does.  I don´t want anything
get killed because memory runs out.  Swap should prevent that anyway,
but perhaps I went a bit higher than I should?

Usual advice is to use 80%, and there are probably reasons for that.
Perhaps it´s better to allow for more disk cache?


KiB Mem : 49449424 total,   291772 free, 45891836 used,  3265816 buff/cache
KiB Swap: 16777212 total, 16742928 free,    34284 used.  2985816 avail Mem

   PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND
  4138 mysql     20   0 48.908g 0.042t  14064 S   0.0 91.8 111:23.17 mysqld



More information about the CentOS mailing list