Resolved MySQL memory usage limit exceeded

[shopuser]

Server operating system version

Ubuntu 20.04.6 LTS

Plesk version and microupdate number

Plesk Obsidian v18.0.65

How i can change or configurate the memory for MYSQL ?? i have installed MariaDB

10.3.39 and via Docker mysql 5.7.34 Docker show : Ressourcen Memory : 1.7 GB from 31.4 GB

 

[Sebahat.hadzhi]

If you are getting such notification, it most likely indicates that the MySQL memory threshold defined in Monitoring has been exceeded. What you can do is navigate to Monitoring > Settings > Thresholds and increase the MySQL memory usage threshold. If that's not the case, please provide us with more details.

 

[shopuser]

yes I knew that I could change the limits but I thought there was a different limit for MYSQL at the server or configuration , so it's not that relevant

 

[AYamshanov]

Docker show :

Ressourcen
Memory : 1.7 GB from 31.4 GB

I believe it is a limit for a container with MySQL, not for MySQL itself. As I understand, you do not have it configured, the Docker service allows the container to get all available memory if it needs it.


If you want to change the container's limit, you can use the Plesk Docker extension for that,
If you want to change MySQL settings, then you need to use a custom my.cnf file, see https://hub.docker.com/_/mysql

 

[shopuser]

I believe it is a limit for a container with MySQL, not for MySQL itself. As I understand, you do not have it configured, the Docker service allows the container to get all available memory if it needs it.
View attachment 27604

If you want to change the container's limit, you can use the Plesk Docker extension for that,
If you want to change MySQL settings, then you need to use a custom my.cnf file, see https://hub.docker.com/_/mysql thanks

Ok thanks, then there is no problem I have the container without limit.