Tables Corrupting and MYSQL Stopping

Hi there WPMUDEV community.

We're setting up a multisite network and right now we have 40+ live sites.

And recently we keep on experiencing serious errors.

MySQL service keeps on stopping and tables of our main site keeps on crashing (Ex; "wp_users", "wp_usermeta", "wp_sitemeta".)

Sample Errors:

160811  9:18:50 [ERROR] /usr/sbin/mysqld: Table './mlmalpha_wrdp7/wp_options' is marked as crashed and should be repaired
160811  9:18:50 [Warning] Checking table:   './mlmalpha_wrdp7/wp_options'
160811  9:18:50 [ERROR] /usr/sbin/mysqld: Table './mlmalpha_wrdp7/wp_sitemeta' is marked as crashed and should be repaired
160811  9:18:50 [Warning] Checking table:   './mlmalpha_wrdp7/wp_sitemeta'
160811  9:18:50 [ERROR] /usr/sbin/mysqld: Table './mlmalpha_wrdp7/wp_usermeta' is marked as crashed and should be repaired
160811  9:18:50 [Warning] Checking table:   './mlmalpha_wrdp7/wp_usermeta'
160811  9:18:50 [ERROR] /usr/sbin/mysqld: Table './mlmalpha_wrdp7/wp_users' is marked as crashed and should be repaired
160811  9:18:50 [Warning] Checking table:   './mlmalpha_wrdp7/wp_users'

Previously we also had a crash to our child sites that corrupted the tables and we weren't able to repair and restore the corrupted files.

We have a ready users inside our community of 7,000+ members and we plan to give all of them one site each inside our network. Any tips, recommendations on what we should be doing to create a stable network for this kind of setup?

Thank you in advance for your answers.

  • Dimitris
    • Support Star

    Hey there Eduard,

    I hope that you're having a beautiful day and thanks for asking us! :slight_smile:

    About the issues you're dealing in your MU installation, are these resolved?
    We can have a look if you want, although it may require some time for theme/plugin conflict tests and general inspection. Can't promise anything but we're here if you want us to! :slight_smile:

    About that 7,000+ site creation (!!!) you may need to use our Members area for more feedback as this includes lots of aspects especially in the server side.
    If there isn't any current issue at the moment, I can even move this thread in Members area and keep up from there.

    Warm regards,
    Dimitris

  • Dimitris
    • Support Star

    Hey there Eduard,

    hope you're doing good today! :slight_smile:

    Yes pls move this to members area if needed.

    As this thread's title isn't too good for a members forum and doesn't reflect what you're asking/seeking for, I believe it would be better to create a new one with an appropriate title about this mega multisite. :wink:

    And we keep this thread as is, which reflects more of an issue.
    Feel free to post back here if you need assistance tracking these issues down.

    Kind regards,
    Dimitris

  • Dimitris
    • Support Star

    Hey there Eduard,

    hope you're doing good today! :slight_smile:

    Yes pls move this to members area if needed.

    As this thread's title isn't too good for a members forum and doesn't reflect what you're asking/seeking for, I believe it would be better to create a new one with an appropriate title about this mega multisite. :wink:

    And we keep this thread as is, which reflects more of an issue.
    Feel free to post back here if you need assistance tracking these issues down.

    Kind regards,
    Dimitris

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.