Title: High CPU usage and database performance problems
Last modified: September 10, 2020

---

# High CPU usage and database performance problems

 *  Resolved [techwpdrift](https://wordpress.org/support/users/techwpdrift/)
 * (@techwpdrift)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/high-cpu-usage-and-database-performance-problems/)
 * Hi, we’re experiencing some problems in our website while using Caldera Forms
   as we described in the following Github issue.
 * [https://github.com/CalderaWP/Caldera-Forms/issues/3617](https://github.com/CalderaWP/Caldera-Forms/issues/3617)
 * We need help because Caldera Forms seems to be generating a lot of stuck queries
   in our database that slow down the entire website and making it unusable.
 * WordPress Version: 5.4.2
    PHP Version: 7.3.16 MySQL Version: 5.7.26 Caldera Forms
   Version: 1.9.2
 * Caldera Forms is generating a lot of queries like the following ones:
    UPDATE
   wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ UPDATE wp_options
   SET option_value = ‘8’ WHERE option_name = ‘CF_DB’
 * As well, here you have some of the PHP errors we also get. How can we proceed
   to solve this?
 * Could it be related to stuck data, transients or something like that? We need
   a solution because we can’t use website as we have done so far. Thanks
 * [Sun Sep 06 19:12:27.048021 2020] [php7:notice] [pid 22241] [client 10.0.3.229:
   62174] Error Lock wait timeout exceeded; try restarting transaction from the 
   WordPress database for the query UPDATE `wp_options` SET `option_value` = ‘7’
   WHERE `option_name` = ‘CF_DB’ 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, Caldera_Forms::
   init_cf_internal, update_option, referer: [http://ourwebsite.com/](http://ourwebsite.com/)
 * [Sun Sep 06 19:12:27.048269 2020] [php7:notice] [pid 21817] [client 10.0.1.14:
   2682] Error Lock wait timeout exceeded; try restarting transaction from the WordPress
   database for the query UPDATE `wp_options` SET `option_value` = ‘7’ WHERE `option_name`
   = ‘CF_DB’ 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, Caldera_Forms::init_cf_internal, 
   update_option, referer: [http://ourwebsite.com/](http://ourwebsite.com/)
 * [Sun Sep 06 19:12:27.048479 2020] [php7:notice] [pid 21820] [client 10.0.3.229:
   62176] Error Lock wait timeout exceeded; try restarting transaction from the 
   WordPress database for the query UPDATE `wp_options` SET `option_value` = ‘7’
   WHERE `option_name` = ‘CF_DB’ 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, Caldera_Forms::
   init_cf_internal, update_option, referer: [http://ourwebsite.com/](http://ourwebsite.com/)
 * [Sun Sep 06 19:12:27.048671 2020] [php7:notice] [pid 22243] [client 10.0.3.229:
   62178] Error Lock wait timeout exceeded; try restarting transaction from the 
   WordPress database for the query UPDATE `wp_options` SET `option_value` = ‘7’
   WHERE `option_name` = ‘CF_DB’ 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, Caldera_Forms::
   init_cf_internal, update_option, referer: [http://ourwebsite.com/](http://ourwebsite.com/)
 * [Sun Sep 06 19:12:27.048896 2020] [php7:notice] [pid 22252] [client 10.0.1.14:
   2356] Error Lock wait timeout exceeded; try restarting transaction from the WordPress
   database for the query UPDATE `wp_options` SET `option_value` = ‘8’ WHERE `option_name`
   = ‘CF_DB’ 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, Caldera_Forms::init_cf_internal, 
   caldera_forms_write_db_flag, update_option, referer: [https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-1/](https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-1/)
 * [Sun Sep 06 19:12:29.116185 2020] [php7:notice] [pid 22267] [client 10.0.3.112:
   51550] Error Lock wait timeout exceeded; try restarting transaction from the 
   WordPress database for the query UPDATE `wp_options` SET `option_value` = ‘7’
   WHERE `option_name` = ‘CF_DB’ 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, Caldera_Forms::
   init_cf_internal, update_option
 * [Sun Sep 06 19:12:30.032582 2020] [php7:notice] [pid 22013] [client 10.0.3.229:
   61974] Error Lock wait timeout exceeded; try restarting transaction from the 
   WordPress database for the query UPDATE `wp_options` SET `option_value` = ‘7’
   WHERE `option_name` = ‘CF_DB’ 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, Caldera_Forms::
   init_cf_internal, update_option, referer: [https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-2/](https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-2/)
 * [Sun Sep 06 19:12:33.701280 2020] [php7:notice] [pid 22269] [client 10.0.1.14:
   2822] Error Lock wait timeout exceeded; try restarting transaction from the WordPress
   database for the query UPDATE `wp_options` SET `option_value` = ‘7’ WHERE `option_name`
   = ‘CF_DB’ 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, Caldera_Forms::init_cf_internal, 
   update_option, referer: [https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-3/](https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-3/)
 * [Sun Sep 06 19:12:34.047351 2020] [php7:notice] [pid 22271] [client 10.0.1.14:
   2834] Error Lock wait timeout exceeded; try restarting transaction from the WordPress
   database for the query UPDATE `wp_options` SET `option_value` = ‘7’ WHERE `option_name`
   = ‘CF_DB’ 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, Caldera_Forms::init_cf_internal, 
   update_option
 * [Sun Sep 06 19:12:38.826918 2020] [php7:notice] [pid 22270] [client 10.0.3.229:
   62258] Error Lock wait timeout exceeded; try restarting transaction from the 
   WordPress database for the query UPDATE `wp_options` SET `option_value` = ‘7’
   WHERE `option_name` = ‘CF_DB’ 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, Caldera_Forms::
   init_cf_internal, update_option
 * [Sun Sep 06 19:12:40.827839 2020] [php7:notice] [pid 22274] [client 10.0.1.14:
   2904] Error Lock wait timeout exceeded; try restarting transaction from the WordPress
   database for the query UPDATE `wp_options` SET `option_value` = ‘7’ WHERE `option_name`
   = ‘CF_DB’ 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, Caldera_Forms::init_cf_internal, 
   update_option, referer: [https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-4/](https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-4/)

The topic ‘High CPU usage and database performance problems’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/caldera-forms_475846.svg)
 * [Caldera Forms - More Than Contact Forms](https://wordpress.org/plugins/caldera-forms/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/caldera-forms/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/caldera-forms/)
 * [Active Topics](https://wordpress.org/support/plugin/caldera-forms/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/caldera-forms/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/caldera-forms/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [techwpdrift](https://wordpress.org/support/users/techwpdrift/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/high-cpu-usage-and-database-performance-problems/)
 * Status: resolved