MySQL Ver 8.0.22
We’re on OJS 18.104.22.168 and run a multi-journal instance. We have been experiencing slow response times for user pages. The public facing pages are not a problem.
For example, when I click on a specific submission, it will take a long time to load. I need some advice on how to track down what the problem could be. I have used Firefox developer tools to measure the performance and can see that certain actions take a long time, but I’m not sure how to identify the exact problem.
My colleague in Library IT also did some testing. They used htop to monitor what was happening when OJS was used. Every time the user does anything in OJS both of the cpus spikes to 100% for a few seconds and mysql is the top user in htop.
We turned on the slow query log in my.cnf and created the mysql-slow.log file with mysql as owner. We didn’t receive anything in the log. We also checked the mysql log to make sure we weren’t getting the slow queries logged in there but they weren’t in there either.
Before we upgraded from OJS 2 we were using 4 cpus and still had a slowness problem. Our IT does not want to upgrade to 4 cpus unless we have a better idea that it will help when it hasn’t in the past.
Do you know of any other monitoring tools that we could use to get more information on what the problem could be? I expected the slow query log to give us information and was surprised that nothing showed up.