Re: Tablestatistics & Tablesizes
David Krcek <[email protected]>
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
Hi Flo,
did you add the temp size to the data size ?
LL&P
David
Am 08.01.2007 um 16:29 schrieb Florian Schmitz:
> 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]
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[email protected]