[GE users] arco database

sergio diaz sdiaz at cesga.es
Thu Nov 27 18:21:29 GMT 2008


    [ The following text is in the "UTF-8" character set. ]
    [ Your display is set for the "ISO-8859-10" character set.  ]
    [ Some characters may be displayed incorrectly. ]

Hi Jana,

thank very much. I will take a look of this rules.

Regards,
Sergio

jana escribió:
> Hi Sergio,
>
> Yes it is most likely normal. It depends on how many report_variables 
> have you set to be reported (see report_variables parameter of the 
> host_conf(5) man page). You can easily configure the dbwriter deletion 
> rules, so the outdated data is deleted every so often.  By default most 
> of the deletion rules are set to 2 years, by decreasing this value you 
> can control  the size of your database. You can only keep the derived 
> values and delete the raw values. You can also specify a subscope and 
> thus differentiate which vakues from one table to keep how long.
>
> See:
> http://wikis.sun.com/display/GridEngine/Derived+Values+and+Deletion+Rules#DerivedValuesandDeletionRules-DeletingOutdatedRecords
>
> Regards,
>
> Jana
>
>
> sergio diaz wrote:
>   
>> Hi All,
>>
>> In August installed ARCo in a cluster. In only 4 month the database have 
>> grown about 7GB. Only the table sge_host_values has 74 million of 
>> records and has a size of 6GB. Is it normal? Can I set any variable to 
>> avoid that the dbwrite write each 9 seconds in this table? How the 
>> accounting is affected if I change the this value?
>>
>>
>> Thanks,
>> Regards
>>
>>
>>
>>     
>
> ------------------------------------------------------
> http://gridengine.sunsource.net/ds/viewMessage.do?dsForumId=38&dsMessageId=90123
>
> To unsubscribe from this discussion, e-mail: [users-unsubscribe at gridengine.sunsource.net].
>
>   

-- 
Sergio Díaz Montes
Centro de Supercomputacion de Galicia
Avda. de Vigo. s/n (Campus Sur) 15706 Santiago de Compostela (Spain)
Tel: +34 981 56 98 10 ; Fax: +34 981 59 46 16
email: sdiaz at cesga.es ; http://www.cesga.es/
------------------------------------------------

------------------------------------------------------
http://gridengine.sunsource.net/ds/viewMessage.do?dsForumId=38&dsMessageId=90126

To unsubscribe from this discussion, e-mail: [users-unsubscribe at gridengine.sunsource.net].



More information about the gridengine-users mailing list