Statistics, ojs::counter and mysql performance killing website

Software Support
1

Hi,

my ojs version is 2.4.8. Last time i saw a big problem with mysql performance. I checked this and it looks like a metric table problem. When performance is bad i see a lot of process in mysql like this:

"Sending data | SELECT SUM(metric) AS metric FROM metrics WHERE submission_id = ‘3298’ AND metric_type = ‘ojs::counter’ "

My observation:

  • When i clear metric table it resolved my performance problem ( ojs working very good, but i don’t have any statistics )

  • The process “Sending data | SELECT SUM(metric)…” starting every time when someone put in on journal page.

Could You help me with this?
Thanks,

Karol

2

Someone had a problem with OJS performance?

1 Like
3

This is also in discussion for development here:
https://github.com/pkp/pkp-lib/issues/4130

4

Thanks! :slight_smile: