[clug] table/tablespace growth prediction tools

[Leigh Purdie]

Hi Boris,

Do you have any particular DB in mind, and are you particularly interested
in row counts, or disk space availability?

The reason I ask, is that some databases (eg: mysql) utilise a process
whereby the space allocated to deleted rows (or more to the point, deleted
rows that use varchar, blob or text fields) is not actually returned to the
system unless an 'OPTIMIZE TABLE' command is used.

As such, depending on your usage profile, you may see gradually increasing
'tidal surges' of data, that take up disk space, and never seem to release
it back again - though your actual row count does jump up and down as
expected.

I suspect something like a 'simple moving average' algorithm might be
appropriate for prediction (again, depending on the complexity of your usage
profile) - the algorithm is used a lot for share market stuff, so there
should be plenty of examples out there.

Regards,

Leigh.

On 1/19/06, Rousak, Boris <Boris.Rousak at industry.gov.au> wrote:
>
> Greets to all,
>
> Has anyone heard of/can recommend any OSS tools which can be used to
> monitor but more importantly to predict the expected growth of tables
> and tablespaces in a database. The monitoring I can do with shell/sql
> script but the prediction part is a bit trickier.
>
> So, any hints, tips, words of wisdom would all be greatly appreciated.
>
> Cheers,
> Boris
>
> *************************************************************************
> The information contained in this e-mail, and any attachments to it,
> is intended for the use of the addressee and is confidential.  If you
> are not the intended recipient you must not use, disclose, read,
> forward, copy or retain any of the information.  If you received this
> e-mail in error, please delete it and notify the sender by return
> e-mail or telephone.
>
> The Commonwealth does not warrant that any attachments are free
> from viruses or any other defects.  You assume all liability for any
> loss, damage or other consequences which may arise from opening
> or using the attachments.
> *************************************************************************
>
>
> --
> linux mailing list
> linux at lists.samba.org
> https://lists.samba.org/mailman/listinfo/linux
>