Not Solved mybb_sessions update has abnormally high query time
#1
Not Solved
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)
[Image: 59546d176b2fb5acf32d567c3b66f33a.png]
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
Reply
#2
Not Solved
PHP Version: 7.3.4-1+ubuntu18.04.1+deb.sury.org+3 same thing
Reply
#3
Not Solved
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.
Reply
#4
Not Solved
It seems like it's exactly the same as it was after I changed the table storage engine Sad
I doubt it will change but I will keep it as memory for a while.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)