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

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

Hi Samuel,

> 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 
account), the database size should decrease.

If you want/need to keep more data online, you will need to move the MySQL 
directory to a disk partition that has more room.  Since I have never done a 
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 
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.


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

NOTE: All email exchanges with Unidata User Support are recorded in the Unidata inquiry tracking system and then made publicly available through the web. If you do not want to have your interactions made available in this way, you must let us know in each email you send to us.