Issue Sudden High mariadb / mysql memory usage

[thinkjarvis]

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.

 

[Martin Dias]

As a start, try to check on this spikes what is running on MySQL with the MySQL process list

https://support.plesk.com/hc/en-us/articles/12377745364375-How-to-troubleshoot-slow-performance-of-MySQL-MariaDB-on-a-Plesk-server

That can give more details on what to check further

 

[learning_curve]

~~

https://support.plesk.com/hc/en-us/articles/12377745364375-How-to-troubleshoot-slow-performance-of-MySQL-MariaDB-on-a-Plesk-server

~~

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

 

[thinkjarvis]

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?