On 08/24/2011 02:51 PM, Pablo Fernandez wrote: > > Hi, > > > > Yes, you can see the following ticket: > > > https://ggus.eu/tech/ticket_show.php?ticket=72028 > > > In that ticket, they have used 512MB. > > > Very interesting ticket! Thanks for pointing it out. > > > > I am now checking our database, and there is plenty of jobs around. > One of the creams has 32k, and the other one around 70k. This last one > is taking several minutes to complete the simple count(*) query, where > the first one took 6 seconds. > > > So, I thought there must be a problem cleaning (purging) our database. > I am trying to find the cron job that does it, and I can't find it. Is > this a cream internal process (so, no external cron job needed) or is > this something we have to do by hand? > There is a cream internal process. For more details, see: http://grid.pd.infn.it/cream/field.php?n=Main.HowToPurgeJobsFromTheCREAMDB > I saw our config file (and the default) says 10 days for all jobs, and > 2 days for REGISTERED. Is this the right configuration? > That is the default configuration, so if you need you can customize it. > > > Maybe its worth increasing our cache also to 512 MB. > > > BR/Pablo > > >