[SAC] Re: [OSGeo] #89: Improve caching of website

OSGeo trac_osgeo at osgeo.org
Mon Mar 26 11:31:43 EDT 2007


#89: Improve caching of website
--------------------------+-------------------------------------------------
  Reporter:  tmitchell    |       Owner:  sac at lists.osgeo.org     
      Type:  enhancement  |      Status:  new                     
  Priority:  minor        |   Component:  SAC                     
Resolution:               |    Keywords:  drupal cache performance
--------------------------+-------------------------------------------------
Comment (by tmitchell):

 Other comments received include:
  * Call the cron.php script regularly - this clears up some stuff, and
 also rebuilds search result database
  * Include some cleanup queries in the db, including some optimisation
 queries:
 {{{
  DELETE FROM sessions where uid=0;
  OPTIMIZE TABLE sessions;
  OPTIMIZE TABLE cache;
  OPTIMIZE TABLE watchdog;
 }}}

 Can someone please '''set up a cron job''' that calls
 http://oursite.com/cron.php and also that runs above script against db?

 ----

-- 
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/89#comment:1>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.


More information about the Sac mailing list