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
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% .
[strong]It could be an inefficient/Slow query?[/strong] 🙄