達(dá)夢數(shù)據(jù)庫性能優(yōu)化

第1 章DM8 性能優(yōu)化概述··············································································1
1.1 優(yōu)化的基本概念·················································································1
1.1.1 為什么優(yōu)化···············································································1
1.1.2 誰來優(yōu)化··················································································2
1.1.3 優(yōu)化什么··················································································2
1.1.4 何時優(yōu)化··················································································4
1.1.5 優(yōu)化到什么程度·········································································6
1.2 優(yōu)化的基本思路·················································································7
1.2.1 數(shù)據(jù)庫全面健康檢查···································································7
1.2.2 優(yōu)化階段設(shè)計············································································7
1.2.3 數(shù)據(jù)庫配置···············································································8
1.2.4 添加新的應(yīng)用程序······································································8
1.2.5 運行過程的優(yōu)化·········································································8
1.2.6 生產(chǎn)環(huán)境中優(yōu)化的特殊問題··························································9
1.3 優(yōu)化的基本步驟··············································································.10
1.3.1 問題分析···············································································.10
1.3.2 監(jiān)控系統(tǒng)性能·········································································.11
1.3.3 數(shù)據(jù)庫重演（REPLAY） ··························································.11
1.3.4 檢查數(shù)據(jù)物理一致性································································.12
1.3.5 優(yōu)化數(shù)據(jù)庫布局······································································.12
1.4 數(shù)據(jù)庫優(yōu)化誤區(qū)··············································································.13
第2 章 DM8 體系架構(gòu)·················································································.14
2.1 總體構(gòu)成·······················································································.14
2.1.1 數(shù)據(jù)庫··················································································.15
2.1.2 實例·····················································································.15
2.2 物理存儲結(jié)構(gòu)·················································································.15
2.2.1 配置文件···············································································.16
2.2.2 控制文件···············································································.16
2.2.3 數(shù)據(jù)文件···············································································.17
2.2.4 日志文件················································································18
2.2.5 備份文件················································································21
2.2.6 數(shù)據(jù)重演文件··········································································21
2.3 邏輯存儲結(jié)構(gòu)···················································································21
2.3.1 表空間···················································································21
2.3.2 段·························································································24
2.3.3 簇·························································································25
2.3.4 頁·························································································26
2.3.5 記錄······················································································27
2.4 DM8 內(nèi)存結(jié)構(gòu)··················································································27
2.4.1 內(nèi)存池···················································································27
2.4.2 緩沖區(qū)···················································································28
2.4.3 排序區(qū)···················································································30
2.4.4 哈希區(qū)···················································································31
2.5 DM8 線程結(jié)構(gòu)··················································································31
2.5.1 監(jiān)聽線程·······················2