Database Breaking Constantaly

  • Hi There,

    My blog is here: The Crafty Classroom

    Problem: Database keeps breaking every couple of days. I have been having issues with the blog since January of this year. I’m not entirely sure, but I believe the problems started with the install of a specific plugin (which I’ve since removed…tables and all I believe)

    Thoughts: Seems to occur more when I make an action that requires a databse change…. adding a plugin, updating a plugin, making theme changes. It happens when I don’t do these things as well, but it sure happens quicker if I do.

    Note: We have over 20K registered users through a membership plugin called Premise. This plugin was active and stable prior to the problem, yes it does drag the database a bit when multiple people are logged in and downloading our ebooks. However after speaking with my webhost (yahoo) I’m told there is ample room to cover the memory and such and it’s not what’s breaking the database.

    I am a novice to the concept of a database, learning along the way here.

    Troubleshooting Steps:
    -Checking for plugin compatibility….manually
    -Updating all plugins
    -Lastest WP, Latest PHP, Latest MYSQL
    -Repair tables
    -Multiple Web host troubleshooting phone calls…..eventually restored database to previous version.
    -Check Error Logs, Repair suggested tables

    Right now I’m backing up my database with every single change and post I make to my blog….everytime it breaks I restore it from my backup.

    Ack!!

    I’m at my end of knowledge here on what else I can do, I’ve spent HOURS upon HOURS dealing with this and if there is any direction to be pointed in, I’ll take it.

    Thanks so much,

    Valerie

    I don’t know if it helps but here is a sample of an error log entry:

    17-May-2014 02:55:19] WordPress database error Table './blog/wp_users' is marked as crashed and should be repaired for query SELECT * FROM wp_users WHERE ID = '1' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/news-pro/front-page.php'), genesis, do_action('genesis_before_loop'), call_user_func_array, news_homepage_top_widget, genesis_widget_area, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, genesis_responsive_sliderWidget->widget, WP_Query->the_post, setup_postdata, get_userdata, get_user_by, WP_User::get_data_by
[17-May-2014 02:55:19] WordPress database error Table './blog/wp_users' is marked as crashed and should be repaired for query SELECT * FROM wp_users WHERE ID = '1' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/news-pro/front-page.php'), genesis, do_action('genesis_before_loop'), call_user_func_array, news_homepage_top_widget, genesis_widget_area, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, genesis_responsive_sliderWidget->widget, WP_Query->the_post, setup_postdata, get_userdata, get_user_by, WP_User::get_data_by
[17-May-2014 02:55:20] WordPress database error Table './blog/wp_users' is marked as crashed and should be repaired for query SELECT * FROM wp_users WHERE ID = '1' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/news-pro/front-page.php'), genesis, do_action('genesis_before_loop'), call_user_func_array, news_homepage_top_widget, genesis_widget_area, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, genesis_responsive_sliderWidget->widget, WP_Query->the_post, setup_postdata, get_userdata, get_user_by, WP_User::get_data_by
[17-May-2014 02:55:20] WordPress database error Table './blog/wp_users' is marked as crashed and should be repaired for query SELECT * FROM wp_users WHERE ID = '1' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/news-pro/front-page.php'), genesis, do_action('genesis_before_loop'), call_user_func_array, news_homepage_top_widget, genesis_widget_area, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, genesis_responsive_sliderWidget->widget, WP_Query->the_post, setup_postdata, get_userdata, get_user_by, WP_User::get_data_by
[17-May-2014 02:55:20] WordPress database error Table './blog/wp_users' is marked as crashed and should be repaired for query SELECT * FROM wp_users WHERE ID = '1' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/news-pro/front-page.php'), genesis, do_action('genesis_before_loop'), call_user_func_array, news_homepage_top_widget, genesis_widget_area, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, genesis_responsive_sliderWidget->widget, WP_Query->the_post, setup_postdata, get_userdata, get_user_by, WP_User::get_data_by

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator t-p

    (@t-p)

    – Try resetting the plugins folder by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause problems (because the hooks remain unless plugins completely removed or some plugins stick around in cached files. So by renaming the folder, you break them and force them inactive).

    Thread Starter Valerie123

    (@valerie123)

    Thanks Tara!

    I took the steps you suggested. I suppose I won’t know if it did any good until my Database breaks or hopefully doesn’t break! ??

    Fingers crossed!

    ?? Valerie

    Consistant database corruption like this is a very sute sign that the hosting platform or the database server can’t keep up with the query requests. Most times when you’re using shared hosting these are the same computer. Database corruption like this happens mainly when queries fail part of the way through their execution. As you said that your site can hammer your database at times, I’d be pretty certain that’s the cause of it all.

    I haven’t had anything to do with Yahoo hosting before so I don’t know what their quality is like, but if I was in this situation I’d be looking at moving to a hosting company that offers higher server specs, or even looking at a VPS for the site so that you have complete control over what resources are available.

    Sidenote: Don’t ask for suggestions on hosting here, as that isn’t allowed and gets threads shut down very quickly. ??

    Thread Starter Valerie123

    (@valerie123)

    Thanks Catacaustic! I hadn’t heard of VPS before, it seems like a viable option for me, I really appreciate the suggestion.

    :)Valerie

    Thread Starter Valerie123

    (@valerie123)

    Well it hasn’t broke yet, but it’s trying to…..it’s sporadically loosing the connection to the database, but then somehow reconnects itself.

    Hmmmmm……

    Long term plan is to get on that VPS, but here in the short term I wonder if there is anything that can be done to keep the database from crashing?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database Breaking Constantaly’ is closed to new replies.