WordPress database errors Deadlock found

This error and variations with various tables is hammering the server. I need to get this resolved.

WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name LIKE ‘_transient_timeout_book_res_%’ LIMIT 1000; made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, pmxi_wp_loaded, PMXI_Import_Record->execute, PMXI_Import_Record->process, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Bookings->clear_cache_on_save_post, WC_Bookings->clear_cache, WC_Bookings->delete_booking_res_transients