Delete thousands of cron jobs

Thanks Privateer for the prompt reply and advice.

I found a way around it before I saw your answer. Here is a step-by-step method for deleting thousands of old cron jobs and may be of use to someone else.

I logged on to phpMyAdmin. I clicked on my database and then the ‘search’ tab. I typed in ‘cron’ then selected ‘all tables’ and clicked ‘Go’. I scrolled down the search results list to my wp_options table. I clicked ‘Browse’. At the top of the list was option_name ‘cron’. I clicked ‘Edit’ then waited for the page to load. I clicked on the box that showed the list of cron jobs. The cron list was so long that it took about 80 seconds for my cursor to respond. I then used Ctrl-A on the keyboard to select all before hitting the delete button. It took about 2 minutes before my browser completed the deletion (chrome timed-out so I tried Firefox which worked).

After another couple of minutes the cron jobs for my current active plugins re-populated the list. There were 9 cron jobs (down from over 29,000!). Six years of duplicate cron jobs from badly coded plugins, some of which I just installed for a day to try out. Also hundreds from common plugins such as Wordfence, BackupBuddy, Nextgen Gallery, and AutoOptimizer – all of which I had uninstalled in the past. My site now loads like it’s been turbo-charged. The admin area is much quicker. Admin timeout errors have disappeared. I had spent so much time on optimising my website trying to decrease the load time. I even moved hosts and upgraded my hosting plans. Nothing increased the speed of my site like deleting all the outdated cron jobs. Mobile download time decreased from 20 seconds to 6 seconds. Desktop download time decreased from about 12 to 4 seconds.

In my search for a solution I found very little information on the effect of cron jobs on website performance. Many said it made little difference and for a small number of cron jobs that’s true. But years into the life of a WordPress site I wonder how many are bloated with hundreds if not thousands of old cron jobs from deleted plugins. Instead of asking users to check their php memory limit I would suggest that developers first ask users to check the number of cron jobs in wp_options when problem-solving fatal memory errors. You may be surprised/shocked at what you find! 🙂

Related Posts:

  1. What is the curl error 52 “empty reply from server”?
  2. How to debug WordPress “Cron” wp_schedule_event
  3. Check if function called by cron job
  4. Wp_Schedule_Event every day at specific time
  5. Delete all scheduled events with a particular hook
  6. Running WordPress on the Command Line – Turn off Delayed Output?
  7. How is WP Cron Locking implemented?
  8. wp-cron.php – How are WP’s Cron transients removed?
  9. Better handling of WP-CRON server load abuse
  10. When does next Cron Job run (time from now)?
  11. wp_schedule_event not working?
  12. run a cron task without obstructing page load?
  13. Recurring scheduled task help
  14. How to make wp cron job not fire immediately?
  15. Cron jobs for deactivated plugins
  16. Cronjob not working as expected – issue with hook?
  17. Trigger a cron every 24h GMT -8
  18. Run function at specific time
  19. Is it safe to run wp-cron.php twice if the first instance takes too long?
  20. WordPress Cron Schedule the if and else statement
  21. Schedule event every second thursday of the month
  22. ”doing_wp_cron” in URL even if ALTERNATE CRON is not in wp-config
  23. execute function in wordpress plugin using crontab
  24. Sending out scheduled emails
  25. How do i schedule cron in wordpress for each second?
  26. How do I get a Function in my functions.php to execute with a cron job?
  27. Cronjob returns a lot of REMOTE_ADDR, SERVER_PORT, SERVER_NAME, etc errors
  28. Will WordPress use the newer schedule if it is updated using the filter ‘cron_schedules’?
  29. “Error establishing database connection” when trying to run script through crontab
  30. WP Cron job every 1st and 15th of the month
  31. Web Scraping with Cron
  32. Template Tag not available in real Cron Jobs
  33. WordPress Caching – Transients API or “update_user_meta ” Cronjob?
  34. Insert WordPress page via external (cron) script?
  35. WP Super Cache All Pages [closed]
  36. WP Cron is “half-failing” to insert posts
  37. Any insights into Transient API locking, cron and threading?
  38. Set a menu item to display during certain times
  39. WP CRON on shared hosting that does not allow loopback connections?
  40. Auto Publish On Cron
  41. WordPress Cron how to find out my event recurrence?
  42. Wp Maintenance mode and external cron job
  43. How to use a class within a cron job function
  44. Can a scheduler be set on submit of a form in wordpress?
  45. Cron and WP Super Cache in Preload Mode
  46. WordPress Cron Job in Bookly Plugin [closed]
  47. Which file do I run a cron job on to make Twitter News Feed update more often?
  48. Remind a user about their account if they have not used it for 6 months
  49. Manual Cron job occasionally outputting WP die message
  50. How refresh wp_schedule_event without restart a plugin
  51. Cron job script – loading wordpress system fails
  52. Is it possible to use `wp_schedule_event` with real cronjobs?
  53. How to use wp cron job to run a function
  54. What is the best practice to set and update Transient value of API data in every minute?
  55. Plugin has a cron job, but the function doesn’t actually run
  56. Are uploads directories created on a schedule?
  57. Create wp_cront events dynamically upon user submission
  58. Schedule an action callback
  59. wp_schedule_event didn’t work
  60. wp_schedule_event action not running
  61. is WGET correct for this cron job?
  62. Refresh page using Cron after any post is published
  63. pingbacks testing
  64. Best Way to Enter Maintenance Mode Programmatically
  65. Cron job to change CPT
  66. Is there a delay to include call function modification in a scheduled cron task?
  67. How to pass variable from other function?
  68. Cron task with scheduled timestamp in the past
  69. Use wp_remote_get() with a private or password protected page?
  70. Call a PHP file from Cronjob
  71. Add cron schedule to upload video on save_post
  72. unix cronjob for wordpress does not stop running
  73. I want to write something that restarts the httpd service when my apache server dies
  74. does wordpress auto update work without a cron job?
  75. WordPress can’t seem to handle tens of thousands of scheduled posts? Cron Breaks
  76. Running a cron job manually and immediately
  77. Cron job for let’s encrypt renewal
  78. Prevent duplicate cron jobs running
  79. how to create a cron job that runs on the first day of month [duplicate]
  80. escaping double quotes and percent signs (%) in cron
  81. What is the correct syntax to run cron every 4 hours? [duplicate]
  82. What does * * * * * (five asterisks) in a cron file mean? [duplicate]
  83. Creating a background process that doesn’t need HTTP
  84. Hourly WP schedule, do I need at least 1 visitor hourly?
  85. Auto Delete Users (auto_delete_users)
  86. wp_schedule_single_event function not working
  87. Will cron job run if page loaded is being served from cache?
  88. wp_schedule_event run in background or not?
  89. Cron job not working – Can’t see in the queue attached
  90. Problems with cron
  91. Manually running cron from the server
  92. Cron jobs when running multiple instances on the same DB
  93. WordPress cronjob get scheduled but function does not run
  94. Dynamic name of cron event
  95. Offloading cron jobs
  96. how to make a cronjob run, when user needs to be logged in
  97. WordPress Cron function is not working
  98. Adding custom cron_schedule prior to wp_schedule_event
  99. Cron event running more than once if triggered from WP Crontrol
  100. Running Cron every 2 hours [duplicate]

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)