After upgradation of OJS 2.4 to 3.3.0.10 website is working fine but after 4-5 h portal is slow

After upgradation of OJS 2.4 to 3.3.0.10 website is working fine but after 4-5 h portal is slow. And if we restart mysql then working fine for 4-5 H.

Please help.

Hi @shantanusingh,

Do you have any reporting mechanisms available to you through your host that might point to what the issue is? The PHP error logs might provide some clue - but its hard to say for certain, because this could be due to any number of things.

-Roger
PKP Team

During slow and not accessible of portal no error log generated in php error log.
My MySQL engine is MyISAM and MySQL version is 8.0
PHP version is 7.28
OS Redhat 7.

Hi @shantanusingh

MyISAM is usually the culprit when you got performance issues in mysql.
Move from MyISAM to innoDB.

Then test it a couple of days and if you still notices it’s working slow, enable slowqueries in your mysql to find who is taking the resources. If you still got in trouble, you will probably find it’s related with issues with big tables (that in some cases could be trimmed)

Cheers,
m.

2 Likes