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

["Unidata McIDAS Support" <support-mcidas@xxxxxxxxxxxxxxxx>]

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
support@xxxxxxxxxxxxxxxx                                   Boulder, CO 80307
----------------------------------------------------------------------------
Unidata HomePage                       http://www.unidata.ucar.edu
****************************************************************************


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