Hi,
I have upgraded our OJS from OJS S 3.3.0-14 to OJS 3.4.0-3. It works ok but it is very slow. All other applications and OJS 3.3.0-14 in our server running with Mysql and PHP run fast. Do anyone have an idea about this problem?
- Obi
Hi @obi,
Do you know whether it’s the MySQL processes or the PHP processes (or something else) that represent the additional load? (Related: this thread)
Regards,
Alec Smecher
Public Knowledge Project Team
Hi Alec,
Thanks for helping. I think Mysql (mariadbd) is the culprit. I have looked at the logs and I cannot figure out why all the ojs3.4.x’s(3.4.0.1, 3.4.0.2, 3.4.0.3) are too slow and not ojs 3.3.0.14. I have copied the installation to three different servers and got the same result. All the servers are running php v8.2.10 and mysql (mysql Ver 15.1 Distrib 10.11.3-MariaDB) on Linux Debian 12.
Obi
Hi @obi,
One major difference between 3.3.0-x and 3.4.0-x is that we introduced foreign key constraints. I haven’t experienced this to perform a lot slower, but it might be worth investigating (and may be something that needs separate tuning in the MySQL configuration).
Regards,
Alec Smecher
Public Knowledge Project Team