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]