Re: MySql Swapping issues

Hi Machiel,

On 8/09/2016 05:24, Machiel Richards wrote:
> ...
>
> Biggest issue at the moment is mysql taking all physical memory until
> nothing left, the starts swapping as well until that is completely used up.

Since you are using MySQL 5.7, you can consider enabling memory 
instrumentation in the Performance Schema:

     UPDATE performance_schema.setup_instruments SET ENABLED = 'YES' 
WHERE NAME LIKE 'memory/%';

That may help to locate where the memory is used.

To monitor the memory usage use either the sys.memory_% views 
(https://dev.mysql.com/doc/refman/5.7/en/sys-schema-views.html) or the 
Performance Schema summary tables 
(https://dev.mysql.com/doc/refman/5.7/en/memory-summary-tables.html).

Note that there is a little extra overhead instrumenting the memory.

Best regards,
Jesper Krogh
MySQL Support


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql