XF 2.2 Forum slowing down, too many Sleep processes

[Recep Baltaş]

Hi,

Our forum is slowing down from time to time lately. It started happening lately and when this happens, there are too many Sleep processes in MySQL Process list.



Server information:

• LSWS 6.0.12
• PHP 8.1
• XF 2.2.9
• Redis 7.0
• ElasticSearch 8.2.2

I'm now rebuilding post reactions cache but any help is welcome.

Thanks.

 

[rdn]

Try MysqlTuner?

cd ~
wget http://mysqltuner.pl/ -O mysqltuner.pl
chmod +x mysqltuner.pl
perl mysqltuner.pl

 

[Recep Baltaş]

Thanks for the tip. I'll try to give it a try. In the meantime, looks like donwgrading to ElasticSearch 7.17.4 solved the issue but I'll be keeping an eye on the issue.