Changes between Version 33 and Version 34 of Ticket #590


Ignore:
Timestamp:
09/09/13 20:26:56 (3 years ago)
Author:
jim
Comment:

OK so I'm still playing!

Added Elysia cron per last comment, and have set some less important things to happen every 2, 3, 6 or 24 hours depending on what it is.

Items changed from hourly:

  • Every 2h: filter_cron, messaging_cron, node_cron
  • 3h: system_cron
  • 6h: backup_migrate_cron, media_youtube_cron, spambot_cron, xmlsitemap_cron, xmlsitemap_node_cron, xmlsitemap_taxonomy_cron
  • Daily (at 5am): captcha_cron, logintoboggan_cron, revision_deletion_cron
  • Weekly (5am on Sunday): update_cron (already does this via settings, but this ensures it)

Note I used ​http://2bits.com/drupal-performance/improving-performance-drupals-cron-using-elysia-cron-module.html as a template/good practice. All can be altered by Developer users at ​https://www.transitionnetwork.org/admin/build/cron/settings

The next enhancement will be to stagger these items across the minutes, but this means making the site cron run every minute or two or 5... The Aegir control panel allows this, and now we've Elysia Cron there is no performance hit since each item is only executed per its schedule. This has extra advantages, like indexing new content every 1/2 instead to keep the search system fresher...

I'll wait to see how this change goes before scheduling a quick (10 minute) tweak to allow per minute cron resolution in Aegir. Soon hopefully though.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #590

    • Property Add Hours to Ticket changed from 1.0 to 0.5
    • Property Total Hours changed from 13.7 to 14.2

  • Ticket #590 – Description

    v33 v34  
    99'''L) Review slow query log, explain queries, tweak as necessary/flag poorly behaving modules.''' 2-4 hours, high reward, low risk... Keep looking at the slow query log and adjust Drupal or find patches as necessary. ALSO related [http://2bits.com/articles/reduce-your-servers-resource-usage-moving-mysql-temporary-directory-ram-disk.html Reduce your server's resource usage by moving MySQL temporary directory to tmpfs]... Have opened ticket for this: #591 for Chris. 
    1010 
    11 '''M) Take control of Cron, and maximise time pages are cached for.''' 1 hour, high reward, low risk -- Cron is wiping the page cache, so we need to install https://drupal.org/project/elysia_cron so we can clear the page less often, and run other things when we want and the site is quieter. See comment 33 for more background. 
     11'''M) Take control of Cron, and maximise time pages are cached for.''' .25h, high reward, low risk -- ~~Cron is wiping the page cache, so we need to install https://drupal.org/project/elysia_cron so we can clear the page less often, and run other things when we want and the site is quieter.~~ Now need per minute resolution set to get the best, see comment 33 and 34 for more... 
    1212 
    1313