[CDash] reducing cdash database size

[Judicaël Bedouet]

Hi,

Having removed builds from the database does not mean that you recover
space on your hard disk.

You should now optimize your tables. See http://dev.mysql.com/doc/en/
optimize-table.html

With show table status (http://dev.mysql.com/doc/en/show-table-status.html),
you can see the size of the tables and the disk space that can be recovered
(called overhead under phpMyAdmin).

Regards,

J. Bedouet


Date: Mon, 16 Jan 2017 17:07:55 -0500
> From: "Sean McBride" <sean at rogue-research.com>
> To: "Zack Galbreath" <zack.galbreath at kitware.com>
> Cc: cdash <cdash at public.kitware.com>
> Subject: Re: [CDash] reducing cdash database size
> Message-ID: <20170116220755.255415709 at mail.rogue-research.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On Mon, 16 Jan 2017 15:52:55 -0500, Zack Galbreath said:
>
> >> can I hack something to allow that 100 MB allocation to proceed?
> >
> >To increase the amount of memory allowed for old build removal, add the
> >following line to the top of CDash/include/autoremove.php:
> >ini_set('memory_limit','1024M');
>
> That worked, thanks.  Now the sql command gives:
>
> +---------------------+
> | starttime           |
> +---------------------+
> | 2016-11-17 15:13:52 |
> +---------------------+
>
> which matches my 'AutoRemove Timeframe' of 60 days.
>
> Alas, 'du' still shows 43 GB in my mysql/data folder....
>
> Cheers,
>
> --
> ____________________________________________________________
> Sean McBride, B. Eng                 sean at rogue-research.com
> Rogue Research                        www.rogue-research.com
> Mac Software Developer              Montr?al, Qu?bec, Canada
>
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> CDash mailing list
> CDash at public.kitware.com
> http://public.kitware.com/mailman/listinfo/cdash
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://public.kitware.com/pipermail/cdash/attachments/20170118/7fe5d845/attachment-0001.htm>