[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[McIDAS #XRR-599672]: Configuring scouring of McIDAS data



Hi Samuel,

re:
> I've noticed our /var/lib/mysql/mcrtgrib directory is growing pretty big 
> (1.8G)
> We only have a 4G /var partition, is there a way to keep this data in check?

The size of the MySQL database used for the McIDAS GRIB ADDE server is governed
by how many grids one keeps in the database.  If you change your GRIB scouring
to keep less numbers of days on disk (via an 'xcdscour' crontab entry in the 
'ldm'
account), the database size should decrease.

If you want/need to keep more data online, you will need to move the MySQL 
mcrtgrib
directory to a disk partition that has more room.  Since I have never done a 
setup
like this, I can't guarantee that the following would work:

<as 'ldm'>
ldmadmin stop     <- stop the LDM

<as 'root'>
-- ** example ** move all files under /var/lib/mysql/mcrtgrib to a /data/mysql
-- make a symbolic link from /data/mysql to /var/lib/mysql
-- make sure that read/write permissions on all files are maintained

<as 'ldm'>
ldmadmin start

Hmm... now that I say this I would bet that it has serious problems.  For 
instance,
if you deleted the database, the symbolic link might be deleted.

In any case, the key is having the MySQL database on a partition that is large
enough to hold it.

Cheers,

Tom
****************************************************************************
Unidata User Support                                    UCAR Unidata Program
(303) 497-8642                                                 P.O. Box 3000
address@hidden                                   Boulder, CO 80307
----------------------------------------------------------------------------
Unidata HomePage                       http://www.unidata.ucar.edu
****************************************************************************


Ticket Details
===================
Ticket ID: XRR-599672
Department: Support McIDAS
Priority: Normal
Status: Closed