達夢數據庫性能優(yōu)化

定　價：￥98.00

作　者：	曾昭文等
出版社：	電子工業(yè)出版社
叢編項：
標　簽：	暫缺

購買這本書可以去

ISBN：	9787121431135	出版時間：	2022-04-01	包裝：	平塑
開本：	16開	頁數：	232	字數：

內容簡介

　　本書以達夢數據庫DM8 為藍本，圍繞DM8 性能為什么優(yōu)化、誰來優(yōu)化、優(yōu)化什么、何時優(yōu)化、優(yōu)化到什么程度等問題進行詳細介紹，從DM8 體系架構入手，分析了DM8 的運行機制，從DM8 的實例優(yōu)化、I/O 優(yōu)化、SQL 語句優(yōu)化3 個方面詳細地介紹了影響DM8 性能的核心問題。全書共6 章，內容包括DM8 性能優(yōu)化概述、DM8體系架構、DM8 調優(yōu)診斷工具、DM8 實例優(yōu)化、DM8 I/O 優(yōu)化和DM8 SQL 語句優(yōu)化等。同時，本書還將DM8 參數配置文件相關參數、DM8 系統(tǒng)數據字典和DM8 常用動態(tài)性能視圖作為附錄，便于廣大讀者查閱。本書內容實用、示例豐富、語言通俗、格式規(guī)范，可以作為計算機、數據庫等專業(yè)的教材，也可以作為工程技術人員的參考用書。

作者簡介

　　曾昭文，教授，主要從事數據工程和知識管理相關研究，主持軍隊重大科研項目10余項，先后獲軍隊科技進步二等獎1項、三等獎多項，獲軍隊教學成果二等獎1項，出版專著4部。

圖書目錄

第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 數據庫全面健康檢查···································································7
1.2.2 優(yōu)化階段設計············································································7
1.2.3 數據庫配置···············································································8
1.2.4 添加新的應用程序······································································8
1.2.5 運行過程的優(yōu)化·········································································8
1.2.6 生產環(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 數據庫重演（REPLAY） ··························································.11
1.3.4 檢查數據物理一致性································································.12
1.3.5 優(yōu)化數據庫布局······································································.12
1.4 數據庫優(yōu)化誤區(qū)··············································································.13
第2 章 DM8 體系架構·················································································.14
2.1 總體構成·······················································································.14
2.1.1 數據庫··················································································.15
2.1.2 實例·····················································································.15
2.2 物理存儲結構·················································································.15
2.2.1 配置文件···············································································.16
2.2.2 控制文件···············································································.16
2.2.3 數據文件···············································································.17
2.2.4 日志文件················································································18
2.2.5 備份文件················································································21
2.2.6 數據重演文件··········································································21
2.3 邏輯存儲結構···················································································21
2.3.1 表空間···················································································21
2.3.2 段·························································································24
2.3.3 簇·························································································25
2.3.4 頁·························································································26
2.3.5 記錄······················································································27
2.4 DM8 內存結構··················································································27
2.4.1 內存池···················································································27
2.4.2 緩沖區(qū)···················································································28
2.4.3 排序區(qū)···················································································30
2.4.4 哈希區(qū)···················································································31
2.5 DM8 線程結構··················································································31
2.5.1 監(jiān)聽線程·······················2