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