Hi guys,
I'm noob in plesk and I need your advice.
I've got a dedicated VM with 3vCPU and 6GB RAM, and I think the RAM usage by mysql is very high.
I've got a web site (between 20 or 30 users simultaneously connected) and the server behaviour is the following:
4.7 GB usage of 5.8GB, mysql user has the 64%... is this behaviour normal in plesk onyx??
In my my.cnf I've made the following configuration:
max_allowed_packet=500M
innodb_buffer_pool_size=3072M
query_cache_size=0
query_cache_type=0
query_cache_limit=4M
join_buffer_size=3M
thread_cache_size=4
table_open_cache=1000
innodb_file_per_table=1
innodb_log_file_size=384M
innodb_buffer_pool_instances=4
slow_query_log=1
long_query_time=3
slow_query_log_file=/var/log/mariadb/mysql-slow.log
For such configuration, I used the mysqltuner.pl script.
Thanks in advance!
Regards.
I'm noob in plesk and I need your advice.
I've got a dedicated VM with 3vCPU and 6GB RAM, and I think the RAM usage by mysql is very high.
I've got a web site (between 20 or 30 users simultaneously connected) and the server behaviour is the following:

4.7 GB usage of 5.8GB, mysql user has the 64%... is this behaviour normal in plesk onyx??
In my my.cnf I've made the following configuration:
max_allowed_packet=500M
innodb_buffer_pool_size=3072M
query_cache_size=0
query_cache_type=0
query_cache_limit=4M
join_buffer_size=3M
thread_cache_size=4
table_open_cache=1000
innodb_file_per_table=1
innodb_log_file_size=384M
innodb_buffer_pool_instances=4
slow_query_log=1
long_query_time=3
slow_query_log_file=/var/log/mariadb/mysql-slow.log
For such configuration, I used the mysqltuner.pl script.
Thanks in advance!
Regards.