没有合适的资源?快使用搜索试试~ 我知道了~
首页GaussDB 100 官方文档:华为分布式数据库详解
GaussDB 100 官方文档:华为分布式数据库详解
5星 · 超过95%的资源 需积分: 37 112 下载量 193 浏览量
更新于2024-07-15
2
收藏 7.57MB PDF 举报
"华为GaussDB 100 官方文档.pdf" 是一份详细的产品文档,主要介绍了华为的高斯数据库系统GaussDB100。这份文档包含了产品描述、软件安装指南、关键特性和功能等方面的信息,旨在帮助用户理解和使用GaussDB100。
1. **产品描述**:
- **产品概述**:GaussDB100是一款高性能、高可用性的分布式数据库系统,设计用于支持大规模数据处理和分析。
- **产品定位**:它主要面向企业级大数据场景,适用于需要高效数据处理和事务处理的应用。
- **产品特点**:包括Share-nothing架构、数据分布式存储、数据分区、全并行查询处理、高性能事务处理、工作负载管理、高可靠事务处理和闪回等功能。
- **系统架构**:支持单机、主备以及分布式等多种部署模式,满足不同业务需求。
- **应用场景**:可能包括金融、电信、零售等行业的数据分析、报表生成、在线事务处理(OLTP)等。
- **运行环境**:文档中未详细列出,但通常需要特定的操作系统、硬件配置和网络环境。
- **技术指标**:未具体给出,一般包括吞吐量、响应时间、并发处理能力等。
- **基本功能**和**关键特性**:涵盖了数据库的核心操作,如数据存储、查询优化、事务处理等。
- **高可用性**:通过主备部署和分布式架构,提供高可靠性保障,确保业务连续性。
2. **软件安装指南**:
- **安装简介**:提供了单机、主备一主一备和一主两备的部署方案,指导用户根据实际需求选择合适的安装方式。
- **部署方案**:详细步骤可能包括系统准备、软件下载、安装配置、启动服务等。
3. **注意事项**:
- 文档版权归属华为技术有限公司,未经许可不得擅自复制传播。
- 文档内容仅供参考,实际产品和服务受华为商业合同约束。
- 随着产品版本升级,文档内容会定期更新。
- 华为提供了技术支持,包括客户服务邮箱和电话,方便用户获取帮助。
华为GaussDB 100是一款针对大规模数据处理的分布式数据库系统,具备高性能、高可用性、灵活部署等优势,适合对数据处理有高要求的企业。通过官方文档,用户可以深入理解其设计理念、系统架构及操作流程,从而有效地在实际环境中部署和使用GaussDB100。
8.2.1.70 WSR_LATCH.....................................................................................................................................................701
8.2.1.71 WSR_LIBRARYCACHE...................................................................................................................................701
8.2.1.72 WSR_LONGSQL...............................................................................................................................................702
8.2.1.73 WSR_LOCK_OBJECT...................................................................................................................................... 702
8.2.1.74 WSR_SEGMENT...............................................................................................................................................703
8.2.1.75 WSR_SQL_LIST................................................................................................................................................703
8.2.1.76 WSR_SQL_LIST_PLAN................................................................................................................................... 704
8.2.1.77 WSR_SQLPLAN................................................................................................................................................704
8.2.1.78 WSR_SQLTEXT................................................................................................................................................ 704
8.2.1.79 WSR_TRANSACTION..................................................................................................................................... 705
8.2.1.80 WSR_WAITSTAT.............................................................................................................................................. 705
8.2.2 DBA 视图................................................................................................................................................................705
8.2.2.1 DB_DB_LINKS................................................................................................................................................... 710
8.2.2.2 DB_IND_STATISTICS........................................................................................................................................ 710
8.2.2.3 DB_JOBS............................................................................................................................................................. 712
8.2.2.4 DB_TAB_MODIFICATIONS.............................................................................................................................. 712
8.2.2.5 DB_USERS.......................................................................................................................................................... 713
8.2.2.6 DB_USER_SYS_PRIVS......................................................................................................................................714
8.2.2.7 ADM_ARGUMENTS.......................................................................................................................................... 714
8.2.2.8 ADM_BACKUP_SET..........................................................................................................................................715
8.2.2.9 ADM_COL_COMMENTS.................................................................................................................................. 716
8.2.2.10 ADM_CONSTRAINTS..................................................................................................................................... 716
8.2.2.11 ADM_DATA_FILES.......................................................................................................................................... 718
8.2.2.12 ADM_DBLINK_TABLES................................................................................................................................. 719
8.2.2.13 ADM_DBLINK_TAB_COLUMNS...................................................................................................................720
8.2.2.14 ADM_DEPENDENCIES................................................................................................................................... 721
8.2.2.15 ADM_FREE_SPACE......................................................................................................................................... 721
8.2.2.16 ADM_HISTOGRAMS.......................................................................................................................................722
8.2.2.17 ADM_HIST_DBASEGMENTS........................................................................................................................ 722
8.2.2.18 ADM_HIST_INSTANCE_SNAP...................................................................................................................... 723
8.2.2.19 ADM_HIST_LATCH......................................................................................................................................... 724
8.2.2.20 ADM_HIST_LIBRARYCACHE....................................................................................................................... 724
8.2.2.21 ADM_HIST_LOCK_OBJECT.......................................................................................................................... 725
8.2.2.22 ADM_HIST_LONGSQL................................................................................................................................... 725
8.2.2.23 ADM_HIST_PARAMETER.............................................................................................................................. 726
8.2.2.24 ADM_HIST_SEGMENT................................................................................................................................... 727
8.2.2.25 ADM_HIST_SESSION_EVENTS.................................................................................................................... 727
8.2.2.26 ADM_HIST_SESSION_SQL............................................................................................................................ 728
8.2.2.27 ADM_HIST_SNAPSHOT................................................................................................................................. 729
8.2.2.28 ADM_HIST_SQLAREA....................................................................................................................................730
8.2.2.29 ADM_HIST_SQLPLAN.................................................................................................................................... 731
8.2.2.30 ADM_HIST_SQLTEXT.....................................................................................................................................732
GaussDB 100
产品文档 目 录
文档版本 01 (2019-10-24) 版权所有 © 华为技术有限公司 xv
8.2.2.31 ADM_HIST_SYSSTAT..................................................................................................................................... 732
8.2.2.32 ADM_HIST_SYSTEM...................................................................................................................................... 732
8.2.2.33 ADM_HIST_SYSTEM_EVENT....................................................................................................................... 733
8.2.2.34 ADM_HIST_TRANSACTION..........................................................................................................................734
8.2.2.35 ADM_HIST_WAITSTAT...................................................................................................................................734
8.2.2.36 ADM_HIST_WR_CONTROL...........................................................................................................................734
8.2.2.37 ADM_INDEXES................................................................................................................................................735
8.2.2.38 ADM_IND_COLUMNS.................................................................................................................................... 737
8.2.2.39 ADM_IND_PARTITIONS................................................................................................................................. 737
8.2.2.40 ADM_IND_STATISTICS.................................................................................................................................. 739
8.2.2.41 ADM_JOBS........................................................................................................................................................740
8.2.2.42 ADM_JOBS_RUNNING................................................................................................................................... 741
8.2.2.43 ADM_OBJECTS................................................................................................................................................ 741
8.2.2.44 ADM_2PC_PENDING...................................................................................................................................... 742
8.2.2.45 ADM_PART_COL_STATISTICS......................................................................................................................743
8.2.2.46 ADM_PART_KEY_COLUMNS........................................................................................................................744
8.2.2.47 ADM_PART_STORE.........................................................................................................................................744
8.2.2.48 ADM_PART_TABLES.......................................................................................................................................745
8.2.2.49 ADM_PROCEDURES.......................................................................................................................................745
8.2.2.50 ADM_PROFILES.............................................................................................................................................. 746
8.2.2.51 ADM_ROLES.................................................................................................................................................... 747
8.2.2.52 ADM_ROLE_PRIVS......................................................................................................................................... 747
8.2.2.53 ADM_SEGMENTS............................................................................................................................................747
8.2.2.54 ADM_SEQUENCES..........................................................................................................................................748
8.2.2.55 ADM_SOURCE................................................................................................................................................. 748
8.2.2.56 ADM_SYNONYMS.......................................................................................................................................... 749
8.2.2.57 ADM_SYS_PRIVS............................................................................................................................................ 749
8.2.2.58 ADM_TABLES.................................................................................................................................................. 750
8.2.2.59 ADM_TABLESPACES...................................................................................................................................... 752
8.2.2.60 ADM_TAB_COLS............................................................................................................................................. 752
8.2.2.61 ADM_TAB_COLUMNS....................................................................................................................................753
8.2.2.62 ADM_TAB_COL_STATISTICS........................................................................................................................755
8.2.2.63 ADM_TAB_COMMENTS.................................................................................................................................756
8.2.2.64 ADM_TAB_DISTRIBUTE................................................................................................................................756
8.2.2.65 ADM_TAB_MODIFICATIONS........................................................................................................................ 756
8.2.2.66 ADM_TAB_PARTITIONS.................................................................................................................................757
8.2.2.67 ADM_TAB_PRIVS............................................................................................................................................759
8.2.2.68 ADM_TAB_STATISTICS..................................................................................................................................760
8.2.2.69 ADM_TRIGGERS............................................................................................................................................. 761
8.2.2.70 ADM_USERS.................................................................................................................................................... 761
8.2.2.71 ADM_VIEWS.................................................................................................................................................... 763
8.2.2.72 ADM_VIEW_COLUMNS.................................................................................................................................763
GaussDB 100
产品文档 目 录
文档版本 01 (2019-10-24) 版权所有 © 华为技术有限公司 xvi
8.2.3 用户视图................................................................................................................................................................. 764
8.2.3.1 DB_ARGUMENTS..............................................................................................................................................767
8.2.3.2 DB_COL_COMMENTS...................................................................................................................................... 769
8.2.3.3 DB_CONS_COLUMNS...................................................................................................................................... 769
8.2.3.4 DB_CONSTRAINTS........................................................................................................................................... 770
8.2.3.5 DB_DBLINK_TABLES.......................................................................................................................................772
8.2.3.6 DB_DBLINK_TAB_COLUMNS........................................................................................................................ 772
8.2.3.7 DB_DEPENDENCIES.........................................................................................................................................773
8.2.3.8 DB_DIRECTORIES.............................................................................................................................................773
8.2.3.9 DB_DISTRIBUTE_RULES.................................................................................................................................774
8.2.3.10 DB_DIST_RULE_COLS................................................................................................................................... 774
8.2.3.11 DB_HISTOGRAMS...........................................................................................................................................775
8.2.3.12 DB_INDEXES....................................................................................................................................................776
8.2.3.13 DB_IND_COLUMNS........................................................................................................................................ 778
8.2.3.14 DB_IND_PARTITIONS.....................................................................................................................................778
8.2.3.15 DB_NODE_INFO.............................................................................................................................................. 780
8.2.3.16 DB_OBJECTS....................................................................................................................................................780
8.2.3.17 DB_PART_COL_STATISTICS..........................................................................................................................781
8.2.3.18 DB_PART_KEY_COLUMNS........................................................................................................................... 782
8.2.3.19 DB_PART_STORE............................................................................................................................................ 783
8.2.3.20 DB_PART_TABLES.......................................................................................................................................... 783
8.2.3.21 DB_PROCEDURES...........................................................................................................................................784
8.2.3.22 DB_SEQUENCES..............................................................................................................................................785
8.2.3.23 DB_SOURCE.....................................................................................................................................................785
8.2.3.24 DB_SYNONYMS.............................................................................................................................................. 786
8.2.3.25 DB_TABLES......................................................................................................................................................786
8.2.3.26 DB_TAB_COLS.................................................................................................................................................788
8.2.3.27 DB_TAB_COLUMNS....................................................................................................................................... 789
8.2.3.28 DB_TAB_COL_STATISTICS............................................................................................................................791
8.2.3.29 DB_TAB_COMMENTS.................................................................................................................................... 792
8.2.3.30 DB_TAB_DISTRIBUTE....................................................................................................................................792
8.2.3.31 DB_TAB_PARTITIONS.................................................................................................................................... 793
8.2.3.32 DB_TAB_STATISTICS......................................................................................................................................794
8.2.3.33 DB_TRIGGERS................................................................................................................................................. 796
8.2.3.34 DB_VIEWS........................................................................................................................................................ 796
8.2.3.35 DB_VIEW_COLUMNS.....................................................................................................................................797
8.2.3.36 DB_VIEW_DEPENDENCIES.......................................................................................................................... 797
8.2.3.37 ROLE_SYS_PRIVS........................................................................................................................................... 798
8.2.3.38 MY_ARGUMENTS...........................................................................................................................................798
8.2.3.39 MY_COL_COMMENTS................................................................................................................................... 799
8.2.3.40 MY_CONSTRAINTS........................................................................................................................................ 799
8.2.3.41 MY_CONS_COLUMNS....................................................................................................................................801
GaussDB 100
产品文档 目 录
文档版本 01 (2019-10-24) 版权所有 © 华为技术有限公司 xvii
8.2.3.42 MY_DEPENDENCIES...................................................................................................................................... 802
8.2.3.43 MY_FREE_SPACE............................................................................................................................................802
8.2.3.44 MY_HISTOGRAMS..........................................................................................................................................803
8.2.3.45 MY_INDEXES...................................................................................................................................................803
8.2.3.46 MY_IND_COLUMNS....................................................................................................................................... 805
8.2.3.47 MY_IND_PARTITIONS....................................................................................................................................806
8.2.3.48 MY_IND_STATISTICS..................................................................................................................................... 807
8.2.3.49 MY_JOBS.......................................................................................................................................................... 808
8.2.3.50 MY_OBJECTS...................................................................................................................................................809
8.2.3.51 MY_PART_COL_STATISTICS.........................................................................................................................810
8.2.3.52 MY_PART_KEY_COLUMNS...........................................................................................................................811
8.2.3.53 MY_PART_STORE............................................................................................................................................811
8.2.3.54 MY_PART_TABLES..........................................................................................................................................811
8.2.3.55 MY_PROCEDURES..........................................................................................................................................812
8.2.3.56 MY_ROLE_PRIVS............................................................................................................................................ 813
8.2.3.57 MY_SEGMENTS...............................................................................................................................................813
8.2.3.58 MY_SEQUENCES.............................................................................................................................................814
8.2.3.59 MY_SOURCE.................................................................................................................................................... 814
8.2.3.60 MY_SQL_MAPS............................................................................................................................................... 815
8.2.3.61 MY_SYNONYMS............................................................................................................................................. 815
8.2.3.62 MY_SYS_PRIVS............................................................................................................................................... 816
8.2.3.63 MY_TABLES..................................................................................................................................................... 816
8.2.3.64 MY_TAB_COLS................................................................................................................................................818
8.2.3.65 MY_TAB_COLUMNS.......................................................................................................................................819
8.2.3.66 MY_TAB_COL_STATISTICS...........................................................................................................................820
8.2.3.67 MY_TAB_COMMENTS................................................................................................................................... 821
8.2.3.68 MY_TAB_DISTRIBUTE...................................................................................................................................821
8.2.3.69 MY_TAB_MODIFICATIONS........................................................................................................................... 822
8.2.3.70 MY_TAB_PARTITIONS................................................................................................................................... 823
8.2.3.71 MY_TAB_PRIVS...............................................................................................................................................824
8.2.3.72 MY_TAB_STATISTICS.....................................................................................................................................825
8.2.3.73 MY_TRIGGERS................................................................................................................................................ 826
8.2.3.74 MY_USERS....................................................................................................................................................... 827
8.2.3.75 MY_VIEWS....................................................................................................................................................... 827
8.2.3.76 MY_VIEW_COLUMNS....................................................................................................................................828
8.2.4 动态性能视图......................................................................................................................................................... 828
8.2.4.1 NLS_SESSION_PARAMETERS........................................................................................................................ 832
8.2.4.2 DV_ALL_TRANS................................................................................................................................................832
8.2.4.3 DV_ARCHIVED_LOGS..................................................................................................................................... 833
8.2.4.4 DV_ARCHIVE_DEST_STATUS........................................................................................................................ 836
8.2.4.5 DV_ARCHIVE_GAPS........................................................................................................................................ 837
8.2.4.6 DV_ARCHIVE_THREADS................................................................................................................................ 837
GaussDB 100
产品文档 目 录
文档版本 01 (2019-10-24) 版权所有 © 华为技术有限公司 xviii
8.2.4.7 DV_BACKUP_PROCESSES.............................................................................................................................. 838
8.2.4.8 DV_BUFFER_INDEX_STATS........................................................................................................................... 839
8.2.4.9 DV_BUFFER_PAGE_STATS..............................................................................................................................839
8.2.4.10 DV_BUFFER_POOLS.......................................................................................................................................840
8.2.4.11 DV_BUFFER_POOL_STATS............................................................................................................................840
8.2.4.12 DV_CONTROL_FILES.....................................................................................................................................841
8.2.4.13 DV_CONNPOOL_STATS................................................................................................................................. 841
8.2.4.14 DV_DATABASE................................................................................................................................................ 843
8.2.4.15 DV_DATA_FILES............................................................................................................................................. 845
8.2.4.16 DV_OBJECT_CACHE...................................................................................................................................... 845
8.2.4.17 DV_DC_POOLS................................................................................................................................................ 846
8.2.4.18 DV_DC_RANKINGS........................................................................................................................................ 847
8.2.4.19 DV_DYNAMIC_VIEWS...................................................................................................................................847
8.2.4.20 DV_DYNAMIC_VIEW_COLS.........................................................................................................................848
8.2.4.21 DV_FREE_SPACE.............................................................................................................................................848
8.2.4.22 DV_GLOBAL_TRANSACTIONS....................................................................................................................849
8.2.4.23 DV_GMA........................................................................................................................................................... 849
8.2.4.24 DV_GMA_STATS..............................................................................................................................................850
8.2.4.25 DV_HA_SYNC_INFO.......................................................................................................................................852
8.2.4.26 DV_HBA............................................................................................................................................................ 853
8.2.4.27 DV_INSTANCE................................................................................................................................................. 854
8.2.4.28 DV_RUNNING_JOBS.......................................................................................................................................854
8.2.4.29 DV_LATCHS..................................................................................................................................................... 854
8.2.4.30 DV_LIBRARY_CACHE....................................................................................................................................855
8.2.4.31 DV_LOCKS....................................................................................................................................................... 856
8.2.4.32 DV_LOCKED_OBJECTS................................................................................................................................. 856
8.2.4.33 DV_LOG_FILES................................................................................................................................................857
8.2.4.34 DV_LONG_SQL................................................................................................................................................858
8.2.4.35 DV_STANDBYS................................................................................................................................................860
8.2.4.36 DV_ME.............................................................................................................................................................. 860
8.2.4.37 DV_MEM_STATS............................................................................................................................................. 861
8.2.4.38 DV_OPEN_CURSORS......................................................................................................................................861
8.2.4.39 DV_PARAMETERS.......................................................................................................................................... 863
8.2.4.40 DV_PL_MANAGER..........................................................................................................................................863
8.2.4.41 DV_PL_REFSQLS.............................................................................................................................................864
8.2.4.42 DV_REACTOR_POOLS................................................................................................................................... 865
8.2.4.43 DV_REPL_STATUS.......................................................................................................................................... 866
8.2.4.44 DV_RESOURCE_MAP.....................................................................................................................................866
8.2.4.45 DV_RSRC_CONTROL_GROUP......................................................................................................................867
8.2.4.46 DV_SEGMENT_STATS.................................................................................................................................... 867
8.2.4.47 DV_SESSIONS.................................................................................................................................................. 868
8.2.4.48 DV_SESSION_EVENTS...................................................................................................................................872
GaussDB 100
产品文档 目 录
文档版本 01 (2019-10-24) 版权所有 © 华为技术有限公司 xix
剩余941页未读,继续阅读
点击了解资源详情
点击了解资源详情
点击了解资源详情
2021-10-14 上传
2021-10-26 上传
2021-10-17 上传
2020-11-15 上传
2019-11-15 上传
2021-09-07 上传
扛菜刀的你
- 粉丝: 2
- 资源: 10
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Python中快速友好的MessagePack序列化库msgspec
- 大学生社团管理系统设计与实现
- 基于Netbeans和JavaFX的宿舍管理系统开发与实践
- NodeJS打造Discord机器人:kazzcord功能全解析
- 小学教学与管理一体化:校务管理系统v***
- AppDeploy neXtGen:无需代理的Windows AD集成软件自动分发
- 基于SSM和JSP技术的网上商城系统开发
- 探索ANOIRA16的GitHub托管测试网站之路
- 语音性别识别:机器学习模型的精确度提升策略
- 利用MATLAB代码让古董486电脑焕发新生
- Erlang VM上的分布式生命游戏实现与Elixir设计
- 一键下载管理 - Go to Downloads-crx插件
- Java SSM框架开发的客户关系管理系统
- 使用SQL数据库和Django开发应用程序指南
- Spring Security实战指南:详细示例与应用
- Quarkus项目测试展示柜:Cucumber与FitNesse实践
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功