I’ve been managing an Ubuntu-based VPS where everything was running smoothly until recently. Suddenly, the mysqld service started consuming far more resources than usual. Initially, I managed to resolve the issue by manually killing the process using its PID and then restarting the service. However, after approximately 8 hours, the problem resurfaced, with mysqld once again causing a spike in CPU usage.

I’ve meticulously reviewed the entire codebase, ensuring that every MySQL connection is correctly closed after use. Despite these efforts, the problem persists, and I’m at a loss as to what might be causing it.

System Information:
. Ubuntu 22.04.4 LTS
. mysql Ver 8.0.36-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

Here is the ss of starts from htop command:

Any insights or suggestions on how to troubleshoot and resolve this issue would be greatly appreciated.