Florian Schmitz wrote:
>
> Hi List,
>
> i try to estimate the space-comsuption of our tables via
> tablestatistics.
> when summing up the pages-count ('Used pages', 'Index
> pages') of all tables and break it down to
> human readable values (e.g. dividing it by 8) i just end with
> a sum of gigs which is just half the
> used data area.
> so here's my question : what '%pages%'-fields summed up lead
> to the real space-consumption? do
> leaf-pages count to space-consumption to?
'Used pages' gives the whole number of pages used by this table.
'Index pages' + 'Leaf pages' should result in the same value as 'Used
pages'.
--> sum ( 'used pages' ) * 8192 is the number of bytes used by tables.
If you are using LONG-columns, the value of 'Long column pages' has to
be taken
into account, too.
Does this help?
Elke
SAP Labs Berlin
>
> if only used and index-pages lead to the real
> space-consumption : where are the dozens of gigs
> beeing wasted? :-)
>
> Thanks,
>
> Flo
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
