Re: MySql Swapping issues
- Date: Thu, 8 Sep 2016 19:09:22 +1000
- From: Jesper Wisborg Krogh <mysql@xxxxxxxxxx>
- Subject: Re: MySql Swapping issues
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
Note that there is a little extra overhead instrumenting the memory.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql