MariaDB Mysql Memory Usage

Optimal memory usage is whatever amount MariaDB MySQL requires so your answer = it's relative to your usage

Also read how linux reported memory usage differs from windows at https://www.linuxatemyram.com/

 

Also you can use pidstat to check process usage for mysqld binary/process which should be accurate on non-openvz systems (openvz systems report memory used differently)

Code (Text):

pidstat -C mysqld -durhl | sed -e "s|$(hostname)|hostname|g"

example output with mysqld RSS memory used = 1,331,880 bytes or 4.07%

Code (Text):

pidstat -C mysqld -durhl | sed -e "s|$(hostname)|hostname|g"
Linux 3.10.0-1160.6.1.el7.x86_64 (hostname)     01/08/2021      _x86_64_        (8 CPU)
#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1610074615   994      2428    0.01    0.02    0.00    0.03     1      0.09      0.00 13245076 1331880   4.07      0.11      0.05      0.00  /usr/sbin/mysqld

if you have active mysqld load, you can run pidstat at 1 second interval for 10 runs too. If you don't have active mysqld load, it will come back with empty entries

Code (Text):

pidstat -C mysqld -durhl 1 10 | sed -e "s|$(hostname)|hostname|g"