Re: [firebird-support] Table Size
Ed, FB TraceManager parses gstat output and give you table/index size (MB), percentage of total database size etc. but actually does not have charting in that area. Check out screens here: http://www.upscene.com/fb_tracemanager/media * Table Stats Monitoring, and * Index Stats Monitoring -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > I have a number of growing databases on my server and would like to > occasionally see how much space each table is taking in the > database--there may be some log files that could be cleaned up now and > then. Many of my tables include blob fields, so this becomes different > than just doing record count times the amount of data in a record. > > Does anyone have any tools that they can recommend that could help me > easily manage this? > > much appreciated, > > Ed Dressel > > >
Re: [firebird-support] Table Size
Hi Ed, There is IBAanalyst tool (now it is a part of HQbird), it shows sizes of tables and associated indices, see column Size http://ib-aid.com/images/iba_tables.gif Regards, Alexey Kovyazin IBSurgeon HQbird www.ib-aid.com I have a number of growing databases on my server and would like to occasionally see how much space each table is taking in the database--there may be some log files that could be cleaned up now and then. Many of my tables include blob fields, so this becomes different than just doing record count times the amount of data in a record. Does anyone have any tools that they can recommend that could help me easily manage this? much appreciated, Ed Dressel
Re: [firebird-support] Table Size
11.05.2017 1:56, dres...@tbinc.com [firebird-support] wrote: > The results are pretty raw data--something like a pie chart would be nice. IIRC, IBSurgeon have a graphical tool for that. Look at www.ibsurgeon.com. -- WBR, SD. ++ 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] Table Size
Thank you. Running 15. The results are pretty raw data--something like a pie chart would be nice. Any way of getting the API calls to know tables and their sizes? I don't mind creating something like this.
Re: [firebird-support] Table Size
09.05.2017 21:59, dres...@tbinc.com [firebird-support] wrote: > Does anyone have any tools that they can recommend that could help me easily > manage this? gstat -- WBR, SD. ++ 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/