OpenCart 3.0.3.2 slow to load and mysql cpu usage is high

Hi, Our site is running with OpenCart 3.0.3.2 version with Journal 3 Theme. When I tried to edit something on our theme, it is so slow to refresh.
When I tried to check the cpu usage, the mysqld's CPU usage is spiking to 256% or higher.

I tried implementing cache query and changing all the tables storage engine to InnoDB but I am not sure if this is relevant.
I also noticed that table oc1_session has 3.7million+ rows already.

Can someone enlighten me about the oc1_session and if some rows in it can be deleted?
And, any suggestions to speed-up our website because our site now has 45k+ of products and 3k+ categories.

For the session issues , you can see here - https://github.com/opencart/opencart/is ... -557270093

Otherwise contact Journal for support with their theme.

keving_sundial wrote: ↑

Wed Jun 17, 2020 1:28 am

Hi, Our site is running with OpenCart 3.0.3.2 version with Journal 3 Theme.

Submit a ticket here:
https://support.journal-theme.com/

there is no need to put sessions in your database.