Support » Plugin: WPMovieLibrary » Database going overboard

  • Hello,

    I have almost 10,000 movies in my library now. I am on a powerful dedicated server. However, everytime i make or edit a post, the CPU usage and ram goes to 100% and then the site eventually stops loading till I have to restart the server or I get “error establishing database connection”.

    I’ve tried migrating the site to different servers and someone told me it’s the wpmovielibrary plugin that is making too many calls. Here’s what we see:

    ROM wpjv_postmeta
    WHERE meta_key LIKE ‘_wpmoly_movie_release_date’
    ORDER BY meta_value made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, wp_widgets_init, do_action(‘widgets_init’), WP_Hook->do_action, WP_Hook->apply_filters, WPMovieLibrary->register_widgets, register_widget, WP_Widget_Factory->register, WPMOLY_Movies_Widget->__construct, WPMOLY_Utils::get_used_years, WPMOLY_Utils::get_used_meta
    [22-May-2017 18:53:52 UTC] PHP Warning: mysqli_query(): MySQL server has gone away in /home/ionlinemovies/public_html/wp-includes/wp-db.php on line 1877
    [22-May-2017 18:53:52 UTC] PHP Warning: mysqli_query(): Error reading result set’s header in /home/ionlinemovies/public_html/wp-includes/wp-db.php on line 1877
    PHP Warning: mysqli_query(): (70100/1317): Query execution was interrupted in /home/ionlinemovies/public_html/wp-includes/wp-db.php on line 1877
    WordPress database error Query execution was interrupted for query SELECT DISTINCT meta_value
    FROM wpjv_postmeta
    WHERE meta_key LIKE ‘_wpmoly_movie_release_date’
    ORDER BY meta_value made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, wp_widgets_init, do_action(‘widgets_init’), WP_Hook->do_action, WP_Hook->apply_filters, WPMovieLibrary->register_widgets, register_widget, WP_Widget_Factory->register, WPMOLY_Movies_Widget->__construct, WPMOLY_Utils::get_used_years, WPMOLY_Utils::get_used_meta
    [22-May-2017 18:53:52 UTC] PHP Warning: Error while sending QUERY packet. PID=22700 in /home/ionlinemovies/public_html/wp-includes/wp-db.php on line 1877

    Is there any way we can drop all the metadata from loading as I am only using these:

    Runtime
    Genres
    overview
    Actors
    Media
    tagline
    details

  • The topic ‘Database going overboard’ is closed to new replies.