• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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: 2
Back
Top