[firebird-support] Re: Problem occuers while trying to generate trace file

2015-07-08 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : > > I would like to trace data base activity in fire bird using Audit/Trace > Services. I run this command in my command prompt: > > C:\Program Files\Firebird\Firebird_2_5\bin>fbtracemgr -se > localhost/3050:service_mgr -user SYSDBA -passwo

Re: [firebird-support] Re: Problem occuers while trying to generate trace file

2015-07-08 Thread Babak Bastan babak...@gmail.com [firebird-support]
Thank you Vlad, it works now On Wed, Jul 8, 2015 at 11:36 AM, hv...@users.sourceforge.net [firebird-support] wrote: > > > ---In firebird-support@yahoogroups.com, wrote : > > > > I would like to trace data base activity in fire bird using Audit/Trace > Services. I run this command in my command

[firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
Hi, Just for my cursiosity and for a better understanding of Firebird: what can be a possible reason for a gbaked and restored (to a different file) database being _larger_ than the original one? I've got a db of size 104521728 bytes. I do gbak -B -T database.fdb database.gbk, then gbak -C data

RE: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Take a look here: http://www.firebirdfaq.org/faq361/ I'd add that restore also has a -use_all_space option. If you don't specify this, then pages are filled to approximately 80% (80% is preferable over 100% unless it is a read-only database). See http://www.firebirdsql.org/manual/gbak-cmdline.h

RE: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Wed, 8 Jul 2015 12:14:13 +, "Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]" wrote: > Take a look here: http://www.firebirdfaq.org/faq361/ > > I'd add that restore also has a -use_all_space option. If you don't > specify this, then pages are filled to approx

[firebird-support] Re: Gbaked and restored database larger than the original?

2015-07-08 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
08.07.2015 15:18, Mark Rotteveel wrote: > Another reason could be restoring with a different page size than the > original database. Or some tables were altered to a longer record format after filling them with data. The original database contains records in the old (shorter) format while the r

Re: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 2015-07-08 o 14:14, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote: > Take a look here: http://www.firebirdfaq.org/faq361/ Yes, I've come across this on another occasion, but it doesn't seem to apply to my case (I didn't switch to a different version of F

Re: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
W dniu 2015-07-08 o 14:18, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Another reason could be restoring with a different page size than the > original database. Both databases have 8k pages. Tomasz -- __--==--__ __--== Tomasz Tyrakowski=

Re: [firebird-support] Re: Gbaked and restored database larger than the original?

2015-07-08 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
W dniu 2015-07-08 o 14:50, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > 08.07.2015 15:18, Mark Rotteveel wrote: > >> Another reason could be restoring with a different page size than the >> original database. > > Or some tables were altered to a longer record format afte

Re: AW: [firebird-support] Changing Columns

2015-07-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> On Jul 7, 2015, at 2:25 AM, 'checkmail' check_m...@satron.de > [firebird-support] wrote: > > .. or is there an option to export all data from the database without > database itself, then I can change the ddl, create a clean database and > import the data again? If I do it manually, I must s

Re: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> On Jul 8, 2015, at 8:14 AM, Svein Erling Tysvær > svein.erling.tysv...@kreftregisteret.no [firebird-support] > wrote: > > Take a look here: http://www.firebirdfaq.org/faq361/ > > I'd add that restore also has a -use_all_space option. If you don't specify > this, then pages are filled to ap

[firebird-support] FB_INET_SERVER.EXE using all the memory

2015-07-08 Thread mauricio.m...@yahoo.com [firebird-support]
Hello! I have two databases in my Firebird 2.5.3 The first is of 7.5GB and second is of 2.0GB My server has 4GB of Memory, and sometimes the service FB_INET_SERVER.EXE starts eating my memory from 1.5GB to 2.5GB-3GB of memory and my system slows down.. Same concurrent users, what