YMatrix

• Introduction
• Architecture
• SSB Benchmark
• TPC-H Benchmark
• Database Features
• Conventions

Quick Start

• Quick Install
• Simulate Time Series Scenarios
• Time Series Scenario Practice
• Loading Performance Experience
• Basic Management

Standard Cluster Deployment

• Online Cluster Deployment
• Major Version Upgrade
• Minor Version Upgrade
• Deployment under Kubernetes
• Cluster Uninstall

Data Modeling

• Time Series Data Model
• Time Series Modeling Approach
• Vehicle Networking Best Practices
• Smarthome Best Practice

Connecting to The database

• Client Connection
• Code Connection

Data Writing

• Data Writing Characteristics in Time Series Scenarios
• Write Tool
• Write Scenarios

Data Migration

• Migration Approach
• Migration Tool
• Migrating Data from Greenplum to YMatrix 5
• Migrating Data from YMatrix 4 to YMatrix 5

Data Query

• Basic Query
• Advanced Query
• Federal Query

Maintenance and Monitoring

• Daily Management
• Automated Partition Management
• Routine Vacuuming
• Statistics Query
• Backup and Restore
• Crash Recover
• Cluster Expansion
• Query Monitoring
• Grafana Monitoring
• Prometheus Monitoring
• etcd Monitoring
• Health Monitoring
• Alert Settings

Performance Tuning

• Overview
• Approach
• SQL Tuning - Query Processing
• SQL Tuning - Understanding Query Plans

Troubleshooting

• Log
• Field Preservation Tools - minirepro
• Core Packaging tool - packcore

Reference Guide

• Tool Guide
• Data Type
• Storage Engine
• Execution Engine
• Mirror Distribution Policy
• Continuous Aggregation
• Sliding Window
• Grafana Interpretation
• Prometheus Interpretation
• Glossary

SQL Reference

• ABORT
• ALTER_DATABASE
• ALTER_EXTENSION
• ALTER_EXTERNAL_TABLE
• ALTER_FOREIGN_DATA_WRAPPER
• ALTER_FOREIGN_TABLE
• ALTER_FUNCTION
• ALTER_INDEX
• ALTER_RESOURCE_GROUP
• ALTER_RESOURCE_QUEUE
• ALTER_ROLE
• ALTER_RULE
• ALTER_SCHEMA
• ALTER_SEQUENCE
• ALTER_SERVER
• ALTER_TABLE
• ALTER_TABLESPACE
• ALTER_TYPE
• ALTER_USER_MAPPING
• ALTER_VIEW
• ANALYZE
• BEGIN
• CHECKPOINT
• COMMIT
• COPY
• CREATE_DATABASE
• CREATE_EXTENSION
• CREATE_EXTERNAL_TABLE
• CREATE_FOREIGN_DATA_WRAPPER
• CREATE_FOREIGN_TABLE
• CREATE_FUNCTION
• CREATE_INDEX
• CREATE_RESOURCE_GROUP
• CREATE_RESOURCE_QUEUE
• CREATE_ROLE
• CREATE_RULE
• CREATE_SCHEMA
• CREATE_SEGMENT_SET
• CREATE_SEQUENCE
• CREATE_SERVER
• CREATE_TABLE
• CREATE_TABLE_AS
• CREATE_TABLESPACE
• CREATE_TYPE
• CREATE_USER_MAPPING
• CREATE_VIEW
• DELETE
• DROP_DATABASE
• DROP_EXTENSION
• DROP_EXTERNAL_TABLE
• DROP_FOREIGN_DATA_WRAPPER
• DROP_FOREIGN_TABLE
• DROP_FUNCTION
• DROP_INDEX
• DROP_RESOURCE_GROUP
• DROP_RESOURCE_QUEUE
• DROP_ROLE
• DROP_RULE
• DROP_SCHEMA
• DROP_SEGMENT_SET
• DROP_SEQUENCE
• DROP_SERVER
• DROP_TABLE
• DROP_TABLESPACE
• DROP_TYPE
• DROP_USER_MAPPING
• DROP_VIEW
• END
• EXPLAIN
• GRANT
• INSERT
• LOAD
• LOCK
• REINDEX
• RELEASE_SAVEPOINT
• RESET
• REVOKE
• ROLLBACK_TO_SAVEPOINT
• ROLLBACK
• SAVEPOINT
• SELECT INTO
• SET ROLE
• SET TRANSACTION
• SET
• SHOW
• START TRANSACTION
• TRUNCATE
• UPDATE
• VACUUM

FAQ

• Architecture FAQ
• Install FAQ
• SQL Query FAQ
• MatrixGate FAQ
• Maintenance FAQ
• Alert FAQ
• PXF FAQ
• PLPython FAQ
• Performance FAQ