So my wiki has gone through a few decades of upgrades and I would consider its database surely rife for optimization. I noticed this as I am unable to upgrade to the latest LTS, so now I am trying to isolate and fix as many problems with the database as I can.
One is shoddy files and other corruptions. Most maintenance scripts don't seem to really fix this.
One problem I have is similar to this one https://stackoverflow.com/questions/34143056/main-page-error-of-mediawiki
I have a file that displays properly but has no 0 revision registered for some reason and I cannot edit it, either. None of the "fixes" I can find on here and elsewhere on the web really help. I appreciate any pointers to maintenance scripts, hacks and other tips to really (really) fix flawed database structures etc...