High swapping (si/so) with perfommance impact at 5.6.26

MySQL & MariaDB Percona Server for MySQL 5.6
2

Hi,

You can trace memory issues with Valgrind Massif for more info check here

[url]https://www.percona.com/blog/2014/01/24/mysql-server-memory-usage-2/[/url]

  1. Is the innodb_buffer_pool_size to high as per descripted environment ?
    Please provide output from
    [url]https://github.com/major/MySQLTuner-perl[/url]

  2. How much memory shall i take into accunt for each thread when doing the requied memory calculations ?
    Each thread connecting to MySQL server will needs its own buffers. About 256K is allocated at once even if thread is idle – they are used by default thread stack, net buffer etc.

more info here
[url]https://www.percona.com/blog/2006/05/17/mysql-server-memory-usage/[/url]