Very high database load migrating 3.3.0.22 - 3.5.0.5

Software Support
1

Describe the issue or problem
Rehearsing the 3.3.0.22 - 3.5.0.5 migration on DEV to iron out issues causes VERY high load on the MySQL server that we are using, in particular high memory usage, to the extent that it is compromising the machine for other users. Can this be throttled? Is it expected that the normal usage load of 3.5.0.5 is significantly higher than 3.3.0.22

Steps I took leading up to the issue
For example:

  1. Recreate DEV system to 3.3.0.22
  2. Run though upgrade instructions to the ‘time /usr/bin/php /var/www/ojs/tools/upgrade.php upgrade’ command
  3. Watch swap space on MySQL server go up.
  4. Drop the connection
  5. Watch swap space on MySQL server not come down.

What application are you using?
OJS 3.3.0.22 - 3.5.0.5

Additional information
Please add any screenshots, logs or other information we can use to investigate this problem.

2

Hi @stuart.yeates,

I take it you’re talking about the database load caused by the upgrade process itself, not the load after the upgrade to 3.5.0-5 has been completed, right?

There’s nothing built into OJS that will throttle the database load caused by the upgrade process; it’s designed to run flat out. If that’s impacting your other databases, I’d suggest running the upgrade on a different machine (and different DBMS host) – either a testing VM with its own MySQL server, or even a local copy on a home machine. After the upgrade is complete you can move the affected resources (database, files directory, etc) back to the environment where you want to use it.

Regards,
Alec Smecher
Public Knowledge Project Team

3

Thank you @asmecher

We are in currently scheduling an outage for RAM upgrade on the database server.

4

Upgrading the RAM in the MySQL server appears to have fixed the solution.