Hi Andreas,
I think the main thing is
* blockdev -setfra 32768 - this has nothing to do with
firebird but speeds up reads in the RAID array quite a bit. Thanks
to wltjr on IRC.
and, probably, backup/restore.
In 2.5 the bad effect of autosweep is almost eliminated on the systems
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
Andreas,
this is the one thing I am getting when I am connecting to the database. I am
not the one working productively on the system, so I can't really tell wether
this has become faster or is still the same.
LOCK_HEADER BLOCK
Version: 145, Active owner: 0, Length: 7048576, Used:
Hi Sean,
this is the one thing I am getting when I am connecting to the database.
I am not the one working productively on the system, so I can't really
tell wether this has become faster or is still the same.
LOCK_HEADER BLOCK
Version: 145, Active owner: 0, Length: 7048576, Used:
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
On 26-2-2017 17:46, andreasmzel...@yahoo.de [firebird-support] wrote:
> I originally tried to post to this like I would to a normal mailing list.
> I've never seen an open source project that required me to have a yahoo
> account ;) I have a firebird-related problem however.
You don't need an
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)
> Sean: fb_lock_print seems to have some trouble:
>
> Unable to access lock table.
> operating system directive shmem_data->sh_mem_length_mapped is 0
> failed -Success
>
> This is what I am getting from fb_lock_print -d filename.db0
You need to specific the full/local path to the database and
Andreas,
> - increase page size to 16kB (gbak -> and restore with new pagesize)
> - increased buffers for firebird to use up to 4GB of ram (256kB) via gfix
With Classic server you *need* to reduce the number of cached pages -- I would
recommend a value < 500 pages
people keep telling me
Hi,
Use optimized configuration file:
http://ib-aid.com/en/optimized-firebird-configuration/
Please note that if you have number of buffers set in database header,
it overrides firebird.conf value.
Check that RAID has BBU, read-write cache is enabled and write is set to
write-back.
After
of course. The server is horribly bored. 16 CPUs, 12 GB RAM and still
the system takes forever during selects with just one client connected
to it.
CPU usage for the spawned process is less than 3%, memory usage below 1%.
I/O wasn't even on my radar. It's RAID0, dedicated controller, XFS,
single
26.02.2017 21:07, Andreas Zeller zel...@lux-medien.com [firebird-support] wrote:
> I am still curious about how this might affect performance?
Did you monitor resource usage? CPU, RAM, IO?
--
WBR, SD.
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
26.02.2017 12:55, Andreas Zeller zel...@lux-medien.com [firebird-support] wrote:
> 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 the same problems can scratch
> things off
Andreas,
> - increase page size to 16kB (gbak -> and restore with new pagesize)
> - increased buffers for firebird to use up to 4GB of ram (256kB) via gfix
With Classic server you *need* to reduce the number of cached pages -- I would
recommend a value < 500 pages
> - switchted to async
Hi everyone, I originally tried to post to this like I would to a normal
mailing list. I've never seen an open source project that required me to have a
yahoo account ;) I have a firebird-related problem however.
I'll try and provide as many details as possible, so this message is
going to be
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
19 matches
Mail list logo
