[firebird-support] Re: How much percentage of a database space is a table contents taking.

[hv...@users.sourceforge.net [firebird-support]]

> ---In firebird-support@yahoogroups.com,  wrote :
 
> > Monday, November 30, 2015, 7:40:50 PM, Thomas Steinmaurer wrote:
 > > That information is also available on the database header page,
 > > which can be extracted by gstat -h

> Unfortunately, that information is absent from gstat -h, 
  Because on the header page no such information as "number of allocated pages".

Why not calculate it as and file_size / page_size ?

Regards,
Vlad

  

Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.

[Thomas Steinmaurer t...@iblogmanager.com [firebird-support]]

> Monday, November 30, 2015, 7:40:50 PM, Thomas Steinmaurer wrote:
>
>> That information is also available on the database header page,
>> which can be extracted by gstat -h
>
> Unfortunately, that information is absent from gstat -h, hence my
> advice to use isql SHOW DATABASE.  I can't think why it is missing -
> even in Fb 3 where gstat -h output has actually been updated to
> display the new header info in ODS 12 databases.

Hmm, I really thought that I have seen this information on the header 
page, but I'm afraid I mixed that up with something else. I stand corrected.


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Monday, November 30, 2015, 7:40:50 PM, Thomas Steinmaurer wrote:

> That information is also available on the database header page,
> which can be extracted by gstat -h

Unfortunately, that information is absent from gstat -h, hence my
advice to use isql SHOW DATABASE.  I can't think why it is missing -
even in Fb 3 where gstat -h output has actually been updated to
display the new header info in ODS 12 databases.

   not quite
> So, basically, with gstat you get ^ everything you need:

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Programs64\Firebird_2_5\bin>gstat -h xxyyzz

Database "h:\databases\xxyyzz.fdb"
Database header page information:
Flags   0
Checksum12345
Generation  1428
Page size   8192
ODS version 11.2
Oldest transaction  1093
Oldest active   1094
Oldest snapshot 1094
Next transaction1107
Bumped transaction  1
Sequence number 0
Next attachment ID  128
Implementation ID   26
Shadow count0
Page buffers4092
Next header page0
Database dialect3
Creation date   Oct 3, 2015 20:35:11
Attributes  force write

Variable header data:
Sweep interval: 2
*END*

Helen

[firebird-support] Re: How much percentage of a database space is a table contents taking.

[rgilland1...@gmail.com [firebird-support]]

Thanks Helen, 

 I finally taught myself how to use isql.exe in order to access this 
information.
 What a strange tool.
 

 Then I found that both IBOConsole.exe and Upscene's Database Workbench show 
this information in Database Properties. And it is called "Allocated DB Pages"
 

 Kind Regards,
 

 Robert.

Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.

['Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]]

rgilland1...@gmail.com [firebird-support] schrieb am 30.11.2015 05:10:

> Thanks Helen, 
> 
> I finally taught myself how to use isql.exe in order to access this
> information.
> What a strange tool.
> 
> 
> Then I found that both IBOConsole.exe and Upscene's Database Workbench show
> this information in Database Properties. And it is called "Allocated DB Pages"

That information is also available on the database header page, which can be 
extracted by gstat -h

So, basically, with gstat you get everything you need:

* DB total allocated pages
* Allocated pages per table
* Allocated pages per index (might be important contributors size-wise)


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.