How to optimize the performance of Firebierd 1.5.4?

Good time of day!
There is a storage program running on FB 1.5.4
When the base 68 gig, the improvements were at increasing memory from 8 to 16 gig
base turns on SAS 15k

It is planned to increase the base until 150гиг. What to do with the disk subsystem? SSD? hybrid RAID? RAM Disk?
Memory up to terabytes, it is possible to catch up - this is just a question of money
Percent you can play with a smaller number of cores and higher frequency, although in fact also in the money rests
But SSD is too expensive to change in a year or two worth of not less than 20tr
June 8th 19 at 16:48
2 answers
June 8th 19 at 16:50
Find bottleneck and to improve it. In your case, they will be io, memory, percent, who knows? What is your load profile, what data, what requests?
There are no universal rules of optimization.

Maybe it can be somehow part of the data clean up, or move somewhere in the "archive".

PS ramdisk and the database is not compatible things. If the bottleneck is io, the SSD with such volumes not roads.
I don't know where to look to understand what this or that setting borders on critical.
see in htop-e that memory, more than 2/3 of that percent is not loaded (8 cores) not more than 20-30% in working days.
Yes, separation bases on the archival part and instant release of course, but this entails elaborate queries - programmers do not.
and the incomprehensible future - added +-150 connections. now about 120.
I read that FB 1.5 does not understand more than 8 cores
Here I can only imagine what will happen when the load increases in two times... - Zackary commented on June 8th 19 at 16:53
htop is the tool is not entirely appropriate. They can see what is happening right now, of course, to make any conclusions, but usually worth watching what's going on during the day, not just now.
In order to see what is happening with io, is, for example iotop.
But in General, need some type of monitoring of zabbix for good. So you can see the complex and the history of various parameters.
Firebird is already where fresh in 1.5, making it difficult to migrate, especially if there are developers?
If memory is all occupied, perhaps something needs to change in the settings of the firebird?

Well, about the ssd, and two year written above is not correct - you have no such volume entry. - Guiseppe commented on June 8th 19 at 16:56
June 8th 19 at 16:52
1. to configure and start the garbage collector
2. to make a backup/ReSTOR
3. optimize queries

although I would start with APA on any supported version of
alas, the program is written in a way that conflicts with variables to another version ((( - Zackary commented on June 8th 19 at 16:55
no source and/or impossible to correct? - Guiseppe commented on June 8th 19 at 16:58
no source prog... - Zackary commented on June 8th 19 at 17:01
pechalka. maybe this is the answer. to change prog records) - maritza_Marquardt commented on June 8th 19 at 17:04

Find more questions by tags Firebird