Statistics, ojs::counter and mysql performance killing website


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?


Someone had a problem with OJS performance?

1 Like

This is also in discussion for development here:

Thanks! :slight_smile: