Many mysql processes "/usr/bin/mariadbd" and CPU at 100%,makes Friendica unstable
Hello @Friendica Support I need your support please
I have a problem for a few weeks now which makes my server unstable , and makes Friendica inaccessible, the simplest and fastest solution is to restart the server.
I noticed that this problem also happens to me when I send friend requests
Ubuntu Server 24.04 LTS
Friendica version 2024.08
mariadb Ver 15.1 Distrib 10.11.8-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
As you can see from the screenshot there are many mysql
processes , /usr/bin/mariadbd
, and the CPU is at 100%
Some help please...
Thanks
Cheers
Roland Häder🇩🇪 mag das.
Roland Häder🇩🇪 hat dies geteilt.
Michael 🇺🇦
Als Antwort auf Anomaly • • •Anomaly
Als Antwort auf Michael 🇺🇦 • • •Hi @Michael Vogel
I tried to change my configuration
/etc/mysql/my.cnf
I addedThis is the current configuration,I made small changes at a time, but the problem is the same (Bad Gateway Error 502), with the other configurations I had little RAM usage but the CPU was at 100% .
It could be an inefficient/Slow query? 🙄
Roland Häder🇩🇪 mag das.
Anomaly
Als Antwort auf Anomaly • • •