Excessive resource usage: mysql

[sergdev777]

Excessive resource usage: mysql
Resource:     Virtual Memory Size
Exceeded:     1122 > 512 (MB)
Executable:   /usr/sbin/mariadbd
Command Line: /usr/sbin/mariadbd
PID:          2030 (Parent PID:2030)
Killed:       No

I receiving this meassage hundred times a day, how possible to check which sql query eats resource or which file calling this query?

[Starburst]

We have that as part of the csf/lfd ignore list under *nix 8.x

But that's how we have it configured. Haven't noticed any problems.

[overseer]

How much memory do you have allocated on your server? I have 6GB on one VM and this is a typical htop sample:

Code Select Expand

   PID USER      PRI  NI  VIRT   RES   SHR S CPU% MEM%   TIME+  Command
17790 mysql      20   0 1552M  431M  6804 S  0.0  7.6  0:00.06 /usr/sbin/mariadbd
  1314 mysql      20   0 1552M  431M  6804 S  0.0  7.6 23:40.57 /usr/sbin/mariadbd
17804 mysql      20   0 1552M  431M  6804 S  0.0  7.6  0:00.06 /usr/sbin/mariadbd

[sergdev777]

How much memory do you have allocated on your server?

2GB.

[sergdev777]

Well, I increased memory on my server to 6GB,  but this "excessive resource usage" alert is still remaining.
Sometimes my server go down while this alert.
How possible to check which DB affect this excessive resource usage??

Account:      mysql
Resource:     Process Time
Exceeded:     719712 > 1800 (seconds)
Executable:   /usr/sbin/mariadbd
Command Line: /usr/sbin/mariadbd
PID:          2123 (Parent PID:2123)
Killed:       No

[overseer]

Enable user statistics so you can monitor resource usage:
https://mariadb.com/resources/blog/using-resource-monitoring-to-avoid-user-service-overload/

[sergdev777]

Enable user statistics so you can monitor resource usage:
https://mariadb.com/resources/blog/using-resource-monitoring-to-avoid-user-service-overload/

Thanks!

[Starburst]

There's allot of false alerts for some reason also.

We added the following to the csf.ignore file back when CentOS 8 first came out:

# CentOS 8
exe:/usr/bin/rpcbind
exe:/usr/sbin/mariadbd
exe:/usr/lib/systemd/systemd-resolved
exe:/usr/sbin/rngd
exe:/usr/bin/rpcbind

--

File can be found at; /etc/csf/csf.pignore

[sergdev777]

There's allot of false alerts for some reason also.

We added the following to the csf.ignore file back when CentOS 8 first came out:

# CentOS 8
exe:/usr/bin/rpcbind
exe:/usr/sbin/mariadbd
exe:/usr/lib/systemd/systemd-resolved
exe:/usr/sbin/rngd
exe:/usr/bin/rpcbind

--

File can be found at; /etc/csf/csf.pignore

The web server is under load or restarting when message about "exe:/usr/sbin/mariadbd" is sent.

[Starburst]

What version MariaDB are you running?

10.11.x is the latest LTS

[sergdev777]

What version MariaDB are you running?

10.11.x is the latest LTS

MariaDB 10.6.15

[overseer]

Love that changelog:

InnoDB
Crashing on I/O error is unhelpful (MDEV-27593)

[sergdev777]

Well, updated to ver 10.11, not resolve the problem.