ãã®èšäºã§ã¯ãæ°ãã Linux ãã£ã¹ããªãã¥ãŒã·ã§ã³ã« Firebird DBMS ããŒãžã§ã³ 3.0 ãæé©ã«ã€ã³ã¹ããŒã«ããããã«å¿ èŠãªæå°éã®ã¢ã¯ã·ã§ã³ã«ã€ããŠèª¬æããŸãã äŸãšããŠãCentOS 8 ãš Ubuntu 19 ãéžæãããŠããŸãã
Firebird ãã£ã¹ããªãã¥ãŒã·ã§ã³ãã¿ãŒã²ãã ã·ã¹ãã ã«ãé
ä¿¡ãããã«ã¯ããã®ã¬ã€ãã§ã¯ããããžã§ã¯ãã®å
¬åŒ Web ãµã€ãããã®ãªã³ã¯ã䜿çšã㊠tar.gz ã¢ãŒã«ã€ããããŠã³ããŒããããªãã·ã§ã³ãéžæããŸã (
æããã£ãã¡ãªäººã¯ãããã«æŠéã«åå ããŠãã ããã
ã¯ã€ãã¯ã€ã³ã¹ããŒã«
ãã¡ã€ã«ã®ç·šé /etc/sysctl.conf
次ã®è¡ãè¿œå ããŸãã
vm.max_map_count = 256000
ãã¡ã€ã«ãä¿åããèšå®ãé©çšããŸãã
sudo sysctl -p /etc/sysctl.conf
CentOS 8 ãš Ubuntu 19 ã§ã¯è©³çŽ°ãªæé ãç°ãªããŸããã ССЫÐÐÐ
О ÐÐТÐÐÐÐ
ãã£ã¹ããªãã¥ãŒã·ã§ã³ãããŠã³ããŒãããããã®å
¬åŒ Firebird ãããžã§ã¯ã Web ãµã€ãããã®ãªã³ã¯ãšãããŠã³ããŒã ããã»ã¹äžã«ãã£ã¹ããªãã¥ãŒã·ã§ã³ã解åããããã£ã¬ã¯ããªã瀺ããŸãã
çŸåš (2020 幎 3.0.5 æ) ã®çŸåšã®ãªãªãŒã¹ã¯ Firebird XNUMX (
CentOS 8
sudo yum -y install epel-release
sudo yum -y makecache
sudo yum -y install libicu libtommath tar
ln -s libncurses.so.5
/usr/lib64/libncurses.so.5
ln -s libtommath.so.1
/usr/lib64/libtommath.so.0
curl -L ССЫÐÐÐ|tar -zxC /tmp
Ubuntuã®19
sudo apt-get -y install libncurses5 libtommath1
ln -s libtommath.so.1
/usr/lib/x86_64-linux-gnu/libtommath.so.0
wget -O- ССЫÐÐÐ|tar -zxC /tmp
Firebird DBMS ã®å®éã®ã€ã³ã¹ããŒã«:
cd /tmp/ÐÐТÐÐÐÐ
sudo ./install.sh
ãããã®ã¢ã¯ã·ã§ã³ãäœãè¡ãã®ããããã«ç解ãããå Žåã¯ãèªã¿ç¶ããŠãã ããã
ã¡ã€ã³
çãåæ
OS ããã§ã«æå°ããŒãžã§ã³ã§ã€ã³ã¹ããŒã«ãããŠããããããªã㯠ãªããžããªãŸãã¯ãã®ããŒã«ã« ã³ããŒãžã®ã¢ã¯ã»ã¹ãæ§æãããŠããããšãåæãšãªã£ãŠããŸãã
èªè 㯠Linux ãš Firebird DBMS ã®åºæ¬çãªç¥èãæã£ãŠããããšãåæãšããŠããŸãã
èšç»
DBMS ãµãŒããŒã§ã¯ãäžæãã¡ã€ã«ã«å¥ã®ã»ã¯ã·ã§ã³ãå²ãåœãŠãããšããå§ãããŸã (/tmp
)ãããŒã¿ããŒã¹ ãã¡ã€ã«ãããŒã«ã« ããã¯ã¢ããã
äžæçãªãã®ã«ã¯ããã㯠ãã¡ã€ã«ããœãŒã ãã¡ã€ã«ãã°ããŒãã«äžæããŒãã« (GTT) ã®ãå®äœåããã¡ã€ã«ãããã³ç£èŠããŒãã«ãå«ãŸããŸãã ãœãŒãçšã®ãã¡ã€ã«ãšã°ããŒãã«äžæããŒãã«ã¯æ¬¡ã®å Žæã«ãããŸãã /tmp
ãmon$-table ãã¡ã€ã«ãš lock-file â 㧠/tmp/firebird
.
ä»åããã¡ã€ã«ããåé€ããããŸãïŒunlink
ïŒäœæçŽåŸãªã®ã§ããã£ã¬ã¯ããªãªã¹ãã«ã¯ã衚瀺ãã§ããŸãããããã»ã¹ãã³ãã«ã®ãªã¹ãïŒã deleted
):
sudo ls -lhF /proc/`pgrep firebird`/fd
ç䌌ãã£ã¬ã¯ããªã®ãªã¹ãå
/proc/âŠ/fd/
ã·ã³ããªãã¯ãªã³ã¯ã衚瀺ããããã¡ã€ã«ã«é¢ããå®éã®æ
å ±ã次ã®ããã«è¡šç€ºãããŸãã
sudo stat -L /proc/`pgrep firebird`/fd/ÐÐÐÐÐ
ã©ã ÐÐÐÐÐ
â 察象ãã¡ã€ã«ã®èšè¿°åïŒèšè¿°åïŒã
ãããšåŒã¶ä»£ããã«pgrep ОÑпПлМÑеЌÑй-Ñайл
ã察象ã®ããã»ã¹ã®èå¥åãããã«çœ®ãæããããšãã§ããŸãã
äžæãã¡ã€ã«ã¯éåžžã«å€§ãããªãå¯èœæ§ãããããã /tmp
å°ãªããšã 20 ïœ 30 GB ãå²ãåœãŠãããšããå§ãããŸãã ãœãŒã ãã¡ã€ã«ã®ãµã€ãºã¯ããªã¯ãšã¹ãå
ã§æ瀺çãŸãã¯æé»çã«ãœãŒããããããŒã¿ã®éã«ã®ã¿äŸåããXNUMX 人ã®ãŠãŒã¶ãŒãã®ã¬ãã€ãã®äžæãã¡ã€ã«ããäœæãã§ããããšãèæ
®ããå¿
èŠããããŸãã
ããŒã¿ããŒã¹ ãã¡ã€ã«ã®ã»ã¯ã·ã§ã³ã«ã¯ããã¹ãŠã®ããŒã¿ããŒã¹ ãã¡ã€ã«ãå«ããå¿ èŠããããŸãã ããã«ãå°ãªããšãæ倧ã®ããŒã¿ããŒã¹ ãã¡ã€ã«ã®ã³ããŒãå¿ èŠã§ãã ä»åŸæ°å¹Žéã®ããŒã¿ããŒã¹ ãã¡ã€ã«ã®å¢å€§ãèæ ®ããå¿ èŠããããŸãã
ããŒã«ã« ããã¯ã¢ãã ã»ã¯ã·ã§ã³ã«ã¯ããã¹ãŠã®ããŒã¿ããŒã¹ã®ããã¯ã¢ãã ã¢ãŒã«ã€ããå°ãªããšã XNUMX ã€ãšãæ倧ã®ããŒã¿ããŒã¹ã®ããã¯ã¢ãããå«ãŸããŠããå¿ èŠããããŸãã ãã®ã»ã¯ã·ã§ã³ã«ã¯ãæ倧ã®ããŒã¿ããŒã¹ã埩å ããããã®ã¹ããŒã¹ãå«ãŸããããšãæãŸããã§ãã å°æ¥æ°å¹Žéã«ãããããã¯ã¢ãããšããã¯ã¢ãã ã¢ãŒã«ã€ãã®å¢å ãèæ ®ããå¿ èŠããããŸãã
äºåæºå
Firebird 3.0 DBMS ãµãŒããŒã¯ã·ã¹ãã ã¡ã¢ãªãåçã«å²ãåœãŠãã解æŸããããããããæçåãçºçããå¯èœæ§ããããŸãã ããšãã°ãå€æ°ã®ãŠãŒã¶ãŒãäžåºŠã«ã¹ãŒããŒãµãŒããŒããåæãããåŸãæ°ããæ¥ç¶ã確ç«ãããšãã«ãšã©ãŒãçºçããå¯èœæ§ããããŸãã
ã¡ã¢ãªã®æçåã¯ã·ã¹ãã ãã©ã¡ãŒã¿ã«ãã£ãŠå¶åŸ¡ãããŸã vm.max_map_count
ãããã©ã«ã㯠64K ã§ãã ãã®å€ã XNUMX åã«å¢ããããšããå§ãããŸãã
sudo sysctl vm.max_map_count=256000
ã·ã¹ãã ã®åèµ·åæã«æ°ããå€ãèšå®ãããããã«ããã¡ã€ã«ã«è¿œå ããŸãã /etc/sysctl.conf
ã©ã€ã³ïŒ
vm.max_map_count = 256000
ãã®ãã©ã¡ãŒã¿ãå€æŽããçç±ãæ確ã«ããããã«ãã³ã¡ã³ããäœæããããšããå§ãããŸãã ãŸããã¡ã€ã«ãç·šéããŠããããã¡ã€ã«ã«ä¿åãããŠããèšå®ãé©çšã§ããŸãã
sudo sysctl -p /etc/sysctl.conf
å¿ èŠãªããã±ãŒãžã®ã€ã³ã¹ããŒã«
Firebird 3.0 Linux DBMS ã®å®è¡å¯èœãã¡ã€ã«ã¯ãncurses ã©ã€ãã©ãª (libncurses.so.5
)ãICU (ããŒãžã§ã³ã«é¢é£ä»ããããŠããããåºåã«ã¯è¡šç€ºãããŸãã) ldd
) ãšãã ãã¹ (libtommath.so.0
ïŒã ã¢ã»ã³ã㪠ã¢ãŒã«ã€ããããŠã³ããŒãããŠè§£åããã«ã¯ããŠãŒãã£ãªãã£ãå¿
èŠã§ã gzip
, tar
О curl
ãŸã㯠wget
ã ICU ããŒãžã§ã³ã gzip
, tar
О curl
/wget
â éèŠã§ã¯ãããŸããã
ããã±ãŒãžã®æäœã¯ã·ã¹ãã ãšã·ã¹ãã ã§äœ¿çšãããããã±ãŒãž ãããŒãžã£ãŒã«äŸåããããããããã XNUMX ã€ãã€æ€èšããŠãããŸãã
CentOS 8
CentOS 8 ã¯æ°ããããã±ãŒãž ãããŒãžã£ãŒã䜿çšããŸã â dnf
ã³ãã³ãã«ãã£ãŠãééçã«ãåŒã³åºãããŸã yum
ã ç§ãã¡ã®ç®çã§ã¯ãããã®éã«éãã¯ãªãã®ã§ãäŸã§ã¯æ¬¡ã®ããã«ãªããŸãã yum
.
ã¡ã¿ããŒã¿ ãã£ãã·ã¥ãæŽæ°ããŸãã sudo yum makecache
libtomath ããã±ãŒãžã¯å¥ã® E(xtra)P(ackages for)E(nterprise)L(inux) ãªããžããªã«ããããããã§ã«å«ãŸããŠããããšã確èªããŸãã
yum -C repolist
ãªãã·ã§ã³ããã£ãã·ã¥ããã®ã¿ã(-C
ãŸã㯠--cache-only
) ã¯ãäžèŠãªãã§ãã¯ãšããŠã³ããŒããæé€ããyum ãé«éåããããã«äœ¿çšãããŸãã ãªã¹ãã« epel ãªããžããªããªãå Žåã¯ããããã€ã³ã¹ããŒã«ããã¡ã¿ããŒã¿ ãã£ãã·ã¥ãæŽæ°ããŸãã
sudo yum install epel-release &&
sudo yum makecache
å¿ èŠã«å¿ããŠãä¿¡é Œã§ãããœãŒã¹ããæ¢ç¥ã® pgp ããŒã®å€ããã§ãã¯ããŠãªã¯ãšã¹ãã確èªããŸãã
https ãªãœãŒã¹ãããªããžããªã®ã¡ã¿æ
å ±ãããŒãããéã«åé¡ãçºçããå Žåã¯ããã¡ã€ã«ãç·šéããŠãã ãã /etc/yum.repos.d/epel.repo
ã眮ãæãã https://
Ма http://
ãããŠãã£ãã·ã¥æŽæ°ã³ãã³ããç¹°ãè¿ããŸãã
å¿ èŠãªããã±ãŒãžã®ã¹ããŒã¿ã¹ã確èªããŸã (ã³ãã³ãã¯è€éã§ããåºåäŸã§ã¯ 32 ããã ããã±ãŒãžããã£ã«ã¿ãªã³ã°ãããŠããŸã)ã
yum -C list
ncurses libicu libtommath
gzip tar curl wget |
grep -v i686
Installed Packages
curl.x86_64 7.61.1-11.el8 @anaconda
gzip.x86_64 1.9-9.el8 @anaconda
ncurses.x86_64 6.1-7.20180224.el8 @anaconda
Available Packages
libicu.x86_64 60.3-1.el8 BaseOS
libtommath.x86_64 1.1.0-1.el8 epel
tar.x86_64 2:1.30-4.el8 BaseOS
wget.x86_64 1.19.5-8.el8_1.1 AppStream
ãããããããŸã curl
, gzip
О ncurses
ã€ã³ã¹ããŒã©ãŒã®æ¬äŒŒãªããžããªã§ãã¹ããããŠããŸã (anaconda
ïŒãããã³ tar
â æå°ã·ã¹ãã ã€ã³ã¹ããŒã«ããé€å€ãããŸãã ã¡ãžã£ãŒããŒãžã§ã³ libncurses
О libtommath
å¿
èŠä»¥äž: 6 ãš 1 ã§ã¯ãªãããããã 5 ãš 0ã åãããã±ãŒãžãã€ã³ã¹ããŒã«ãããŠããŠå©çšå¯èœãªå Žåã¯ããã®ããã±ãŒãžã®ã¢ããããŒãããªãªãŒã¹ãããŠããŸãã äžè¶³ããŠããããã±ãŒãžãã€ã³ã¹ããŒã«ããŸãã
sudo yum install
libicu libtommath tar
Ubuntuã®19
ãŠãŒãã£ãªãã£ã¯ããã±ãŒãžã管çããããã«èšèšãããŠããŸã apt
, aptâget
О aptâcache
ã æåã® XNUMX ã€ã¯ã€ã³ã¿ã©ã¯ãã£ããªäœæ¥çšã«èšèšãããŠãããæåŸã® XNUMX ã€ã¯ã¹ã¯ãªããã§äœ¿çšããããã«èšèšãããŠããŸãã ããã±ãŒãžåã¯è¥å¹²ç°ãªããããŒãžã§ã³ãå«ãŸããŠããŸãã
å¿ èŠãªããã±ãŒãžã®ã¹ããŒã¿ã¹ã確èªããŸã (ã³ãã³ããçµåãããåºåäŸãççž®ããã32 ããã ããã±ãŒãžããã£ã«ã¿ãŒã§é€å€ãããŸã)ã
apt list libncurses? libicu?? libtommath?
gzip tar curl wget |
grep -v i386
curl 7.65.3-1
gzip 1.10-0 [upgradableâŠ]
libicu63 63.2-2 [installed]
libncurses5 6.1
libncurses6 6.1 [installed,automatic]
libtommath1 1.1.0
tar 1.30 [installed]
wget 1.20.3 [installed]
è§æ¬åŒ§ã瀺ãããã±ãŒãž installed
/upgradable
â ã€ã³ã¹ããŒã«ãããŠããŸãã å©çšå¯èœã ãã€ã³ã¹ããŒã«ãããŠããªã ncurses5
代ããã« curl
ã»ãã wget
ã äžè¶³ããŠããããã±ãŒãžãã€ã³ã¹ããŒã«ããŸãã
sudo aptâget install
libncurses5 libtommath1
ã·ã³ããªãã¯ãªã³ã¯ã®äœæ
ãã libtommath.so.1
О libncurses.so.6
ïœãšã®äžäœäºææ§ããã libtommath.so.0
О libncurses.so.5
ã®å ŽåãFirebird ã®å Žåã¯ãã©ã€ãã©ãªã®æ¢åã®ããŒãžã§ã³ãžã®ã·ã³ããªãã¯ãªã³ã¯ãäœæããã ãã§ååã§ãã
æã
ã¯æ°ã¥ã libtommath.so.1
(libncurses.so.?
åããã£ã¬ã¯ããªã«ãããŸã):
find /usr -name libtommath.so.1
CentOSã®ïŒ
/usr/lib64/libtommath.so.1
Ubuntuã®ïŒ
/usr/lib/x86_64-linux-gnu/libtommath.so.1
ã·ã³ããªãã¯ãªã³ã¯ãäœæããŸãã
CentOSã®ïŒ
sudo ln -s libtommath.so.1
/usr/lib64/libtommath.so.0
sudo ln -s libncurses.so.6
/usr/lib64/libncurses.so.5
Ubuntuã®ïŒ
sudo ln -s libtommath.so.1
/usr/lib/x86_64-linux-gnu/libtommath.so.0
çµæã確èªããŠã¿ãŸããã (ã³ãã³ãã¯è€éãªã®ã§ãåºåäŸã¯ççž®ãããŠããŸã)ã
ls -lhF
$(dirname `find /usr -name libtommath.so.1`) |
grep "lib(ncurses|tommath).so."
CentOSã®ïŒ
libncurses.so.5 -> libncurses.so.6*
libncurses.so.6 -> libncurses.so.6.1*
libncurses.so.6.1*
libtommath.so.0 -> libtommath.so.1*
libtommath.so.1 -> libtommath.so.1.1.0*
libtommath.so.1.1.0*
Ubuntuã®ïŒ
libncurses.so.5 -> libncurses.so.5.9
libncurses.so.5.9
libncurses.so.6 -> libncurses.so.6.1
libncurses.so.6.1
libtommath.so.0 -> libtommath.so.1
libtommath.so.1 -> libtommath.so.1.1.0
libtommath.so.1.1.0
Firebird DBMS é åžããããããŠã³ããŒãããŸãã
Firebird ãããžã§ã¯ãã®å ¬åŒ Web ãµã€ã (firebirdsql.org) ã§ã¯ããå ¬åŒããªãªãŒã¹ããã³ããã€ãªãŒããã«ã (ã¹ãããã·ã§ãã ãã«ã) ã®ãã£ã¹ããªãã¥ãŒã·ã§ã³ãžã®ãªã³ã¯ãå ¬éãããŠããŸãã
å ¬åŒ Linux ãªãªãŒã¹ã¯ã¢ãŒã«ã€ã (tar.gz) ããã³ deb/rpm ããã±ãŒãžãšããŠå ¥æã§ããŸããããã«ãã¯ã¢ãŒã«ã€ããšããŠã®ã¿å ¥æã§ããŸãã ãæ±çšã€ã³ã¹ããŒã©ãŒã(tar.gz ã®æ±çšã€ã³ã¹ããŒã©ãŒ) ãæ€èšããŸãã
ãã«ã ã¢ãŒã«ã€ããããŠã³ããŒãããŠè§£åããå¿
èŠããããŸãããäž¡æ¹ã®ããã»ã¹ãçµã¿åãããŸãã é梱ã¯ä»¥äžã§è¡ãããŸã /tmp
,URL ã¯ãããŠã³ããŒãå¯èœãªã¢ãŒã«ã€ããžã®ãªã³ã¯ã瀺ããŸãã
ã«ãŒã«ïŒ
curl -L URL | tar -zxC /tmp
wgetïŒ
wget -Oâ URL | tar -zxC /tmp
ÐПÑЌПлÑÐ°ÐœÐžÑ curl
ããŠã³ããŒããããããŒã¿ãæšæºåºåã«éä¿¡ããŸããããªãã€ã¬ã¯ãã¯åŠçããªãããããããè¿œå ããŸããâL
"ãA wget
éã«ããªãã€ã¬ã¯ããåŠçããŸãããããŒã¿ããã¡ã€ã«ã«æžã蟌ã¿ãŸããâOâ
ã ã®ããã« tar
䜿çšã瀺ã gzip
-filter ãšè§£åãå®è¡ããããã£ã¬ã¯ããªã åŠçãå®äºãããšããã®ãããªãã£ã¬ã¯ããªã衚瀺ãããŸã Firebirdâ3.0.5.33220â0.amd64
XNUMX ã€ã®ãã¡ã€ã«: install.sh
, buildroot.tar.gz
О manifest.txt
.
ãã¡ã€ã¢ããŒãã®ã€ã³ã¹ããŒã«
äºåæºåäžã«ã·ã¹ãã ãã©ã¡ãŒã¿ã®å€ã調æŽããŸãã vm.max_map_count
ãå¯çšæ§ã確èªããICUãncursesãtommath ã©ã€ãã©ãªãã€ã³ã¹ããŒã«ããŸããã ncurses ãš tommath ã®ããŒãžã§ã³ãæ£ããããšã確èªããŠãã ãã (libncures.so.5
О libtommath.so.0
) å¿
èŠãªã·ã³ããªãã¯ãªã³ã¯ãäœæããŸããã
å®éã®åãä»ãã¯éåžžã«ç°¡åã§ãã Firebird é
åžã¢ãŒã«ã€ãã解åããããã£ã¬ã¯ããªã«ç§»åããå¿
èŠã«å¿ããŠã¹ã¯ãªããã®ãå®è¡å¯èœããã©ã°ã確èªããŠèšå®ããŸãã install.sh
:
chmod +x install.sh
ã€ã³ã¹ããŒã« ã¹ã¯ãªãããå®è¡ããŸãã
sudo ./install.sh
Enter ããŒãæŒããšã€ã³ã¹ããŒã«ã®éå§ã確èªãããèŠæ±ãåä¿¡ããã sysdba ãã¹ã¯ãŒããå ¥åããŸãã
ã€ã³ã¹ããŒã«ã¹ã¯ãªãããèªåçã«éå§ãããŸã systemd
-ãŠããã firebird-superserver
(ãµã€ã¬ã³ã Firebird 3.0 ã¢ãŒããã¯ãã£)ã Firebird ãµãŒãã¹ã¯ãã¹ãŒããŒãµãŒããŒã®ããã©ã«ã ãã©ã¡ãŒã¿ãã€ãŸã 2048 ããŒãžã®ããŒãž ãã£ãã·ã¥ (ããŒã¿ããŒã¹ããš)ã64 MB ã®ãœãŒã ãããã¡ (å
±æ)ãããã³ããŒãžã§ã³ XNUMX ã¯ã©ã€ã¢ã³ãã®ã¿ã®æ¥ç¶ã§åäœããŸãã ãªãã·ã§ã³ã衚瀺ãã firebird.conf
:
grep -v ^# firebird.conf | grep -v ^$
ããã®æ°ããå€ã«æ³šæããŠãã ããã firebird.conf
Firebird ãµãŒãã¹ãåèµ·åããåŸã«ã®ã¿ã¢ã¯ãã£ãåãããŸãã
ãã©ã¡ãŒã¿å€ãéžæãããšãã¯ãããŒãž ãã£ãã·ã¥ (ããŒã¿ããŒã¹çš)ã䞊ã¹æ¿ããããã¡ (å ±æ)ãããã³ã¯ã©ã€ã¢ã³ãæ¥ç¶çšã«ãµãŒããŒã«ãã£ãŠå²ãåœãŠãããã¡ã¢ãªãšãã XNUMX ã€ã®äž»èŠãªãã³ã³ã·ã¥ãŒãããååšããããšãèæ ®ããå¿ èŠããããŸãã æåã® XNUMX ã€ã ãã管çã§ããŸããã¯ã©ã€ã¢ã³ãæ¥ç¶ã®ã¡ã¢ãªéã¯ããã£ãã·ã¥ãããã¯ãšãªã®æ°ãšããã¹ãããã®ãã©ã³ãã¯ãšãªã«å«ãŸããããŒã¿ããŒã¹ ãªããžã§ã¯ãã«ãã£ãŠç°ãªããŸãã ã¯ã©ã€ã¢ã³ãæ¥ç¶ã¡ã¢ãªã®èŠç©ããã¯çµéšçã«ã®ã¿è¡ãããŠãããã¯ã©ã€ã¢ã³ã ã¢ããªã±ãŒã·ã§ã³ãããŒã¿ããŒã¹ ãªããžã§ã¯ãã®å€æŽã«å¿ããŠå€æŽãããå¯èœæ§ããããŸãã
å°éã®ã¡ã¢ãª (æ倧 12 ïœ 16 GB) ãåãããã¹ãäžã®ã¹ãŒããŒãµãŒããŒã®å ŽåãããŒãž ãã£ãã·ã¥ãšãœãŒã ãããã¡ã« RAM ã®åèšéã® XNUMX åã® XNUMX ãŸã㯠XNUMX åã® XNUMX ãè¶ ããéãå²ãåœãŠãªãã§ãã ããã
ããŒã¿ããŒã¹ã®æ°ãåºå®ãããŠããããå€æŽãããå¯èœæ§ãããå Žåã¯ãããŒãž ãã£ãã·ã¥ ã¡ã¢ãªã®ç·éããµãŒããŒäžã«ååšã§ããããŒã¿ããŒã¹ã®æ倧æ°ã§å²ãå¿ èŠããããŸãã ããŒãž ãã£ãã·ã¥ã®ãµã€ãºã¯ããŒãžåäœã§æå®ãããå¥éãã€ãã«å€æããå¿ èŠããããŸãã
ã¯ã©ã·ã㯠ã¢ãŒããã¯ãã£ã«åãæ¿ããã«ã¯ãå°ãªããšãæ瀺çã«æå®ããå¿
èŠããããŸãã ServerMode
в firebird.conf
ãããã«ããããŒãžãã£ãã·ã¥ãæžããïŒ2K以äžïŒããœãŒããããã¡ïŒãã¹ãŠã®çš®é¡ã®åèšèš±å®¹éãæ倧æ¥ç¶æ°ã§å²ã£ãå€ïŒãæžããããŠããããç¡å¹ã«ããŠåæ¢ããŸãã firebird-superserver
ããŠããããæå¹ã«ããŠèµ·åããŸã firebird-classic.socket
.
Firebird 3.0 ã§ã¹ãŒããŒã¯ã©ã·ã㯠ã¢ãŒããã¯ãã£ã䜿çšããããšã¯ããŸãæå³ããããŸããããä¿¡é Œæ§ãã¯ã¹ãŒããŒãµãŒããŒãšåãäžè¬çãªäžŠã¹æ¿ããããã¡ã®ãããªãã®ã§ãã å ±éã®ããŒãž ãã£ãã·ã¥ã¯ãªããç°ãªãæ¥ç¶ãçžäºã«åæããããšã«ãããæ倱ãã¯åŸæ¥ã®æ¥ç¶ãšåãã§ãã
Firebird 3.0 ã§ã¯ãäžéšã®ãã©ã¡ãŒã¿ (ããŒãž ãã£ãã·ã¥ããã㯠ãã¡ã€ã« ãµã€ãºãããã·ã¥ ããŒãã«ãªã©) ã次ã®ããã«èšå®ã§ããããšã«æ³šæããŠãã ããã databases.conf
ããŒã¿ããŒã¹ããšã«åå¥ã«ã ã¹ãŒããŒãµãŒããŒã®å Žåãããšãã°å°ããªå€ãèšå®ãããšäŸ¿å©ã§ãã DefaultDbCachePages
в firebird.conf
å¿
èŠãªããŒã¿ããŒã¹ã«åå¥ã®ããŒãž ãã£ãã·ã¥ãã€ã³ã¹ããŒã«ããŸãã databases.conf
.
ã³ã¡ã³ãã§èšäºã«ã€ããŠè³ªåãããããµããŒã ã¢ãã¬ã¹ã«æçŽãæžããŠãã ããã [ã¡ãŒã«ä¿è·].
åºæïŒ habr.com