| Subject | Re: [firebird-support] Re: High write access on disk |
|---|---|
| Author | Alexey Kovyazin |
| Post date | 2019-11-13T11:41:46Z |
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 with Page Buffers = 25% RAM and increased it step by step (and still continue to work with fine tuning).
Also, there we have 320Gb and smooth predictable increase of connections during the day, and you have much more intensive spikes, so, better be more conservative - if you will see no problems with 25% of RAM, increase to 40-50-70, week by week.
Regards,
Alexey
On 13.11.2019 13:59, kragh.thomas@... [firebird-support] wrote:
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 with Page Buffers = 25% RAM and increased it step by step (and still continue to work with fine tuning).
Also, there we have 320Gb and smooth predictable increase of connections during the day, and you have much more intensive spikes, so, better be more conservative - if you will see no problems with 25% of RAM, increase to 40-50-70, week by week.
Regards,
Alexey
On 13.11.2019 13:59, kragh.thomas@... [firebird-support] wrote:
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 upgrade to Fb 3 SuperServer, a complete restore of production database to Fb 3 have already been made in our dev envioment last week without problems, and for almost a year dev, test and preprod have been running Fb 3, so i am quite comfortable in that regard. We have also uses FB TraceManager to weed out bad queries, and procedures and triggers recompile without errors.My only concern is that I somehow configures Fb 3 in a way that results in worse performance that our current 2.5 installation.
The server is a dedicated Firebird server with a single database, does this change your recommendation to allocate 25% RAM for DefaultDBCachePages? My initial estimate was based on your presentation at this years Firebird conference(20_tuninglinux.pdf page 28)
Thomas Kragh