RE: Tablestatistics & Tablesizes

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]