Title: Database going overboard
Last modified: May 22, 2017

---

# Database going overboard

 *  [llrajsll](https://wordpress.org/support/users/llrajsll/)
 * (@llrajsll)
 * [9 years ago](https://wordpress.org/support/topic/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.

 * ![](https://s.w.org/plugins/geopattern-icon/wpmovielibrary_f6ad77.svg)
 * [WPMovieLibrary](https://wordpress.org/plugins/wpmovielibrary/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpmovielibrary/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpmovielibrary/)
 * [Active Topics](https://wordpress.org/support/plugin/wpmovielibrary/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpmovielibrary/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpmovielibrary/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [llrajsll](https://wordpress.org/support/users/llrajsll/)
 * Last activity: [9 years ago](https://wordpress.org/support/topic/database-going-overboard/)
 * Status: not resolved