新書推薦:
《
美国小史(揭秘“美国何以成为美国”,理解美国的经典入门读物)
》
售價:HK$
79.4
《
中国古代北方民族史丛书——东胡史
》
售價:HK$
87.8
《
巨人传(插图珍藏本)
》
售價:HK$
705.6
《
地下(村上春树沙林毒气事件的长篇纪实)
》
售價:HK$
74.8
《
偿还:债务与财富的阴暗面
》
售價:HK$
78.2
《
清华大学藏战国竹简校释(壹):《命训》诸篇
》
售價:HK$
92.0
《
封建社会农民战争问题导论(光启文库)
》
售價:HK$
66.7
《
虚弱的反攻:开禧北伐
》
售價:HK$
92.0
|
內容簡介: |
本书以达梦数据库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
|
|