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]