Posted by Made in Orkney on February 8, 2013 at 1:21pm
Experienced in PHP but new to Drupal so please be gentle with me.
Very small Drupal site, hosted on my own beefy Linux server, and everything seems to work swimmingly. That is ... until I get lengthy (15-20 seconds) and seemingly random delays on clicking a link which would normally respond almost instantly.
I don't think it is network-related; I have 20Mbit service from Zen and this is solid as a rock.
The watchdog table has some entries for "Attempting to re-run cron while it is already running" ... dozens rather than thousands though.
Any pointers greatly appreciated,
Puzzled from Huntly
Comments
Cron Semaphore
You may have either a massive Cron task, or cron_semaphore needs resetting.
To reset cron_semaphore, go to your MySQL database (using PHP My Admin etc) and look in the variable table and delete the following rows:
If that's too much to deal with, there's a module at http://drupal.org/project/semiclean
If that doesn't solve it, then you may need to look at your modules' loading on the cron tasking. Installing http://drupal.org/project/elysia_cron can help you analyse this and customise the frequency of certain big tasks. Looking at the site search settings (ie, number of items indexed per search) is a good place to start.
And don't forget Drupal usually needs lots of resource to run well: set 'max_allowed_packet' in MySQL to something reasonable (> 64M) and give PHP a decent 'memory_limit' (I've found 256M is usually enough). The Drupal Community handbook (http://drupal.org/node/2601) is worth checking out (although can be a bit dated in places).
There's a whole business to be made from performance optimisation in Drupal. Look through Drupal Groups (such as http://groups.drupal.org/high-performance); some interesting articles at http://2bits.com/contents/articles too.
I have dealt with the
I have dealt with the cron_last entry (you were right to word it as you did) :lol
I'll check the other stuff too & hopefully that'll sort it
Many thanks for taking the time
I have dealt with the
duplicate post, sorry
Try looking here as well:
Try looking here as well: http://drupal.org/node/553430
Some other helpful hints on Solving cron issues.
cheers!