MySQL 8 out of memory on new server?

[Scott Galambos]

I just got this today on a new server that has not been active for long.

messages:Jul 31 15:14:12 main kernel: out_of_memory+0x1bd/0x4e0
messages:Jul 31 15:14:13 main kernel: Tasks state (memory values in pages):
messages:Jul 31 15:14:13 main kernel: Out of memory: Killed process 1488 (mysqld) total-vm:1629292kB, anon-rss:283260kB, file-rss:0kB, shmem-rss:0kB, UID:27 pgtables:1640kB oom_score_adj:0

Can someone tell me what I need to do to stop this? What made this happen? I don't know how to read this error.

This is it running, there is never a problem with memory:
server(/var/adm): free -h
total used free shared buff/cache available
Mem: 7.5Gi 1.4Gi 232Mi 68Mi 5.9Gi 5.8Gi
Swap: 2.0Gi 417Mi 1.6Gi

Mysql Server version: 8.0.34. This is an AlmaLinux 8.8 server running under VMware ESX. I have a CentOS ESX VM too that is perfectly fine.

 

[cPRex]

Hey there! MySQL wasn't necessarily the problem, but that is the process the kernel decided to kill in order to free up some RAM. It would be best to check the sar logs to see if that will tell you what was using so much RAM during that time period, as this is usually difficult to track down after the issue has happened.