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

[Øystein Grøvlen]

Hi,

Note that in MySQL 5.7, performance schema contains information about memory usage within MySQL. Take a look at the tables describe in:

https://dev.mysql.com/doc/refman/5.7/en/memory-summary-tables.html

To get a summary of current usage you can use a sys schema view:
select * from sys.memory_global_by_current_bytes;

Note that you first need to enable the collection of memory statistics using this statement:

UPDATE performance_schema.setup_instruments
SET enabled = 'YES'
WHERE name LIKE 'memory/%';

Hope this helps,

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway