Tablestatistics & Tablesizes
Florian Schmitz <[email protected]>
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Organization | acardo technologies AG |
| Message-ID | <[email protected]> |
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/[email protected]