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:
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.
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,