MyBB Community Forums

Hello,

I noticed that since a few months mybb_sessions update query takes abnormally long time - up to a few seconds (sometimes 5 or 9)

first load of the website usually takes the longest query time, after a few times of refreshing the forum it goes back to normal speed as its not updating this session anymore.

my forum is at www.kiepownica.pl


I am running PHP 7.2.16-1+ubuntu18.04.1+deb.sury.org+1
and 8.0.15 - MySQL Community Server - GPL

Any tips of what could be wrong are highly appreciated. 

mybb database is using InnoDB utf8mb4_unicode_ci database

PHP Version: 7.3.4-1+ubuntu18.04.1+deb.sury.org+3 same thing

I commonly set the mybb_sessions table to use the MEMORY storage engine instead of InnoDB/MyISAM.

ALTER TABLE mybb_sessions ENGINE = MEMORY;

Give that a try and see if things improve.

It seems like it's exactly the same as it was after I changed the table storage engine
I doubt it will change but I will keep it as memory for a while.