We have an instance of MySQL 8.4.2 running on a local Windows Server 2022 VM. It ran fine for 12 days, but suddenly it is consuming a lot of memory. I've deducted this from the Windows Event log and the MySQL error log, but I'm no expert (hence the Newbie forum).
Example: (MySQL error log) [ERROR] [MY-010934] [Server] Out of memory (Needed 1594376 bytes) and (Windows event log) The following programs consumed the most virtual memory: mysqld.exe (2944) consumed 15530082304 bytes.
Here's the whole MySQL error log:
https://pastebin.com/4pcwaDHJ
Anyone who can help me figure out what might be going on, and perhaps tell me if the my.ini-settings are completely wrong?
I've run MySQLTuner for Windows, without finding any issue exept 6001 joins performed without indexes (over the last 7 hours).
Here's the my.ini-file:
https://pastebin.com/4bSbM5Vz
The server is a VM with 24 GB RAM and runs Wordpress (PHP) under IIS. Runs between 5 and 30 sites (WP and some also WooCommerce) at all times, but three at the moment. MySQL is consuming about 2GB when I look at it in Task Manager.
Thanks in advance.
-Espen.