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