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_options WHERE option_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 FROM wp_options WHERE option_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:UPDATE wp_postmeta SET meta_value = ‘1’ WHERE post_id = 3861 AND meta_key = ‘dsq_needs_sync’ AND meta_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 INTO wp_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 INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_doing_cron’, ‘1472300439.3810579776763916015625’, ‘yes’) ON DUPLICATE KEY UPDATE option_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 INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_doing_cron’, ‘1472300439.4281089305877685546875’, ‘yes’) ON DUPLICATE KEY UPDATE option_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:UPDATE wp_postmeta SET meta_value = ‘1’ WHERE post_id = 3206 AND meta_key = ‘dsq_needs_sync’ AND meta_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 FROM wp_options WHERE option_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 FROM wp_options WHERE option_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 INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_doing_cron’, ‘1472300489.2011399269104003906250’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

Viewing 7 replies - 1 through 7 (of 7 total)

  • Theses are normal queries, WordPress check every time someone visit/refresh your website, if there is any action need to be executed (update WP/plugin/theme, remove expired data ..etc).
    This maybe frustrating for some “modest servers” so you need to disable the WP Cronjobs and create a cronjob from your CPanel.

    Thread Starter sarangsss29

    (@sarangsss29)

    Thanks for the reply. So does disabling the WP-Cron job affect my website?
    Can I use this tutorial to disable the WP-Cron Job and make it manual?
    https://www.inmotionhosting.com/support/website/wordpress/disabling-the-wp-cronphp-in-wordpress

    Also, if I upgrade to some better server, will the error go away?

    If meant in a bad way no actually this procedure makes it faster, the tutorial looks good ??

    Upgrading your server is usually helps but that depends on your website traffic and the new host resources.

    if you need any advice about hosting i can get you some ??

    Thread Starter sarangsss29

    (@sarangsss29)

    Definitely. Could you recommend me some good Shared hosting services that could provide with No monthly Bandwidth restriction (or atleast 1TB-2TB) and also good support. My website traffic has increased since I started and constantly increasing. Maybe I need a better web host.
    I am currently using Hostgator.in and as claimed by some wordpress users I contacted, it is a reseller. Though my website is optimized, it constantly gave me resource limit reached errors before I used a CDN. I should have gone with Hostgator.com. Anyway, I believe, Dream Host and Digital Ocean are better. They are a bit expensive but that’s fine if I get a better hosting and won’t get me downtime. What are your thoughts? Also, what about VPS?

    VPS are always better choices if you can deal with terminals ?? i’m using DigitalOcean my self for 2 years now, i’m pretty happy with it but as i said you may need to be familiar with terminals UI.

    P.S. VPS give the opportunity to install SSL(HTTPS) certificate (lets encrypt) which is free beside installing cache system like REDIS/APC so your website became super fast.

    Thread Starter sarangsss29

    (@sarangsss29)

    I am not familiar with terminal UI. Moreover, I have checked some of the hosting providers and found VPS is expensive and has limited bandwidth which is not my requirement. Digital Ocean looks more like for developers. Do they provide Cpanel with wordpress installer? They only have one plan so everything is VPS there?

    Do you have any experience with DreamHost? They provide SSD storage even in shared hosting and reviews are pretty good even in shared web hosting. Here are their plans:
    https://www.dreamhost.com/hosting/shared/
    What do you say?

    I tried many shared hosting believe me they not even worth the cheap price they offer, VPS (5$/month) is good deal but there is no cpanel.

    Most web hosting companies gives you a trial :). by the way bandwidth is limited even they said its not.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Entry Processes exceeding while logging into Wp-Admin’ is closed to new replies.