14.11.2019 12:43, kragh.tho...@yahoo.com [firebird-support] wrote:
> Just to be sure, /tmp should be mounted with tmpfs, like in this archicle?
Yes and add some automatic swap management like here:
https://unix.stackexchange.com/questions/134258/dynamically-growing-swap-file-on-debian
--
13.11.2019 21:06, kragh.tho...@yahoo.com [firebird-support] wrote:
> Just to clarify, one could make a RAM drive with tmpfs, eg /ramdrive, and
> then specify
> this path in firebird.config under "TempDirectories"?
Not quite.
> If correctly understood, does this provide any benefits over
Hello,
For predictable load reads/fetches is very useful metric, but in case of
spikes like Thomas has - 96 connections to 1300, it will be far less useful.
Regards,
Alexey
On 13.11.2019 14:50, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 13.11.2019 12:41, Alexey Kovyazin
Hello,
Yes, better use default - pagecache in terms of Linux is different from
Page Buffers/Page cache of Firebird.
Regards,
Alexey
On 13.11.2019 15:10, kragh.tho...@yahoo.com [firebird-support] wrote:
Hey Alexey
Thanks for the answer, I only have one question left, do I need to
adjust
13.11.2019 12:41, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote:
> we also started with Page Buffers = 25% RAM and increased it step by step
> (and still
> continue to work with fine tuning).
Isn't it better to use cache hit ratio to make the decision about its growth?
--
Hello Thomas,
Ok, good to know that you are prepared for the migration! FB3 with
proper migration and config certainly will increase the overall performance.
In my presentation regarding Linux I spoke about specific case which is
under everyday control, and in our long way, we also started
13.11.2019 11:59, kragh.tho...@yahoo.com [firebird-support] wrote:
> Its not that I see high traffic to /tmp as a problem, I was just worried that
> it was
> becoming a bottleneck in our system.
In this case you can use for it tempfs backed up with auto-expanded swap
files.
--
WBR,
Hey Alexey Its not that I see high traffic to /tmp as a problem, I was just
worried that it was becoming a bottleneck in our system. Great to know that
HQbird has a way of tracking these qureys, I have already been looking into
HQbird especially because of prepared statements.
Regarding the
Hello Thomas,
My advice was only to fix the obvious mistake regarding the TempCacheLimit.
In general, I don't see a problem in high traffic to /tmp, and I don't
understand why do you think sorting queries produce the problem - and
even if they produce, the first attempt would be to identify