• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

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