新書推薦:
《
如见你
》
售價:HK$
52.7
《
人格阴影 全新修订版,更正旧版多处问题。国际分析心理学协会(IAAP)主席力作
》
售價:HK$
68.8
《
560种野菜野果鉴别与食用手册
》
售價:HK$
68.9
《
中国官僚政治研究(一部洞悉中国政治制度演变的经典之作)
》
售價:HK$
64.4
《
锂电储能产品设计及案例详解
》
售價:HK$
113.9
《
首辅养成手册(全三册)(张晚意、任敏主演古装剧《锦绣安宁》原著小说)
》
售價:HK$
124.2
《
清洁
》
售價:HK$
66.7
《
组队:超级个体时代的协作方式
》
售價:HK$
79.4
|
內容簡介: |
本书以达梦数据库DM8 为蓝本,围绕DM8 性能为什么优化、谁来优化、优化什么、何时优化、优化到什么程度等问题进行详细介绍,从DM8 体系架构入手,分析了DM8 的运行机制,从DM8 的实例优化、I/O 优化、SQL 语句优化3 个方面详细地介绍了影响DM8 性能的核心问题。全书共6 章,内容包括DM8 性能优化概述、DM8体系架构、DM8 调优诊断工具、DM8 实例优化、DM8 I/O 优化和DM8 SQL 语句优化等。同时,本书还将DM8 参数配置文件相关参数、DM8 系统数据字典和DM8 常用动态性能视图作为附录,便于广大读者查阅。本书内容实用、示例丰富、语言通俗、格式规范,可以作为计算机、数据库等专业的教材,也可以作为工程技术人员的参考用书。
|
關於作者: |
曾昭文,教授,主要从事数据工程和知识管理相关研究,主持军队重大科研项目10余项,先后获军队科技进步二等奖1项、三等奖多项,获军队教学成果二等奖1项,出版专著4部。
|
目錄:
|
第1 章DM8 性能优化概述··············································································11.1 优化的基本概念·················································································11.1.1 为什么优化···············································································11.1.2 谁来优化··················································································21.1.3 优化什么··················································································21.1.4 何时优化··················································································41.1.5 优化到什么程度·········································································61.2 优化的基本思路·················································································71.2.1 数据库全面健康检查···································································71.2.2 优化阶段设计············································································71.2.3 数据库配置···············································································81.2.4 添加新的应用程序······································································81.2.5 运行过程的优化·········································································81.2.6 生产环境中优化的特殊问题··························································91.3 优化的基本步骤··············································································.101.3.1 问题分析···············································································.101.3.2 监控系统性能·········································································.111.3.3 数据库重演(REPLAY) ··························································.111.3.4 检查数据物理一致性································································.121.3.5 优化数据库布局······································································.121.4 数据库优化误区··············································································.13第2 章 DM8 体系架构·················································································.142.1 总体构成·······················································································.142.1.1 数据库··················································································.152.1.2 实例·····················································································.152.2 物理存储结构·················································································.152.2.1 配置文件···············································································.162.2.2 控制文件···············································································.162.2.3 数据文件···············································································.172.2.4 日志文件················································································182.2.5 备份文件················································································212.2.6 数据重演文件··········································································212.3 逻辑存储结构···················································································212.3.1 表空间···················································································212.3.2 段·························································································242.3.3 簇·························································································252.3.4 页·························································································262.3.5 记录······················································································272.4 DM8 内存结构··················································································272.4.1 内存池···················································································272.4.2 缓冲区···················································································282.4.3 排序区···················································································302.4.4 哈希区···················································································312.5 DM8 线程结构··················································································312.5.1 监听线程·······················2
|
|