# High swapping (si/so) with perfommance impact at 5.6.26
**URL:** https://forums.percona.com/t/high-swapping-si-so-with-perfommance-impact-at-5-6-26/5329
**Category:** Percona Server for MySQL 5.6
**Created:** [January 2, 2017, 9:28am UTC](https://forums.percona.com/t/high-swapping-si-so-with-perfommance-impact-at-5-6-26/5329 "2017-01-02T09:28:33Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@avi\_vainshtein](https://forums.percona.com/u/avi_vainshtein)
#### Post date: [January 2, 2017, 9:28am UTC](https://forums.percona.com/t/high-swapping-si-so-with-perfommance-impact-at-5-6-26/5329/1 "2017-01-02T09:28:33Z")
Greetings,
We use a 5.6.26 community edition MySQL at RedHat 6.2 64-bit box with 6 cpu and 24G RAM.
We experience high swap usage (11g from allocated 24g of swap) and high si/so values as from vmstat.
Some of main settings from my.cnf:
innodb\_buffer\_pool\_size=20G
innodb\_log\_buffer\_size=8388608
key\_buffer\_size=8388608
binlog\_cache\_size=32768
sort\_buffer\_size=262144
join\_buffer\_size=262144
tmp\_table\_size=33554432
max\_heap\_table\_size=33554432
innodb\_ft\_total\_cache\_size=640000000
innodb\_ft\_min\_token\_size=2
max\_connections=700
Application uses a lot of stored procedures with “create temporary table … engine-memory”, and full text search is in use as well.
The regular number of connected threads is usualy 300-400, but there sometimes unclear peaks till 500.
Some questions:
1, How can i clear out which mysql activity causes the high swapping ?
2. Is the innodb\_buffer\_pool\_size to high as per descripted environment ?
3. How much memory shall i take into accunt for each thread when doing the requied memory calculations ?
Best regards and looking forward your assistance,
Avi Vainshtein
---
### Author:  [@zarere](https://forums.percona.com/u/zarere)
#### Post date: [July 22, 2018, 11:56pm UTC](https://forums.percona.com/t/high-swapping-si-so-with-perfommance-impact-at-5-6-26/5329/2 "2018-07-22T23:56:19Z")
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]](https://www.percona.com/blog/2014/01/24/mysql-server-memory-usage-2/%5B/url%5D)
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]](https://github.com/major/MySQLTuner-perl%5B/url%5D)
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]](https://www.percona.com/blog/2006/05/17/mysql-server-memory-usage/%5B/url%5D)