Hi guys,
I'm just responding one more time because I want to mark this as solved
for me:
Several things did the trick:
* Upgrade Firebird to 2.5.7 (apparently there was a subquery bug in
2.5.4 which wasn't fixed in the debian package) - thanks to LiENUS
on IRC.
* blockdev -setfra
This is what the fb_lock_print output looks like.
Andreas
On 27.02.2017 00:25, Andreas Zeller zel...@lux-medien.com
[firebird-support] wrote:
>
>
> Hi Sean,
>
> that's what I am saying. It never really is 'under load'. It is just
> taking forever to select a clients data-page.
>
Hi Mark,
thanks for the info. Someone already told me that the first message is
moderated. It's the first time I joined a yahoo group for a project like
that. Most of the open source projects have mailman or some sourceforge
stuff setup and you can just post away :)
Andreas
On 27.02.2017
Hi Sean,
that's what I am saying. It never really is 'under load'. It is just
taking forever to select a clients data-page.
I would blame bad design and shrug it off, but this was way faster on
the ancient w2k server, so I have no idea where it gets stuck.
Andreas
On 26.02.2017 23:54, 'Leyne,
Sean,
thanks for the response. Answers below.
On 26.02.2017 23:52, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] wrote:
>
>
> Andreas,
>
> > - increase page size to 16kB (gbak -> and restore with new pagesize)
> > - increased buffers for firebird to use up to 4GB of ram (256kB)
client.
What are your suggesting?
Andreas
On 26.02.2017 21:31, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 26.02.2017 21:07, Andreas Zeller zel...@lux-medien.com [firebird-support]
> wrote:
>> I am still curious about how this might affect performance?
Hi Dimitry, hi Sean,
>Did you check obvious things: direct and reverse DNS resolution for server
> host on
> client host and both hosts on server host?
>
>
I didn't realize those were obvious things, but connections are being
made via the IP. So there's no name-resolution delay. I just
Hi Sean,
first off, thanks for the quick response. answers below.
On 26.02.2017 20:14, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] wrote:
>
>
> Andreas,
>
> > - increase page size to 16kB (gbak -> and restore with new pagesize)
> > - increased buffers for firebird to use up to
Hi everyone,
I'll try and provide as many details as possible, so this message is
going to be a little bit longer, but here goes:
I encountered a bit of trouble migrating a firebird server from an
ancient w2k SBS to a powerful debian-based DL380 server.
I'll share my story, so people facing