• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

Question HIGH RAM USAGE BY MYSQL USER

mmv10

New Pleskian
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:
13671-2e79c63ed677aa3e620f2930a2571729.jpg


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.
 

Attachments

  • RAM_USAGE.png
    RAM_USAGE.png
    129.3 KB · Views: 1
Back
Top