FAQ Admin Pages Slow w/User Tracking Enabled

[birwin88]

I've noticed that it can take upwards of 60 seconds for me to login to the admin side of my FAQ if I have user tracking enabled and the mysqld process is eating up 100% of my CPU usage during that time. Any time I load the dashboard or the statistics page from the admin panel, it slows to a crawl. Most of the time, we have between 30-40 active users.

The moment I disable user tracking, the admin logins take roughly 5-7 seconds and the whole site is more responsive.

Running 2.8.13 on 14.04.01 LTS with mariadb 10.1 (replaced mysql in hopes of improving the speed)

System Specs:
CPU - VM - 2 Cores @ 2.10GHz
RAM - 4GB
HDD - 25GB of SSD space

Should I just keep user tracking off or is there something wrong with my setup?

Thanks!

[Thorsten]

Hi,

thanks for the info, I added a bug ticket: https://github.com/thorsten/phpMyFAQ/issues/925

bye
Thorsten

[Thorsten]

Hi,

how many entries do you have in the table faqsessions?

bye
Thorsten

[birwin88]

Hey Thorsten,

Sorry for the delay in my response.

I have a lot of records in there.. I have 2.2 million entries in that table.


Thanks

[Thorsten]

Hi,

please add this index to your database:

Code: Select all

CREATE INDEX index_time ON faqsession (time);

Will add this to 2.8.16. Thanks!

bye
Thorsten