[firebird-support] Firebird upgrade advise

[SP Ooi sp.ooi....@gmail.com [firebird-support]]

Hi,

We are running 32bit Firebird 1.5.6.5026-0 CS on RHEL OS.

May I know what our upgrade path should be to bring our firebird databases
to the latest version?

How will the performance be affected?

What are the advantages?

Can someone please advise?

SP
Sent from mobile device

Re: [firebird-support] Page cache size in Firebird 3.0.4

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

> I am running SS FB 3.0.4 x64 in Windows 10 x64 with 16GB RAM.
> 
> Database properties
> 
> ODS Version 12
> Page size 16384
> Pages 437728
> Size on disk 6.68GB
> Page buffers 10240
> Read only false
> 
> Settings
> 
> Dialect 3
> Default character set NONE
> Sweep interval 2
> Forced writes
> 
> Database alias in databases.conf file
> =
> my_dba = C:\Dba\my_dba.fdb
> {
>      FileSystemCacheThreshold = 2M
>      LockMemSize = 16M
>      LockHashSlots = 30011
>      TempCacheLimit = 2048M
>      TempBlockSize = 2M
>      DefaultDbCachePages = 65536
> }
> 
> I ran a query with flamerobin, this is the statistic result :
> =
> 46220441 fetches, 17965 marks, 172471 reads, 82 writes.
> 8847 inserts, 0 updates, 0 deletes, 15730299 index, 8847 seq.
> Delta memory: 4206064 bytes.
> G_TMP: 8847 inserts.
> Total execution time: 52.434s
> Script execution finished.
> 
> On Windows Task Manager, Firebird Server took 236MB RAM, max.
> 
> If not mistaken, Page Cache Size should be
> Page Size x DefaultDbCachePages = 16384 x 65536 = ~ 1GB
> 
> Why Firebird server only took 236 MB RAM ? Is this normal or something 
> missed here ?

DefaultDbCachePages (65536 in your case) is only used if Page buffers at 
database level is set to 0. Yours is set to 10240.

Hope this helps.

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

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

Re: [firebird-support] Re: Drop table safe when other users are active?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Den 2019-05-26 kl. 13:28, skrev hv...@users.sourceforge.net 

[firebird-support]:

>

> > A few years ago we suffered Firebird corruption and got it fixed with

> > the help of IB Surgeon. I was told at the time that dropping tables

> > while other users were connected was the probable cause, and that this

> > was a bug in FIrebird that had been around for a long time. I think 

> this

> > would be for Firebird 2.5.

>

> What bug ? Is it registered at the tracker ? Do you have a test case ?

>

I've submitted a bug report now:

http://tracker.firebirdsql.org/browse/CORE-6073



Regards,

Kjell





[Non-text portions of this message have been removed]