OJS mysql slow/uses all resources

Software Support
,
1

Dear all,

we are using OJS 3.3.0.5 (upgraded to that version from 3.1.1.1 about a year ago) and the mysql is constantly using way too many resources so the performance is very bad.

Searching this forum I found only two similar items (Mysql slow after upgrade to OJS 3.3.0.6 and Working with large metrics tables - #3 by retostauffer), but that is not my case (all tables are innodb and the suggested key is available in the table).
The mytop tool shows that constantly several following SQLs are running:

SELECT submission_id, month, SUM(metric) AS metric FROM metrics WHERE context_id = 1 AND assoc_type = 1048585 AND month = '202301' AND metric_type = 'ojs::counter' GROUP BY submission_i....

Any idea how to investigate/solve the issue?

Regards, Primož

2

Do you use this plugin or a similar one?

If so, you can try disabling it to see if that fixes it.

Also, see if this issue affects you:

3

Hi @abadan,

Yes, we are/have been using the mostRead plugin. Disabling it looks like solving the issue. We’ll keep observing it. Thank you very much for the hint!

Regards, Primož

4

Hi @abadan ,

I can now confirm that disabling the mostRead plugin was the solution, thank you once more.

Regards, Primož

1 Like