新書推薦：
《
拯救免疫失衡
》
售價：NT$
254.0
《
收尸人
》
售價：NT$
332.0
《
大模型应用开发：RAG入门与实战
》
售價：NT$
407.0
《
不挨饿快速瘦的减脂餐
》
售價：NT$
305.0
《
形而上学与存在论之间：费希特知识学研究（守望者）（德国古典哲学研究译丛）
》
售價：NT$
504.0
《
卫宫家今天的饭9 附画集特装版（含漫画1本+画集1本+卫宫士郎购物清单2张+特制相卡1张）
》
售價：NT$
602.0
《
化妆品学原理
》
售價：NT$
254.0
《
万千教育学前·与幼儿一起解决问题：捕捉幼儿园一日生活中的教育契机
》
售價：NT$
214.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
|
|
購物車/收銀台(0) | 在線留言板
| 付款方式
| 聯絡我們
| 運費計算
| 幫助中心 |
加入書簽
HOME
新書上架
