Two days ago I was able to succesfully run a test upgrade for my OJS from 3.1.2 to 3.3.0-14. The next step was to run rebuildSearchIndex. The problem here is that rebuildSearchIndex is running for almost two days and indexed around 5000 articles so far, which is maybe half of our content. I think this is slow.
My system specs are:
Ubuntu 18.04.6 LTS
4 cores Intel(R) Xeon(R) CPU E5-2620 v2 @ 2.10GHz
I recently changed the database engine to InnoDB, the charset is utf8mb4 and the collation is utf8mb4_unicode_ci (some tables are still using utf8_general_ci, which is something I have to correct), so maybe my MySQL is not configured the best way. The CPU load doesn’t seem high, around 15% to MySQL and 5-10% to PHP most of the time. Is there a way to find out if the process really is slow? Is there a way to speed this up?