新書推薦:

《
纸上博物馆·达达主义:艺术的反抗(艺术简史,讽刺超前,社会政治矛盾,16开图文全彩,伽利玛原版引进)
》
售價:HK$
85.8

《
名画里的中国 (共7册) 汉宫春晓图/韩熙载夜宴图/唐宫仕女图/洛神赋图/西湖十景图/千里江山图/清
》
售價:HK$
294.8

《
江山胜迹:人文风景的建构与传承
》
售價:HK$
162.8

《
雅贼(偷天大盗斯特凡·布雷特维泽的双面人生)
》
售價:HK$
60.5

《
天下一统: 中国传统政治文化的再诠释
》
售價:HK$
85.8

《
探古论金--曾侯乙青铜器工艺图解
》
售價:HK$
437.8

《
死亡与右手(修订译本)
》
售價:HK$
63.8

《
东方美学口袋书 华夏青铜
》
售價:HK$
43.8
|
| 內容簡介: |
|
本书以达梦数据库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
|
|