• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Question HIGH RAM USAGE BY MYSQL USER

M

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
You must log in or register to reply here.

Similar threads

ic3_2k
Question MySQL eating ram as devil
Replies
6
Views
2K
ic3_2k
ic3_2k
B
Issue High latency, unreliable performance & 522 errors on a Plesk server that ran fine for 6+ months
Replies
8
Views
2K
HHawk
HHawk
T
Issue Huge performance issues
Replies
11
Views
4K
mow
M
A
Issue Very high Memory high use and very low process
Replies
5
Views
7K
Antrax1
A
J
Issue Plesk remote database connection from localhost in PHP
Replies
2
Views
7K
Hex
Hex
Back
Top