ic3_2k
New Pleskian
- Server operating system version
- Almalinux 8.9
- Plesk version and microupdate number
- v18.0.57_build1800231218.09
Hello,
I installed plesk for a customer with default values 2 or 3 months ago.
Yesterday that customer sent me a message about swap being used at 100%, the server has 32Gb of ram, which only 3 of them being used

After searching a little bit found that only 1Gb of swap is available, don't know why during the default system install only 1Gb was detinated to swap partition....
Searched a little bot more to find the origin of this swap use and also found the MySQL with default 128Mb of innodb_buffer_pool_size, so after running mysqltuner I tweaked the values a little bit:
innodb_buffer_pool_size = 20G
table_definition_cache = 5000
table_open_cache = 35000
join_buffer_size = 20M
innodb_log_file_size=4G
innodb_buffer_pool_instances=20
open_files_limit = 10240
performance_schema=ON
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
local-infile=0
# added by Plesk Performance Booster
!include /etc/db-performance.cnf
But after changing this values the usage of MySQL's rocketskyed to the 100% asigned:

when before this changes the memory used by mysql was over 1Gb:

Can someone explain why this happens, and how to solve this problem?
Regards, ic3_2k
I installed plesk for a customer with default values 2 or 3 months ago.
Yesterday that customer sent me a message about swap being used at 100%, the server has 32Gb of ram, which only 3 of them being used

After searching a little bit found that only 1Gb of swap is available, don't know why during the default system install only 1Gb was detinated to swap partition....
Searched a little bot more to find the origin of this swap use and also found the MySQL with default 128Mb of innodb_buffer_pool_size, so after running mysqltuner I tweaked the values a little bit:
innodb_buffer_pool_size = 20G
table_definition_cache = 5000
table_open_cache = 35000
join_buffer_size = 20M
innodb_log_file_size=4G
innodb_buffer_pool_instances=20
open_files_limit = 10240
performance_schema=ON
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
local-infile=0
# added by Plesk Performance Booster
!include /etc/db-performance.cnf
But after changing this values the usage of MySQL's rocketskyed to the 100% asigned:

when before this changes the memory used by mysql was over 1Gb:

Can someone explain why this happens, and how to solve this problem?
Regards, ic3_2k