Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04

[Peter Bukaowski]

Hello Oyster and thanks for your reply.
I did enabled PF and according to PF my total memory usage is :

Total Memory Allocated
213986736

+---------------------------+---------------+
| code_area | current_alloc |
+---------------------------+---------------+
| memory/performance_schema | 163.56 MiB |
| memory/sql | 22.58 MiB |
| memory/innodb | 20.51 MiB |
| memory/memory | 1.55 MiB |
| memory/mysys | 134.95 KiB |
| memory/myisam | 46.41 KiB |
| memory/vio | 496 bytes |
+---------------------------+---------------+

However top and ps shows :
ps -aux | grep mysql
root 3067 0.0 0.1 38380 5104 pts/1 S+ 12:07 0:00 mysql
root 3071 0.0 0.0 16976 912 pts/0 S+ 12:07 0:00 grep --color=auto mysql
mysql 22375 9.1 41.2 3713688 1669464 ? Ssl 11:17 4:33 /usr/sbin/mysqld