æç« ç®å½
- 1 æä½ç³»ç»ç¯å¢åå¤
-
- 1.1 Windowsç两个注æäºé¡¹
- 1.2 Linuxç¯å¢ä¸çæå¡å¨ç¡®è®¤
-
- 1.2.1 æä½ç³»ç»ç®å½åå
- 1.2.2 æ·»å DMDBA ç¨æ·
- 1.2.3 ç®å½åæé
- 1.2.4 éè¿UUIDæè½½ç£ç
- 1.2.5 å设å¤ç详ç»è¯´æ
- 1.2.6 ç£çè°åº¦ç®æ³éæ©
- 1.2.7 å ¶ä»è°æ´
-
- 1.2.7.1 设置æ¶é´åæ¥èæ¬
- 1.2.7.2 æ£æ¥å¹¶ç¡®è®¤æ¶åº
- 1.2.7.3 è°æ´ Limits.conf
- 1.2.7.4 è°æ´ Sysctl.confï¼å¿ åï¼
- 1.2.7.5 å ¶ä»è°æ´åå¤çï¼éåï¼
-
- 1.2.7.5.1 æ ¼å¼å - å大å°çéæ©
- 1.2.7.5.2 确认loginé ç½®
- 1.2.7.5.3 è°æ´ Sysctl.conf
- 1.2.7.5.4 å ³é selinux
- 1.2.7.5.5 â å¿ è¦çå·¥å ·å å®è£
- 1.2.7.5.6 æ¸ ç©ºé²ç«å¢çç¥
- 1.2.7.5.7 å®æ¶æ¸ ç cache
- 1.2.7.5.8 ç¦ç¨éæ大页
- 1.2.7.5. 9 æ£æ¥å¹¶ç¡®è®¤è¯è¨è®¾ç½®
- 1.2.7.5.10 æ£æ¥å¹¶è°æ´sshdé ç½®
- 1.2.7.5.11 设置ç£çé¢è¯»
- 1.2.7.5.12 è°æ´coreæ件çæè·¯å¾
- 2 DM8é¨ç½²å®æ½æµç¨
-
- 2.1 æµç¨
- 2.2 é¨ç½²è§å
- 3 å®è£ æ°æ®åºè¿ç¨
-
- 3.1 å¾å½¢åå®è£
- 3.2 å½ä»¤è¡å®è£
- 4 åå§åæ°æ®åºå®ä¾è¿ç¨
-
- 4.1 å¾å½¢åå建å®ä¾åæå¡
- 4.2 å½ä»¤è¡å建å®ä¾åæå¡
- 5 æå¡å¯å
-
- 5.1 å¾å½¢åæ¹å¼
- 5.2 å½ä»¤è¡æ¹å¼
- 6 é ç½®è¿ç¨
-
- 6.1 é ç½®å½æ¡£æ件
- 6.2 é ç½®æ°æ®åºå®æ¶å¤ä»½
- 7 ä¼åè¿ç¨
- 8 管çè¿ç¨
-
- 8.1 å¾å½¢åæ¹å¼
- 8.2 å½ä»¤è¡æ¹å¼
- 8.3 å建ç¨æ·å表空é´
1 æä½ç³»ç»ç¯å¢åå¤
1.1 Windowsç两个注æäºé¡¹
注æï¼è¿é讲çé½æ¯linuxï¼é对Windowsåªéè¦æ³¨æä¸é¢ä¸¤ä¸ªç¹ã
1ãå°½å¯è½ä½¿ç¨é«æ§è½çç£ç
2ãå¨ç¡®è®¤åå¨æ²¡æå¯æç»çµæºæ¶ï¼è¯·å ³éç£çåç¼åã
å ³éæå¡å¨ç£çåç¼åçæ¹æ³ï¼
- æå¼æå¡å¨è®¾å¤ç®¡çå¨
- å¨è®¾å¤ç®¡çå¨ä¸ï¼ç£ç驱å¨å¨ä¸ï¼å¯¹è±¡çå±æ§é¡µé¢ä¸ï¼çç¥é项å¡ä¸çâå¯ç¨è®¾å¤ä¸çåç¼åï¼Wï¼âé»è®¤çå¾éï¼å»æ并ç¹å»ç¡®å®
1.2 Linuxç¯å¢ä¸çæå¡å¨ç¡®è®¤
说æï¼ ç¨æ·éè¦å好空é´è§åå确认ï¼äº¤ä»ç»æ°æ®åºå®è£ é¨ç½²å·¥ç¨å¸çåºè¯¥åªæ¯dmdbaç¨æ·æè å ¶ä»érootç¨æ·ã 注æç¸å ³ç®å½çæééè¦æäºç»åºç¨æ·çææè æéã
å¿ å项
1.2.1 æä½ç³»ç»ç®å½åå
æä½ç³»ç»å®è£ æ¶ï¼å¯æç §èªå·±çè§åéååéçé ç½®çç¥ï¼ä¹å¯ä»¥åç §å¦ä¸æ¹å¼ï¼
å称 | æè½½ç¹ï¼å»ºè®®ï¼ | åèæè¿° | å¤æ³¨ |
---|---|---|---|
æ ¹ç®å½ | / | 大äº50GBï¼ç³»ç»ä¸»ååº | æä½é ç½® |
Boot | /boot | 200MB | æä½é ç½® |
Swap | ç©çå åå°äº 16GB æ¶ï¼å»ºè®®ä¸ºç©çå åç两åï¼è¶ è¿ 16GBæ¶ï¼å»ºè®®åç©çå å大å°ä¸è´ï¼è¶ è¿32 GBæ¶ï¼å»ºè®®ä¸º 32 GBã | æä½é ç½® | |
Home | /home | 10GB | æä½é ç½® |
Usr | /usr | 10GB | æä½é ç½® |
DM_HOME | /dameng | 建议为ç©çå å大å°+50GBåºç¡å¤§å°ï¼å¹¶å ä¸é¢è®¡çå½æ¡£çå大å°ï¼åå¤ä»½æé大å°ã | æ°æ®åºè½¯ä»¶å®è£ ç®å½,å³å®è£ è·¯å¾ã |
DM_DATA | /data/dmdata | ç£çå©ä½å¤§å°ï¼ææ°æ®åºå¾ åæ¾æ°æ®å¤§å°ä¸ºä¾æ®åé ã | æ°æ®æ件åæ¾ç®å½ï¼å¯ä»¥å å«æ°æ®æ件ãå½æ¡£ãå¤ä»½çã |
å½æ¡£å¤§å°ï¼
æ£å¼ç¯å¢ï¼éè¦ä¿è¯è³å°ææè¿ä¸¤ä¸ªå ¨å¤ä¹é´çææå½æ¡£ï¼å¦ä¸å¨è¿è¡ä¸æ¬¡å ¨å¤ï¼åè³å°ä¿ç10天ä¹ç±»çææå½æ¡£ï¼ï¼
æµè¯ç¯å¢ï¼éå½çå10GBæè 20GBå½æ¡£å³å¯ï¼ç¨ä»¥æ¯æç©çå¤ä»½ã
å¤ä»½å¤§å°ï¼
æ£å¼ç¯å¢ï¼éè¦ä¿ç足å¤çå¤ä»½ãå¤ä»½åä¸ºå ¨éå¤ä»½åå¢éå¤ä»½ï¼ä¸è¬ä¸ºæ¯å¤©ä¸æ¬¡å¢éå¤ä»½ï¼æ¯å¨ä¸æ¬¡å ¨éå¤ä»½ï¼å»ºè®®è³å°ä¿çä¸ä¸ªæçææå¤ä»½ï¼éè¦ä»¥åå®é æ åµä¼°ç®æé空é´å¤§å°ã
æµè¯ç¯å¢ï¼è³å°ä¿çä¸ä¸ªå ¨å¤ï¼ä¹åºè¯¥å »æå®æå¤ä»½çä¹ æ¯ã
ç£çååºæ¹å¼ï¼
éæ© Create Custom Layoutï¼å¹¶å¯ä»¥éå½ä¿çä¸äºå©ä½ç©ºé´ï¼æ¹ä¾¿ä»¥åéè¦æ¶ä½¿ç¨ã
å ¶ä»ï¼
ï¼1ï¼ä½¿ç¨ df âh æ¥çç£çæè½½æ åµã
ï¼2ï¼æ ¹æ®æ°æ®åºæå¡å¨é ç½®è§åå®è£ è·¯å¾ãæ°æ®è·¯å¾ãå¤ä»½è·¯å¾ã
ï¼3ï¼å®è£ è·¯å¾ï¼å»ºè®®æ¾å¨æ¬å°çï¼/home/dmdba/dmdbmsï¼ã
ï¼4ï¼æ°æ®è·¯å¾ï¼å»ºè®®æ¾å¨åå¨æ§è½æ好çå°æ¹ï¼å¦ç£çéµåçæè½½ç¹ä¸(/dmdata)ã
ï¼5ï¼å½æ¡£è·¯å¾ï¼å»ºè®®æ¾å¨æ°æ®è·¯å¾ä¸ï¼é¿å 误å (/data/dmdata/arch)ï¼å»ºè®®åç¬æè½½ã
ï¼6ï¼å¤ä»½è·¯å¾ï¼å»ºè®®æ¾å¨åæ°æ®ä¸åççä¸(/data/dmdata/bak)ï¼å»ºè®®åç¬æè½½ã
å¯ä»¥å¦ä¸è§åè·¯å¾ï¼
ï¼1ï¼å®è£ è·¯å¾ï¼/home/dmdba/dmdbms
ï¼2ï¼æ°æ®è·¯å¾ï¼/data/dmdata
ï¼3ï¼å½æ¡£è·¯å¾ï¼/data/dmdata/arch
ï¼4ï¼å¤ä»½è·¯å¾ï¼/data/dmdata/bak
1.2.2 æ·»å DMDBA ç¨æ·
æå®åºå®çç»idåç¨æ·idï¼æ¹ä¾¿å¤ä»½ï¼æä½ç³»ç»å¤ä»½ãæ¢å¤åæé管çæ£ç¡®ï¼ã
groupadd dinstall -g 2001å建ç¨æ·ç»dinstall
useradd -g dinstall dmdba -i 1001å建å±äºdinstallç¨æ·ç»çç¨æ·dmdba
passwd dmdba
è¾å ¥ä¸æ¬¡å¯ç
éæ°è¾å ¥ä¸æ¬¡å¯ç
å建æå
1.2.3 ç®å½åæé
| --mkdir /home/dmdba/dmdbms
mkdir /data/dmdata/arch
mkdir /data/dmdata/bak
chown -R dmdba:dinstall /data/dmdata ä¿®æ¹/data/dmdataåå ¶åç®å½çæ¥æè 为dmdbaï¼ç¨æ·ç»ä¸ºdinstall
chmod -R 775 /data/dmdata ä¿®æ¹/data/dmdataåå ¶åç®å½æé
å ¶åï¼åå¯åæ¢ dmdba ç¨æ·ï¼ä¸ä¼ å®è£ æ件ï¼è¿è¡æ°æ®åºå®è£ ã
1.2.4 éè¿UUIDæè½½ç£ç
UUID å ¨ç§°æ¯ Universally Unique Identifierï¼ä¹å°±æ¯è¯´ï¼æ¯ä¸ªååºæä¸ä¸ªå¯ä¸ç UUID
å¼ï¼Linuxç³»ç»ï¼çº¢å¸½ç³»åçFedoraï¼Cent
OSï¼æDebianç³»åçUbuntuï¼LinuxMintï¼ççï¼é½éç¨UUIDæ¹å¼æè½½ååºï¼é¿å åçååºè¯å«æ··ä¹±çé®é¢ã
fstabæ件ä½äº/etc/ä¸ï¼æå¨ååºçæ ¼å¼ä¸ºï¼
# <file system> <mount point> <type> <options> <dump> <pass>
ä¾å¦ï¼
s_spec fs_file fs_type fs_options fs_dump fs_pass
/dev/hda1 / ext2 defaults 1 1
fs_spec -
该å段å®ä¹å¸æå è½½çæ件系ç»æå¨ç设å¤æè¿ç¨æ件系ç»ï¼å¯¹äºä¸è¬çæ¬å°å设å¤æ åµæ¥è¯´ï¼IDE设å¤ä¸è¬æ述为/dev/hdXNï¼Xæ¯IDE设å¤éé(a,
b, or c)ï¼N代表ååºå·ï¼SCSI设å¤ä¸æ述为/dev/sdaXNï¼
fs_file -
该å段æè¿°å¸æçæ件系ç»å è½½çç®å½ç¹ï¼å¯¹äºswap设å¤ï¼è¯¥å段为noneï¼å¯¹äºå è½½ç®å½åå å«ç©ºæ ¼çæ åµï¼ç¨40æ¥è¡¨ç¤ºç©ºæ ¼ï¼
fs_type - å®ä¹äºè¯¥è®¾å¤ä¸çæ件系ç»ï¼ä¸è¬å¸¸è§çæ件类å为ext2
(Linux设å¤ç常ç¨æ件类å)ãvfat(Windowsç³»ç»çfat32æ ¼å¼)ãNTFSãiso9600çï¼
fs_options -
æå®å 载该设å¤çæ件系ç»æ¯éè¦ä½¿ç¨çç¹å®åæ°é项ï¼å¤ä¸ªåæ°æ¯ç±éå·åéå¼æ¥ã对äºå¤§å¤æ°ç³»ç»ä½¿ç¨defaultså°±å¯ä»¥æ»¡è¶³éè¦ï¼
fs_dump -
该é项被dumpå½ä»¤ä½¿ç¨æ¥æ£æ¥ä¸ä¸ªæ件系ç»åºè¯¥ä»¥å¤å¿«é¢çè¿è¡è½¬å¨ï¼è¥ä¸éè¦è½¬å¨å°±è®¾ç½®è¯¥å段为0
ï¼
fs_pass -
该å段被fsckå½ä»¤ç¨æ¥å³å®å¨å¯å¨æ¶éè¦è¢«æ«æçæ件系ç»ç顺åºï¼æ ¹æ件系ç»/对åºè¯¥å段çå¼åºè¯¥ä¸º1ï¼å ¶ä»æ件系ç»åºè¯¥ä¸º2ãè¥è¯¥æ件系ç»æ éå¨å¯å¨æ¶æ«æå设置该å段为0;
æ们éæ°åå°UUIDè¿ä¸ªä¸»é¢ä¸ï¼ä¸è¬æ åµä¸ï¼å®è£ çæ°ç³»ç»ï¼é»è®¤åªä¼æè½½æ ¹ååºâ/âåswapååºï¼å¯è½è¿æâ/homeâååºãé£ä¹æ们æ³è¦æè½½å ¶ä»å·²ç»åå¨çååºçæ¶åï¼å¦ä½ç¥éç°æååºçUUIDå¢ï¼ä»¥ä¾¿æ们éè¿ä¿®æ¹/etc/fstabæ件æ¥è¾¾å°å¯å¨ç³»ç»åï¼èªå¨æè½½ååºçç®çã
1.éè¿æ¥ç/dev/disk/by-uuid/ ä¸ç设å¤æ件信æ¯ï¼
# ll -l /dev/disk/by-uuid/æ»ç¨é 0
lrwxrwxrwx 1 root root 10 4æ 8 2017 185900c8-ba6c-403e-96ee-844414c9d835 ->
â¦/â¦/sdb1
lrwxrwxrwx 1 root root 10 4æ 8 2017 713dfd51-00ad-4500-aa03-e7846dc6de4c ->
â¦/â¦/sda3
lrwxrwxrwx 1 root root 10 4æ 8 2017 831df52d-baad-4902-bcce-6128cec95411 ->
â¦/â¦/sdb2
lrwxrwxrwx 1 root root 10 4æ 8 2017 c82632c8-8232-4dd1-a4e9-0c13d2001345 ->
â¦/â¦/sda1
lrwxrwxrwx 1 root root 10 4æ 8 2017 f928a6a1-4f2e-4e69-8567-631648f0dc51 ->
â¦/â¦/sda2
2.éè¿blkidå½ä»¤ï¼
# blkid
/dev/sda2: UUID=âf928a6a1-4f2e-4e69-8567-631648f0dc51â TYPE=âext4â
/dev/sda1: UUID=âc82632c8-8232-4dd1-a4e9-0c13d2001345â TYPE=âext4â
/dev/sda3: UUID=â713dfd51-00ad-4500-aa03-e7846dc6de4câ TYPE=âswapâ
/dev/sdb1: UUID=â185900c8-ba6c-403e-96ee-844414c9d835â TYPE=âext4â
/dev/sdb2: UUID=â831df52d-baad-4902-bcce-6128cec95411â TYPE=âext4â
UUIDåï¼æ们就å¯ä»¥ç¼è¾fstabæ件æ¥æè½½ååºã
ç¼è¾/etc/fstabæ件ï¼
#
UUID=f928a6a1-4f2e-4e69-8567-631648f0dc51 / ext4 defaults 1 1
UUID=c82632c8-8232-4dd1-a4e9-0c13d2001345 /boot ext4 defaults 1 2
UUID=713dfd51-00ad-4500-aa03-e7846dc6de4c swap swap defaults 0 0
UUID=185900c8-ba6c-403e-96ee-844414c9d835 /media/diskb1 ext4 defaults 0 0
UUID=831df52d-baad-4902-bcce-6128cec95411 /media/diskb2 ext4 defaults 0 0
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
ç¼è¾ä¿ååï¼éå¯ï¼å¦æå¨å¯å¨çæ¶åï¼æ²¡æåºç°æ载失败信æ¯ï¼å³æè½½æåã
1.2.5 å设å¤ç详ç»è¯´æ
Raidéæ©
- RAIDéæ©
ä¸ãç³»ç»çéç¨RAID1ï¼æ°æ®çéç¨RAID10ã
äºãä¸å»ºè®®éç¨RAID5ï¼RAID5çéæºåæ§è½ç¸æ¯RAID10å·®è·å¾å¤ï¼ä¸æ°æ®åºç大å¤æ°åæä½å为éæºåãè¥å®¢æ·è§çRAID10浪费ï¼å¯æ¨è使ç¨SATAçæ¥åRAID10ï¼ä¹å¥½è¿ä½¿ç¨SASçåRAID5ã
- RAIDé ç½®
ä¸ãè¦æ±RAIDå¡æBBUçµæ± ã
äºãåçç¥ä¸ºWRITE BACK WITH BBUæè WRITE BACKã
è¥åçç¥ä¸ºWRITE THROUGHï¼ç£ççåæ§è½é常差ãè¥RAIDå¡æ²¡æBBUçµæ± ï¼å¨WRITE
BACKççç¥ä¸ï¼å¼å¸¸æçµä¼å¯¼è´æ°æ®ä¸¢å¤±ï¼æä»¥å¿ é¡»æ£æ¥ä¸è¿°2项ï¼ä¿è¯ç£ççåæ§è½ã
fstab æ件 - æè½½é项
è¿æ¯ä¸ä¸ªå ¸åçæè½½é ç½®(以ext4 为ä¾)ï¼
/dev/mapper/R0_2T /home/ssd-oldDisk/ ext4 defaults 0 0
/dev/sdb /home/dameng/hn/ ext4 defaults 0 0
ä½å设å¤çæè½½ï¼å»ºè®®ä¸è¦ä½¿ç¨é»è®¤é ç½®ï¼defaultså¤ï¼ext4 defaults 表示
rw,suid,dev,exec,auto,nouser,asyncï¼ï¼æ¨è设置为 defaults,noatime
ï¼ç±äºSSDçä»·æ ¼è¶æ¥è¶ä¾¿å®ï¼å»ºè®®ææ¡ä»¶çç¨æ·ï¼å¯¹æ°æ®åºç³»ç»ä½¿ç¨SSDç£çï¼çç´æ¯FLASHéªåå¡ï¼è¿å¯¹æ°æ®åºçæ§è½å°ä¼æé常大ç帮å©ãï¼
å¦ææ¯ ssdï¼åºç¡®ä¿ ssd 设置为 4K 对é½çæ åµä¸ï¼æ·»å äº discard
çæè½½åæ°ï¼å¦defaults,noatime,discardï¼ãå¯ä»¥èªè¡äºè§£ SSD ç TRIM åè½ã
å¤æ³¨ï¼
- åäº raid åï¼è¯¥åæ°æ æã
- å æ ¸çæ¬ä½äº 2.6.33 çï¼ä¹ä¸æ¯æ TRIM ï¼å³ ä¸æ¯æ discard åæ°ï¼ã
å¦æåå¨èªå¸¦çµæºï¼åºæ¥çµæºï¼ââ
ï¼é常éè¦ï¼ä¸çº¿ç¯å¢ä¸ï¼è¦æ±åå¨å¿ 须带åºæ¥çµæºï¼é¿å å¼å¸¸å ³æºãæçµæ¶ï¼ç©çå±é¢çé«æ¦çæ°æ®æåãï¼ï¼ä¸ç¡®è®¤ææçæ åµä¸ï¼è¿å¯ä»¥èèæ·»å å¦ä¸åæ°ï¼ä¼ååå¨æ§è½ï¼
-
commit åæ°ï¼å¦ defaults,noatime,commit=60ï¼
该åæ°ç±»ä¼¼äºIOæä½çéåç¹ï¼æ¹éæ交å°å设å¤ï¼é»è®¤æ¯5ç§ï¼å¾å¤§äºæ¹ï¼è½å¤æææé«æ§è½ãå¦æ没æåºæ¥çµæºï¼åºè¯¥ä½¿ç¨é»è®¤å¼ï¼ä¸ä¸è½å ³éæ件系ç»æ¥å¿ã
-
barrier åæ°ï¼å¦noatime,barrier=0ï¼ãæ¹åæ°ï¼å¨ext4
ä¸é»è®¤å¼å¯ï¼å¦æåå¨èªå¸¦åºæ¥çµæºï¼å¯ä»¥å ³éï¼ä»¥æé«æ§è½ã
åèé ç½®ï¼defaults,commit=60,noatime,barrier=0
1.2.6 ç£çè°åº¦ç®æ³éæ©
注æï¼å¨Centos7æä½ç³»ç»ç¯å¢ä¸ï¼é»è®¤çç£çè°åº¦çç¥ä¸éè¦è°æ´ï¼å·²ç»æ¯deadlineï¼
æ°æ®åºæå¡å¨ï¼å»ºè®®ä½¿ç¨ deadline ç£çè°åº¦ç®æ³ï¼å ·ä½ç¼ç±å¯èªè¡æ¥é ç¸å ³èµæã
# 确认å设å¤1
[[email protected] log]# ps -ef|grep jbd2
root 4126 2 0 2017 ? 00:01:58 [jbd2/dm-0-8]
root 7300 2 0 2017 ? 00:00:00 [jbd2/sda1-8]
root 7302 2 0 2017 ? 02:03:39 [jbd2/dm-4-8]
root 7304 2 0 2017 ? 00:06:15 [jbd2/dm-2-8]
root 7307 2 0 2017 ? 05:57:00 [jbd2/dm-3-8]
root 11896 75490 0 14:29 pts/8 00:00:00 grep jbd2
确认å设å¤2ï¼åå¨ï¼
[[email protected] log]# multipath -ll
æ¥çå½åç£çè°åº¦ç®æ³
[[email protected] log]# cat /sys/block/sda/queue/scheduler
noop anticipatory deadline [cfq]
ä¿®æ¹å¯¹åºç£çè°åº¦ç®æ³ä¸º deadline
[[email protected] log]# echo deadline >/sys/block/sda/queue/scheduler
确认修æ¹åçç£çè°åº¦ç®æ³
[[email protected] log] # cat /sys/block/sda/queue/scheduler
noop anticipatory [deadline] cfq
[[email protected] log] # cat /sys/block/dm-2/queue/scheduler
noop anticipatory deadline [cfq]
[[email protected] log] # echo deadline >/sys/block/dm-2/queue/scheduler
[[email protected] log] # cat /sys/block/dm-2/queue/scheduler
noop anticipatory [deadline] cfq
[[email protected] log] # cat /sys/block/dm-3/queue/scheduler
noop anticipatory deadline [cfq]
[[email protected] log] # echo deadline >/sys/block/dm-3/queue/scheduler
[[email protected] log] # cat /sys/block/dm-3/queue/scheduler
noop anticipatory [deadline] cfq
[[email protected] log] # echo deadline >/sys/block/dm-4/queue/scheduler
[[email protected] log] # cat /sys/block/dm-4/queue/scheduler
none
[[email protected] log] # cat /sys/block/dm-0/queue/scheduler
none
[[email protected] log]# |
åæ¶ï¼ä¹å¯ä»¥éè¿ä¿®æ¹å æ ¸å¼å¯¼åæ°ï¼å å ¥elevator= deadline å¦ï¼
vi /boot/grub/menu.lst
æ´æ¹ä¸ºï¼ kernel /boot/vmlinuz-2.6.32-504.el6 ro root=LABEL=/ elevator=deadline rhgb quiet |
注æï¼å¦æ³éè¿è¿ç§æ¹å¼è°æ´ï¼å¡å¿ 请æä½ç³»ç»å·¥ç¨å¸åå©ãå 为ï¼è¯¥æä½å¦æä¿®æ¹é误ï¼ä¼å¯¼è´æå¡å¨æ æ³å¯å¨ã
ä¹å°±æ¯éè¿è¿ç§æ¹å¼ï¼å¸è½½rc.localä¿è¯æ¯æ¬¡éå¯æå¡å¨åï¼å次设置ä¹æ¯å¯åçï¼
echo âecho deadline > /sys/block/sdb/queue/schedulerâ >> /etc/rc.local
注ï¼è¾¾æ¢¦æ°æ®åºæ°æ®æ件æå¨ååºä¸º/dev/sdb1
1.2.7 å ¶ä»è°æ´
1.2.7.1 设置æ¶é´åæ¥èæ¬
ç³»ç»å æææå¡å¨ï¼åºè¯¥ä¿ææ¶é´ä¸è´ãå¦ä¸ä»¥ 10.10.10.10 为 ntp
æå¡å¨ä¸ºä¾ï¼ï¼å¦æ没æï¼åä¸è®¾ç½®ï¼æ£å¼ç¯å¢å»ºè®®ä¸ç¹è¦é ç½®ï¼è®¾ç½®å®æ¶ä»»å¡ï¼
| [[email protected] ~]# crontab -l
# Time sync
0,10,20,30,40,50 * * * * /root/sync_time.sh
[[email protected] ~]# cat /root/sync_time.sh
#!/bin/bash
. /etc/profile
. /root/.bash_profile
ntpdate 10.10.10.10 ; hwclock -w
[[email protected] ~]# |
å½ç¶ï¼å¯ä»¥é ç½®NTPæ¶é´åæ¥æå¡ï¼åªéè¦ä¿è¯ç¸å ³æå¡å¨æ¶é´ä¸è´å³å¯ï¼
ä»»éä¸æºå¨åæºç«¯ï¼
cat /etc/ntp.conf
restrict default nomodify
server 127.127.1.0
fudge 127.127.1.0 stratum 10
å ¶å®æºå¨å客æ·ç«¯ï¼
cat /etc/ntp.conf
server 223.254.17.103
vi /etc/sysconfig/ntpd
SYNC_HWCLOCK=yes
设置æ¯å°æºå¨çNTPæå¡
chkconfig ntpd on
service ntpd restart
1.2.7.2 æ£æ¥å¹¶ç¡®è®¤æ¶åº
sed -i â/^ZONE=/cZONE=âAsia/Shanghaiââ /etc/sysconfig/clock
1.2.7.3 è°æ´ Limits.conf
ä¸è¿°è®¾ç½®å·²å æ¬(umlimit -c -d -n -v -f -u )ï¼
vim /etc/security/limits.confæ·»å 以ä¸å 容
dmdba soft nice 0
dmdba hard nice 0
dmdba soft as unlimited
dmdba hard as unlimited
dmdba soft fsize unlimited
dmdba hard fsize unlimited
dmdba soft nproc 65536
dmdba hard nproc 65536
dmdba soft nofile 65536
dmdba hard nofile 65536
dmdba soft core unlimited
dmdba hard core unlimited
dmdba soft data unlimited
dmdba hard data unlimited
:xä¿åéåº
注æäºé¡¹ï¼å¼ºè°ï¼ï¼å¦ææ该æ件ï¼/etc/security/limits.d/90-nproc.confï¼ä¹éè¦ä¿®æ¹ã该æ件主è¦éå¶ nprocï¼ä¼å çº§æ¯ /etc/security/limits.confé«ï¼å³ï¼å¦æ /etc/security/limits.d/90-nproc.conf è®¾ç½®äº nproc åæ°æ¶ï¼çæçæ¯/etc/security/limits.d/90-nproc.conf æ件ä¸çéå¶ï¼èä¸æ¯/etc/security/limits.conf çéå¶
vim /etc/security/limits.d/90-nproc.conf
* soft nproc 65536
1.2.7.4 è°æ´ Sysctl.confï¼å¿ åï¼
vim /etc/sysctl.conf vm.swappiness = 0
:xä¿åéåº
sysctl âp ç«å³çæ |
1.2.7.5 å ¶ä»è°æ´åå¤çï¼éåï¼
1.2.7.5.1 æ ¼å¼å - å大å°çéæ©
è¿å没æç¹æ®è¦æ±ï¼ç¨æ·èªè¡èèå³å¯ãåªæ¯å¯¹äºæ¡å¸¦å¤§å°ï¼å¦ææ¯OLAPå½¢çåºç¨ç³»ç»ï¼åºè¯¥éæ©å°½å¯è½å¤§çæ¡å¸¦å¤§å°ã
1.2.7.5.2 确认loginé ç½®
vim /etc/pam.d/login
æ·»å 以ä¸å 容
session required /lib64/security/pam_limits.so
session required pam_limits.so
:xä¿åéåº
1.2.7.5.3 è°æ´ Sysctl.conf
vim /etc/sysctl.conf
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.dirty_background_ratio = 3
vm.dirty_ratio = 80
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 100
:xä¿åéåº
Sysctl âp ç«å³çæ
1.2.7.5.4 å ³é selinux
|Setenforce 0
Vim /etc/sysconfig/selinux
å°SELINUXçå¼ç±é»è®¤çenforcingä¿®æ¹ä¸ºpermissive
:xä¿åéåº
1.2.7.5.5 â å¿ è¦çå·¥å ·å å®è£
å¦ä¸è½¯ä»¶å æªå®è£ ï¼ä¸ä¸å®å½±åæ°æ®åºçè¿è¡ä½¿ç¨ï¼ä½æ¯ä¸ºäºä¾¿äºçæ§åææ¥ï¼å»ºè®®å ¨é¨å®è£ ï¼
è¿æ§ç±»ï¼
#yum install vnc
#yum install xterm
#yum install ksh
#yum install pdksh
åæç±»ï¼
#yum install perf
#yum install kernel-devel
#yum install kernel
#yum install kernel-headers
#yum install gdbm
#yum install gdb
#yum install cmake
#yum install gdbm-devel
#yum install binutils
#yum install compat-libstdc+±33
#yum install elfutils-libelf
#yum install elfutils-libelf-devel
#yum install gcc
#yum install gcc-c++
#yum install glibc
#yum install glibc-common
#yum install glibc-devel
#yum install glibc-headers
#yum install libaio
#yum install libaio-devel
#yum install libgcc-4.1.2
#yum install libstdc++
#yum install libstdc+±devel
#yum install make
#yum install numactl-devel
è¿ç»´ç±»ï¼
#yum install dstat
#yum install expect
#yum install unzip
#yum install zip
#yum install sysstat
#yum install unixODBC
#yum install unixODBC-devel
1.2.7.5.6 æ¸ ç©ºé²ç«å¢çç¥
iptables âF Server iptables save
1.2.7.5.7 å®æ¶æ¸ ç cache
æ ¹æ®ä¸å¡ãåºæ¯æ åµï¼å¯ä»¥éæ©ä¸å¤©æ¸ çä¸æ¬¡æè åå°æ¶ãååéæ¸ çä¸æ¬¡ãä¸é¢æ¯ä¸ä¸ªåæå¡å¨å¯¼å ¥å¤§éæ°æ®çåºæ¯ï¼è®¾ç½®ä¸º
ååé æ¸ çä¸æ¬¡ï¼
# sync cache for load large date to dmserver
0,10,20,30,40,50 * * * * /root/sync_cache.sh
[[email protected] ~]# cat sync_cache.sh
sync
sync
echo 1 > /proc/sys/vm/drop_caches
[[email protected] ~]# |
1.2.7.5.8 ç¦ç¨éæ大页
cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
âecho âecho never > /sys/kernel/mm/redhat_transparent_hugepage/enabledâ >>
/etc/rc.local
vi /etc/rc.d/rc.local
if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
chmod +x /etc/rc.d/rc.local
1.2.7.5. 9 æ£æ¥å¹¶ç¡®è®¤è¯è¨è®¾ç½®
ä¸å»ºè®®éç¨GBKï¼é¿å 达梦è¿è¡æ¥å¿ä¸åºç°ä¹±ç ï¼å½±ååæã
echo âexport LANG=en_US.UTF-8â >> /etc/profile
1.2.7.5.10 æ£æ¥å¹¶è°æ´sshdé ç½®
为äºè§£å³æäºæ åµä¸sshè¿æ¥æ ¢çé®é¢
sed -i â/^#GSSAPIAuthentication/cGSSAPIAuthentication noâ /etc/ssh/sshd_config
sed -i â/^GSSAPIAuthentication/cGSSAPIAuthentication noâ /etc/ssh/sshd_config
sed -i â/^#UseDNS/cUseDNS noâ /etc/ssh/sshd_config
sed -i â/^UseDNS/cUseDNS noâ /etc/ssh/sshd_config
1.2.7.5.11 设置ç£çé¢è¯»
echo â/sbin/blockdev --setra 16386 /dev/sdbâ >> /etc/rc.local
注ï¼è¾¾æ¢¦æ°æ®åºæ°æ®æ件æå¨ååºä¸º/dev/sdb1
1.2.7.5.12 è°æ´coreæ件çæè·¯å¾
vi /etc/sysctl.conf
kernel.core_pattern = core #é»è®¤å¼ï¼å¨æ§è¡ç®å½ä¸
kernel.core_pattern=/v7000_backup/%e.core.%p ä¿®æ¹ /etc/sysctl.conf å¹¶ä¸ sysctl -a ä¸å¥½ä½¿ï¼éè¿ä¸é¢å½ä»¤åå³æ¶çæä¸
/sbin/sysctl -w kernel.core_pattern=/v7000_backup/%e.core.%p
说æï¼è¿éè¦æ±coreæ件çæè·¯å¾çå¯ç¨ç©ºé´å¤§å°ï¼è¦å¤§äºç©çå å大å°ã
2 DM8é¨ç½²å®æ½æµç¨
2.1 æµç¨
- è§åé¨ç½²å®æ½ä¿¡æ¯ã
- è§åç¨åºå®è£ è·¯å¾ã
- è§åæ°æ®åºå®ä¾æ°æ®åæ¾è·¯å¾ã
- è§åå½æ¡£è·¯å¾ã
- è§åå¤ä»½è·¯å¾
- è§åå®ä¾é ç½®
- 使ç¨å®è£ å è¿è¡å®è£ ã
- å建å®ä¾æ°æ®åºã
- é ç½®åºå
- é ç½®å®ä¾å
- é 置端å£å·
- é ç½®æ°æ®åºåæ°
- é ç½®æ°æ®åº
- 设置å½æ¡£
- 设置å®æ¶å¤ä»½
- 设置å®æ¶æ¸ çå¤ä»½
- 设置å®æ¶æ¸ çå½æ¡£ã
- ä¼åæ°æ®åº
- åæ°ä¼å
- å ¼å®¹æ§åæ°
- 管çæ°æ®åº
- ä¿®æ¹è¶ 级管çåç¨æ·
- å¢å æ°æ®åºç®¡çå
- å¢å ç³»ç»ç®¡çå
- å¢å æ®éç¨æ·
2.2 é¨ç½²è§å
ç³»ç»é ç½®è§å
å åå¤§å° | 128 |
---|---|
CPU | 64æ ¸ |
ç£çç©ºé´ | 1T |
è·¯å¾è§å
å®è£ è·¯å¾ | /home/dmdba/dmdbms |
---|---|
æ°æ®åºå®ä¾è·¯å¾ | /data/dmdata |
å½æ¡£è·¯å¾ | /data/dmdata/arch |
å¤ä»½è·¯å¾ | /data/dmdata/bak |
å®ä¾è§å
åºå | DMOA |
---|---|
å®ä¾å | DMOA |
端å£å· | 5236 |
é¡µå¤§å° | 16 |
ç¼ç æ ¼å¼ | GB18030 |
大å°åææ | æ¯ |
é ç½®è§å
å½æ¡£æä»¶å¤§å° | 512 |
---|---|
å½æ¡£æå¤§å¤§å° | 10240 |
å®æ¶å¤ä»½æ¶é´é´é | 24h |
å®æ¶æ¸ çå¤ä»½æ¶é´èå´ | 24*7 |
å®æ¶æ¸ çå½æ¡£æ¶é´èå´ | 24*3 |
ä¼åè§å
æ°æ®åºå åå æ»å åæ¯ä¾ | 80% |
---|---|
æ°æ®åºå ¼å®¹æ§åæ° | å ¼å®¹ORACLE |
管çè§å
è¶ çº§ç®¡çåè´¦å·å¯ç | SYSDBA/SYSDBA123 |
---|---|
æ°å»ºæ°æ®åºç®¡çå | DMDBA/GZ_DMDBA2021 |
æ°å»ºç¨æ·ç®¡çå | USERDBA/User_dba |
æ°å»ºç³»ç»ç¨æ·1 | USER_OA |
æ°å»ºç³»ç»ç¨æ·2 | USER_MAIL |
3 å®è£ æ°æ®åºè¿ç¨
3.1 å¾å½¢åå®è£
-
å建ç»åç¨æ·
groupadd dinstall
useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
passwd dmdba
ï¼æ ¹æ®ç³»ç»æ示è¿è¡å¯ç 设置ï¼
-
æ£æ¥æä½ç³»ç»éå¶ï¼ulimit - aï¼åç£ç大å°æ¯å¦ç¬¦å项ç®éæ±
åæ°ä½¿ç¨éå¶ï¼
Aãdata seg size
data seg size (kbytes, -d)
建议ç¨æ·è®¾ç½®ä¸º 1048576(å³ 1GB)以ä¸æ
unlimited(æ éå¶)ï¼æ¤åæ°è¿å°å°å¯¼è´æ°æ®åºå¯å¨å¤±è´¥ã
Bãfile size
file size(blocks, -f)
建议ç¨æ·è®¾ç½®ä¸º unlimited(æ éå¶)ï¼æ¤åæ°è¿å°å°å¯¼è´æ°æ®åºå®è£ æåå§å失败ã
Cã open files
open files(-n)
建议ç¨æ·è®¾ç½®ä¸º 65536 以ä¸æ unlimited(æ éå¶)ã
Dãvirtual memory
virtual memory (kbytes, -v)
建议ç¨æ·è®¾ç½®ä¸º 1048576(å³ 1GB)以ä¸æ
unlimited(æ éå¶)ï¼æ¤åæ°è¿å°å°å¯¼è´æ°æ®åºå¯å¨å¤±è´¥ã
å¦ æ ç¨ æ· é è¦ ä¸º å½ å å® è£ ç¨ æ· æ´ æ¹ ulimit ç èµ æº é å¶ ï¼ è¯· ä¿®
æ¹ æ 件/etc/security/limits.confã
-
ç»å®è£ å dmdbaæé并åæ¢ç¨æ·
chown dmdba:dinstall DMInstall.bin
chmod +x DMInstall.bin
su â dmdba
-
å®è£ æ°æ®åº
æ§è¡ï¼./ DMInstall.bin
Aãéæ©è¯è¨åæ¶åº
Bã欢è¿çé¢ Cã许å¯è¯åè®® Dãç»ä»¶ä¿¡æ¯ Eãéªè¯keyæ件Fãéæ©å®è£ æ¹å¼
DMå®è£ ç¨åºæä¾åç§å®è£ æ¹å¼ï¼âå ¸åå®è£ âãâæå¡å¨å®è£ âãâ客æ·ç«¯å®è£ âåâèªå®ä¹å®è£ âï¼ç¨æ·å¯æ ¹æ®å®é æ åµçµæ´»å°éæ©ãå¦ä¸å¾æ示ï¼
å ¸åå®è£ å æ¬ï¼æå¡å¨ã客æ·ç«¯ã驱å¨ãç¨æ·æåãæ°æ®åºæå¡ã
æå¡å¨å®è£ å æ¬ï¼æå¡å¨ã驱å¨ãç¨æ·æåãæ°æ®åºæå¡ã
客æ·ç«¯å®è£ å æ¬ï¼å®¢æ·ç«¯ã驱å¨ãç¨æ·æåã
èªå®ä¹å®è£ å æ¬ï¼æ ¹æ®ç¨æ·éè¦å¾éç»ä»¶ï¼å¯ä»¥æ¯æå¡å¨ã客æ·ç«¯ã驱å¨ãç¨æ·æåãæ°æ®åºæå¡ä¸çä»»æç»åã
**Gãéæ©å®è£
ç®å½**
Hãå®è£
åå°ç»
Iãå®è£
Jãç¨rootæ§è¡ä»¥ä¸èæ¬
3.2 å½ä»¤è¡å®è£
- æ§è¡å®è£ æ件
[[email protected] test]$ ./DMInstall.bin -i
Please select the installerâs language (E/e:English C/c:Chinese) [E/e]:c
解åå®è£ ç¨åºâ¦
æ¯å¦è¾å ¥Keyæ件路å¾? (Y/y:æ¯ N/n:å¦) [Y/y]:n
æ¯å¦è®¾ç½®æ¶åº? (Y/y:æ¯ N/n:å¦) [Y/y]:
设置æ¶åº:
请éæ©è®¾ç½®æ¶åº 9:21
å®è£ ç±»å:
1 å ¸åå®è£
2 æå¡å¨
3 客æ·ç«¯
4 èªå®ä¹
请éæ©å®è£ ç±»åçæ°ååºå· [1 å ¸åå®è£ ]:1
æé空é´: 828M
请éæ©å®è£ ç®å½ [/home/dmdba/dmdbms]:/home/dmdba/dmdbms
å¯ç¨ç©ºé´: 13T
æ¯å¦ç¡®è®¤å®è£ è·¯å¾(/home/dmdba/dmdbms)? (Y/y:æ¯ N/n:å¦) [Y/y]:y
å®è£ åå°ç»
å®è£ ä½ç½®: /data/dmdata
æé空é´: 828M
å¯ç¨ç©ºé´: 13T
çæ¬ä¿¡æ¯:
æææ¥æ:
å®è£ ç±»å: å ¸åå®è£
æ¯å¦ç¡®è®¤å®è£ ? (Y/y:æ¯ N/n:å¦):y
2019-07-28 22:04:37
[INFO] å®è£ default 模åâ¦
2019-07-28 22:04:37
[INFO] å®è£ 达梦æ°æ®åºâ¦
2019-07-28 22:04:39
[INFO] å®è£ server 模åâ¦
2019-07-28 22:04:39
[INFO] å®è£ client 模åâ¦
2019-07-28 22:04:39
[INFO] å®è£ drivers 模åâ¦
2019-07-28 22:04:39
[INFO] å®è£ manual 模åâ¦
2019-07-28 22:04:39
[INFO] å®è£ service 模åâ¦
2019-07-28 22:04:41
[INFO] 移å¨antæ¥å¿æ件ã
2019-07-28 22:04:41
[INFO] å®è£ 达梦æ°æ®åºå®æã
请以rootç³»ç»ç¨æ·æ§è¡å½ä»¤:
/home/dmdba/script/root/root_installer.sh
å®è£ ç»æ
- ç¨rootæ§è¡root_installer.shèæ¬ï¼æ°æ®åºå®è£ å³å¯å®æ
[[email protected] test]# /home/dmdba/script/root/root_installer.sh
ç§»å¨ /home/dmdba/bin/dm_svc.conf å°/etcç®å½
ä¿®æ¹æå¡å¨æé
å建DmAPServiceæå¡
å建æå¡(DmAPService)å®æ
å¯å¨DmAPServiceæå¡
4 åå§åæ°æ®åºå®ä¾è¿ç¨
4.1 å¾å½¢åå建å®ä¾åæå¡
1ãå¼å§åå§å
2ãå建ä¸ä¸ªæ°æ®åºå®ä¾
3ãéæ©ç®å½
4ãæè¦æ±è®¾ç½®æ°æ®åºååæ°æ®åºå®ä¾å称
5ã设置æ§å¶æ件ãæ°æ®æ件ç
6ã. æè¦æ±è®¾ç½®é¡µå¤§å°16ãå符éGB18030ã大å°åææ
7ãæè¦æ±è®¾å®sysdbaå¯ç
8ãæ¯å¦å建示ä¾åºï¼é»è®¤æ¯ä¸å建
9ãåå§åä¿¡æ¯
10ãå¼å§åå§å
11ãç¨rootç¨æ·è¿è¡
4.2 å½ä»¤è¡å建å®ä¾åæå¡
- æè¦æ±å建æ°æ®åºå®ä¾
[[email protected] bin]$ ./dminit path=/data/dmdata db_name=DMOA instance_name=DMOA
CHARSET=0 PAGE_SIZE=16 CASE_SENSITIVE=1 SYSDBA_PWD=SYSDBA123 port_num=5236
initdb V7.6.0.137-Build(2019.02.18-102954)ENT
db version: 0x7000a
file dm.key not found, use default license!
License will expire on 2020-02-18
log file path: /data/dmdata/DMOA/DMOA01.log
log file path: /data/dmdata/DMOA/DMOA02.log
write to dir [/data/dmdata/DMOA].
create dm database success. 2019-07-29 10:45:36
- 注åæ°æ®åºæå¡
- åæ¢å°rootç¨æ·
- è¿å ¥å°/home/dmdba/script/root
- æ§è¡dm_service_installer.shæ件
[[email protected] root]# ./dm_service_installer.sh -t dmserver -dm_ini
/data/mdata/DMOA/dm.ini -p DMOAs
Created symlink from
/etc/systemd/system/multi-user.target.wants/DmServiceDMOA.service to
/usr/lib/systemd/system/DmServiceDMOA.service.
å建æå¡(DmServiceDMOA)å®æ
5 æå¡å¯å
5.1 å¾å½¢åæ¹å¼
- è¿å ¥å°/home/dmdba/dmdbms/tool
- æ§è¡èæ¬dmservice.sh
[å¤é¾å¾ç转å失败,æºç«å¯è½æé²çé¾æºå¶,建议å°å¾çä¿åä¸æ¥ç´æ¥ä¸ä¼ (img-bmoHJn9r-1640412163608)(media/0834d2f4f0d5ee6e406a732554b91a87.png)]
5.2 å½ä»¤è¡æ¹å¼
[[email protected] test]# service DmServiceDMOA start
6 é ç½®è¿ç¨
6.1 é ç½®å½æ¡£æ件
â æè¦æ±é ç½®æ°æ®åºå½æ¡£ï¼æ¹å¼ä¸ï¼
- è¿å ¥å°æ°æ®æ件ç®å½ï¼/data/dmdata/DMOAï¼
- æå¼iniåæ°ï¼ARCH_INI=1ï¼
- é ç½®dmarch.iniæ件
Dãéå¯æ°æ®åºï¼å½æ¡£é ç½®å®æ
â¡æè¦æ±é ç½®æ°æ®åºå½æ¡£ï¼æ¹å¼äºï¼
ä¿®æ¹æ°æ®åºä¸º MOUNT ç¶æã
SQL>ALTER DATABASE MOUNT;
é ç½®æ¬å°å½æ¡£ã
SQL>ALTER DATABASE ADD ARCHIVELOG âDEST = /data/dmdata/arch, TYPE = local,
FILE_SIZE = 512, SPACE_LIMIT = 10240â;
å¼å¯å½æ¡£æ¨¡å¼ã
SQL>ALTER DATABASE ARCHIVELOG;
ä¿®æ¹æ°æ®åºä¸º OPEN ç¶æã
SQL>ALTER DATABASE OPEN;
6.2 é ç½®æ°æ®åºå®æ¶å¤ä»½
â å½ä»¤è¡æ¹å¼
SP_INIT_JOB_SYS(1); --å¼å¯ä»£çä½ä¸
âå®æ¶æ¯å¤©è¿è¡ï¼è¿è¡å¢éå¤ä»½(ç½å¤©)
call
SP_CREATE_JOB(âJOB_INCREMENT_BAK_TIMELY_DAYâ,1,0,ââ,0,0,ââ,0,âå®æ¶å¢éå¤ä»½â);
call SP_JOB_CONFIG_START(âJOB_INCREMENT_BAK_TIMELY_DAYâ);
call SP_ADD_JOB_STEP(âJOB_INCREMENT_BAK_TIMELY_DAYâ, âSTEP_INCREMENT_BAKâ,
5, â/data/dmdata/bakâ, 1, 2, 0, 0, NULL, 0);
âcall SP_ADD_JOB_STEP(âJOB_INCREMENT_BAK_TIMELY_DAYâ, âSTEP_INCREMENT_BAKâ, 5,
â/data/dmdata/bakâ, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(âJOB_INCREMENT_BAK_TIMELY_DAYâ,
âSCHEDULE_INCREMENT_BAKâ, 1, 1, 1, 0, 0, â12:05:56â, NULL, â2019-07-29
21:05:57â, NULL, ââ);
call SP_JOB_CONFIG_COMMIT(âJOB_INCREMENT_BAK_TIMELY_DAYâ);
- æ¯å¨æ¸ çå¤ä»½æ件
âå®æ¶æ¯å¨æ¥è¿è¡ï¼å é¤å7天çå¤ä»½ï¼å æ¬å ¨éåå¢é
call SP_CREATE_JOB(âJOB_DEL_BAK_TIMELYâ,1,0,ââ,0,0,ââ,0,âå®æ¶å é¤å¤ä»½â);
call SP_JOB_CONFIG_START(âJOB_DEL_BAK_TIMELYâ);
call SP_ADD_JOB_STEP(âJOB_DEL_BAK_TIMELYâ, âSTEP_DEL_BAKâ, 0,
âSP_BATCH_DEL_BAK(ââDAMENGââ, ââââ, 1, sysdate-7, -1);â, 1, 2, 0, 0, NULL,
0); --BAK1å¤ä»½
call SP_ADD_JOB_SCHEDULE(âJOB_DEL_BAK_TIMELYâ, âSCHEDULE_DEL_BAKâ, 1, 2, 1,
1, 0, â00:05:56â, NULL, â2019-07-29 21:05:57â, NULL, ââ);
call SP_JOB_CONFIG_COMMIT(âJOB_DEL_BAK_TIMELYâ);
- æ¯ä¸å¤©æ¸ çä¸æ¬¡å½æ¡£æ件
âå®æ¶æ¯å¨æ¥è¿è¡ï¼å é¤å3天çå½æ¡£æ¥å¿
âcall SP_DROP_JOB(âJOB_DEL_ARCH_TIMELYâ);
call SP_CREATE_JOB(âJOB_DEL_ARCH_TIMELYâ,1,0,ââ,0,0,ââ,0,âå®æ¶å é¤å¤ä»½â);
call SP_JOB_CONFIG_START(âJOB_DEL_ARCH_TIMELYâ);
call SP_ADD_JOB_STEP(âJOB_DEL_ARCH_TIMELYâ, âSTEP_DEL_ARCHâ, 0,
âSF_ARCHIVELOG_DELETE_BEFORE_TIME(SYSDATE - 3);â, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(âJOB_DEL_ARCH_TIMELYâ, âSCHEDULE_DEL_ARCHâ, 1, 2,
1, 1, 0, â00:05:56â, NULL, â2019-07-29 21:05:57â, NULL, ââ);
call SP_JOB_CONFIG_COMMIT(âJOB_DEL_ARCH_TIMELYâ);
â¡å¾å½¢åæ¹å¼
7 ä¼åè¿ç¨
æ ¹æ®æ°æ®åºæå¡å¨é ç½®æ åµä¿®æ¹å ä¸ªå ³é®ç INI
åæ°ï¼å ååæ¥ç¡¬ä»¶æ§è½ï¼ç»åºå ä¸ªå ³é®åæ°çæ¨èé ç½®ã
达梦æ°æ®åºå®è£ å®æåéè¦å¯¹ä¸äºå½±åæ§è½çå ³é®åæ°è¿è¡é ç½®ï¼å 为å®è£ ç¨åºç»åºçé»è®¤é ç½®æ¯æ¯è¾ä¿å®çï¼ç¹å«æ¯å¨é ç½®è¾é«çæ°æ®åºæå¡å¨ä¸ï¼æ æ³éå¤åæ¥åºç¡¬ä»¶æ§è½ã
éè¦è°æ´çé ç½®åæ°å æ¬ä»¥ä¸å 个æ¹é¢ï¼å åç¸å ³åæ°ï¼IO ç¸å ³åæ°ï¼CPU ç¸å ³åæ°ï¼
æ¬èéè¿ä¸ä¸ªå ·ä½çä¾åæ¥ç»åºä¸äºæ¨èé ç½®ã
8 管çè¿ç¨
8.1 å¾å½¢åæ¹å¼
è¿å ¥å°/home/dmdba/dmdbms/toolç®å½ä¸ï¼æå¼managerï¼å³å¯è¿è¡æ°æ®åºç®¡çæä½
8.2 å½ä»¤è¡æ¹å¼
[[email protected] bin]$ ./disql SYSDBA/SYSDBA123:5236
æå¡å¨[LOCALHOST:5236]:å¤äºæ®éæå¼ç¶æ
ç»å½ä½¿ç¨æ¶é´: 5.729(毫ç§)
disql V7.6.0.137-Build(2019.02.18-102954)ENT
SQL>
8.3 å建ç¨æ·å表空é´
å å建表空é´
å建ç¨æ·ï¼è¡¨ç©ºé´åç´¢å¼è¡¨ç©ºé´é£ä¸æ éæ©ååå建ç表空é´ï¼å¨è¿ä¸ªç¨æ·ä¸å»ºçææç对象é½ä¼é»è®¤æ¾å¨è¿ä¸ªè¡¨ç©ºé´ä¸ã
æåºç¨åºæ¯éæ©æé
社åºå°åï¼https://eco.dameng.com