• sffandom

    (@sffandom)


    Running many WordPress installations on several different hosting services, I have found myself having to repair+optimize the databases every 1-2 weeks on many if not all the multisite installations. There seems to be little correlation between the amount of traffic a site receives and how often the database becomes corrupted.

    I am blocking access to “wp-login.php” and “xmlrpc.php” so I don’t think the botnets are causing the problem but I don’t know what to look for.

    Root domains may continue to work but WordPress becomes unable to resolve well-established subdomains. I have to activate a plugin to repair and optimize the database on the root domain and after doing that everything works fine again.

    Any suggestions on what I can do to track down the problem OTHER than disabling all plugins will be appreciated. I can’t allow the sites to run without the plugins for 1-2 weeks just to see if it’s a plugin issue. Nearly all of the plugins have been updated at least once, some twice, and a couple several times over the past two months.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    How big is this Database?

    How are you running these repairs?

    Thread Starter sffandom

    (@sffandom)

    The databases are of varying sizes. Some sites have just a few posts and some have hundreds.

    I use the WP DB manager plugin to run the repair and optimization tasks.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    Are you actually using Multisite here on separate hosts, or are these all separate installs of WP?

    Thread Starter sffandom

    (@sffandom)

    Multiple installations of multisite networks configured for subdomains on several different hosting services. 3 of the installations are on a dedicated server.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Frequent Database Corruptions’ is closed to new replies.