MariaDB uses more resources than MySQL

M373H

Member
Jan 18, 2015
16
0
1
cPanel Access Level
Root Administrator
I recently upgraded from MySQL 5.5 to MariaDB 10.0 through WHM interface. After upgrading, rebuilding Apache & PHP, I noticed that memory usage went up by around 200+ MB. I have a VPS of 2 GB available. Before the upgrade, free memory was around 825 MB. However, after MariaDB installed the memory became around 600 MB. I'm not 100% sure if MariaDB was the reason for the higher memory usage or not.

Here is my top command output:
Code:
Tasks:  46 total,   1 running,  45 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   2097152k total,  1476880k used,   620272k free,        0k buffers
Swap:        0k total,        0k used,        0k free,   339012k cached

PID USER      PR  NI  USED  RES  SHR S %CPU %MEM    TIME+  COMMAND
  831 mysql     20   0 66892  65m 8540 S  0.3  3.2   0:00.61 mysqld
  905 root      20   0 56312  54m 3336 S  0.0  2.7   0:01.19 /usr/local/cpan
  906 root      20   0 54172  52m 1188 S  0.0  2.6   0:00.00 spamd child
1104 root      20   0 29276  28m 1508 S  0.0  1.4   0:00.06 cpsrvd (SSL) -
1188 root      20   0 22500  21m  560 S  0.0  1.1   0:00.00 cpdavd - accept
  954 nobody    20   0 22056  21m  740 S  0.0  1.1   0:00.00 nginx
  655 root      20   0 21120  20m 1768 S  0.0  1.0   0:00.47 lfd - sleeping
1122 root      20   0 20612  20m 1224 S  0.0  1.0   0:00.00 dnsadmin - serv
1165 root      20   0 16656  16m 1232 S  0.0  0.8   0:00.19 tailwatchd
1031 root      20   0 11428  11m 2896 S  0.0  0.5   0:00.06 leechprotect
1111 root      20   0  7312 7312 1564 S  0.0  0.3   0:00.02 queueprocd - wa
  916 root      20   0  6404 6404 4408 S  0.0  0.3   0:00.03 httpd
1199 root      38  18  6100 6100  788 S  0.0  0.3   0:00.00 cpanellogd - sl
1033 nobody    20   0  4740 4740 2268 S  0.0  0.2   0:00.00 httpd
1032 nobody    20   0  3928 3928 1544 S  0.0  0.2   0:00.00 httpd
  892 dovenull  20   0  3656 3656 2748 S  0.0  0.2   0:00.01 imap-login
1123 root      20   0  3532 3532 2732 S  0.0  0.2   0:00.04 sshd
I feel that output is illogical. At the beginning of the result it shows 1476880k used which is 1476 MB. If I summed up each process usage plus the cached memory, the result will be much lower than 1400+ MB. From where this memory usage come from?

Any suggestions please? Thank you :)