Entry Processes exceeding while logging into Wp-Admin
-
Hello,
I need help with optimizing some database tables or the WP-Admin dashboard. Whenever I log into Wp-Admin or Database table, I get a down time with server resources exceeding and Entry Processes to the max. I am using CDN so my front end is never down. however, my backend (WP-Admin) provides me with resource limit reached 503 error. My hosting service provider sent me this log. Please help me optimize these queries:\2016-08-26 12:20:01 +0000 [info] killed_thread_id:158777289 user:andron7i_297 host:localhost db:andron7i_297 command:Query time:24 query:DELETE FROM
wp_optionsWHEREoption_name= ‘_transient_jetpack_sync_callables_await’
2016-08-26 12:20:06 +0000 [info] killed_thread_id:158777391 user:andron7i_297 host:localhost db:andron7i_297 command:Query time:24 query:DELETE FROMwp_optionsWHEREoption_name= ‘_transient_jetpack_sync_callables_await’
2016-08-27 12:20:38 +0000 [info] killed_thread_id:160091689 user:andron7i_297 host:localhost db:andron7i_297 command:Query time:25 query:UPDATEwp_postmetaSETmeta_value= ‘1’ WHEREpost_id= 3861 ANDmeta_key= ‘dsq_needs_sync’ ANDmeta_value= ‘1’
2016-08-27 12:20:38 +0000 [info] killed_thread_id:160091741 user:andron7i_297 host:localhost db:andron7i_297 command:Query time:22 query:INSERT INTOwp_postmeta(post_id,meta_key,meta_value) VALUES (3991, ‘dsq_needs_sync’, ‘1’)
2016-08-27 12:21:03 +0000 [info] killed_thread_id:160092080 user:andron7i_297 host:localhost db:andron7i_297 command:Query time:24 query:INSERT INTOwp_options(option_name,option_value,autoload) VALUES (‘_transient_doing_cron’, ‘1472300439.3810579776763916015625’, ‘yes’) ON DUPLICATE KEY UPDATEoption_name= VALUES(option_name),option_value= VALUES(option_value),autoload= VALUES(autoload)
2016-08-27 12:21:03 +0000 [info] killed_thread_id:160092082 user:andron7i_297 host:localhost db:andron7i_297 command:Query time:24 query:INSERT INTOwp_options(option_name,option_value,autoload) VALUES (‘_transient_doing_cron’, ‘1472300439.4281089305877685546875’, ‘yes’) ON DUPLICATE KEY UPDATEoption_name= VALUES(option_name),option_value= VALUES(option_value),autoload= VALUES(autoload)
2016-08-27 12:21:28 +0000 [info] killed_thread_id:160092405 user:andron7i_297 host:localhost db:andron7i_297 command:Query time:24 query:UPDATEwp_postmetaSETmeta_value= ‘1’ WHEREpost_id= 3206 ANDmeta_key= ‘dsq_needs_sync’ ANDmeta_value= ‘1’
2016-08-27 12:21:28 +0000 [info] killed_thread_id:160092406 user:andron7i_297 host:localhost db:andron7i_297 command:Query time:24 query:DELETE FROMwp_optionsWHEREoption_name= ‘_transient_jetpack_sync_callables_await’
2016-08-27 12:21:53 +0000 [info] killed_thread_id:160092724 user:andron7i_297 host:localhost db:andron7i_297 command:Query time:25 query:DELETE FROMwp_optionsWHEREoption_name= ‘_transient_timeout_jetpack_sync_callables_await’
2016-08-27 12:21:53 +0000 [info] killed_thread_id:160092725 user:andron7i_297 host:localhost db:andron7i_297 command:Query time:24 query:INSERT INTOwp_options(option_name,option_value,autoload) VALUES (‘_transient_doing_cron’, ‘1472300489.2011399269104003906250’, ‘yes’) ON DUPLICATE KEY UPDATEoption_name= VALUES(option_name),option_value= VALUES(option_value),autoload= VALUES(autoload)
The topic ‘Entry Processes exceeding while logging into Wp-Admin’ is closed to new replies.