• 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.
  • Our UX team believes in the in the power of direct feedback and would like to invite you to participate in interviews, tests, and surveys.
    To stay in the loop and never miss an opportunity to share your thoughts, please subscribe to our UX research program. If you were previously part of the Plesk UX research program, please re-subscribe to continue receiving our invitations.
  • 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.

Issue Sudden High mariadb / mysql memory usage

T

thinkjarvis

Basic Pleskian
Server operating system version
Ubuntu 22.04.5 LTS
Plesk version and microupdate number
Plesk Obsidian v18.0.65_build1800241106.13
We are suddenly seeing the mariadb usage hit 41% and mysql memory usage spike and stay consistently high at around 60gb out of our 128gb server.

Typically this value should be around 30gb day to day but something is causing the memory useage to spike.

We havent made any particular changes.

If I go into the process list I can see that mariadb is showing 41% usage.

Can anyone provide me with some methods to identify specifically what is causing the high usage?

The problem started back in October - Thes screenshot is 90 days. With no major changes to our hosting or web system this is now the situation. The server crashed yesterday due to running out of mysql workers so I have increased this from 151 default to 450.

1731509105594.png
 
Martin Dias said:
~~ ~~
Click to expand...
That's a helpful article, unless, you're using Plesk with MariaDB 11.4.* which Plesk does support.
Those MariaDB 11.4.* releases (we're on MariaDB 11.4.4 and it's unchanged) are still not yet supported by Plesk's Performance Booster:

Question - Optmized values for MariaDB

Hello, I have a webserver with 150 websites. I notice especially slow response of websites, especially when I'm logged into Wordpress admin. The server has no memory or CPU problems and the disks are fast. I notice that there is a lot of traffic (read & write) in MariaDB. The total DISK READ...
talk.plesk.com talk.plesk.com
 
Non of this has helped unfortunately.
I need to be able to see what is being saved in the mysql memory specifically.
We have identified which website it is.
Any ideas how I can see what is being saved to the mysql memory?
 
You must log in or register to reply here.

Similar threads

AdrianC
Issue MariaDB High "created tmp disk tables"
Replies
9
Views
6K
AdrianC
AdrianC
B
Issue High latency, unreliable performance & 522 errors on a Plesk server that ran fine for 6+ months
Replies
8
Views
1K
HHawk
HHawk
T
Issue Acronis backup memory leak/kernel panic issue causing server crash
Replies
1
Views
2K
AcronisDennis
A
A
Question Apache & PHP-FPM memory usage spike and no CPU usage
Replies
16
Views
7K
LTUser
LTUser
deantenea
Issue Innodb Corruption
Replies
5
Views
3K
reirod
R
Back
Top