 | | | Tablestatistics & Tablesizes | Tablestatistics & Tablesizes 2007-01-08 - By Florian Schmitz
Back
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?
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/maxdb?unsub=mysql@(protected)
|
|
|