Huge Firebird 5 impact on disk io #8833

Activity

1. mrotteveel commented on Dec 22, 2025

   

   mrotteveel

   on Dec 22, 2025

   Member

   More actions

   That looks to me like a write to the header page each time a transaction is started. You have a 32KiB page size by the looks of it. This is entirely expected and normal if you (or a driver in auto-commit mode) starts a new transaction for each select, and executes those selects near continuously.
2. hvlad commented on Dec 22, 2025

   

   hvlad

   on Dec 22, 2025

   Member

   More actions

   And why do you think it is not correct, or problem, or ... what ?

   Note, you use biggest possible database page size, also, you disabled filesystem caching - no wonder it creates some load on IO.

   PS usage of read-only transactions when possible will lower header page writes.
3. mrotteveel commented on Dec 22, 2025

   

   mrotteveel

   on Dec 22, 2025

   Member

   More actions

   PS usage of read-only transactions when possible will lower header page writes.

   I thought that was no longer the case with ReadConsistency = 1
4. hvlad commented on Dec 22, 2025

   

   hvlad

   on Dec 22, 2025

   Member

   More actions

   PS usage of read-only transactions when possible will lower header page writes.

   I thought that was no longer the case with ReadConsistency = 1

   I speak about #5706 (CORE-5434)

   👍React with 👍1Reacted by Mark Rotteveel
5. mrotteveel commented on Dec 22, 2025

   

   mrotteveel

   on Dec 22, 2025

   Member

   More actions

   @hvlad Do you think this should be moved to discussions?
6. hvlad commented on Dec 22, 2025

   

   hvlad

   on Dec 22, 2025

   Member

   More actions

   @hvlad Do you think this should be moved to discussions?

   Yes, please. So far I see no bug or real issue here.
7. FirebirdSQL

   locked and limited conversation to collaborators on Dec 22, 2025
8. mrotteveel

   converted this issue into a discussion #8834 on Dec 22, 2025