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
--
Hey Dimitry Thanks for the answer. Just to be sure, /tmp should be mounted with
tmpfs, like in this archicle?
https://linoxide.com/file-system/use-tmpfs-rhel-centos-7-0/
https://linoxide.com/file-system/use-tmpfs-rhel-centos-7-0/
+1
> Hey Alexey
> First of all, thanks for all the help. Second, have you or anyone else
> working professional with Firebird thought about writing a book about
> Firebird optimisation - I would for sure buy a copy.
>
>
>
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
Hey Dimitry Just to clarify, one could make a RAM drive with tmpfs, eg
/ramdrive, and then specify this path in firebird.config under
"TempDirectories"?
If correctly understood, does this provide any benefits over just allocation
more memory for TempCacheLimit, under Firebird 3?
Thomas
Hey Alexey First of all, thanks for all the help. Second, have you or anyone
else working professional with Firebird thought about writing a book about
Firebird optimisation - I would for sure buy a copy.
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
Hey Alexey Thanks for the answer, I only have one question left, do I need to
adjust linux page cache(vm.pagecache) according to amount of RAM allocated for
DefaultDBCachePages, so that memory is not over "subscribed"? Eg. if
DefaultDBCachePages is increased should i then decrease
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
Hey Alexey Thanks for the advise, I changed TempCacheLimit to 21, last
night and it looks like it had a positive effect on the disk queue size on sda.
I have read a lot about Firebird tuning however I have never come across that
limit on fb 2.5
https://pasteboard.co/IGsU650A.png
15 matches
Mail list logo