SHOW VARIABLES - MatrixOne Docs

Skip to content

MatrixOne Docs

SHOW VARIABLES

English
中文简体

Initializing search

matrixorigin/matrixone

MatrixOne

MatrixOne Docs

matrixorigin/matrixone

MatrixOne
MatrixOne
- Home
- Overview
  Overview
  - MatrixOne Introduction
  - MatrixOne Feature List
  - MatrixOne Feature
    MatrixOne Feature
    
    HTAP
    
    Multi-Account
    
    Scalability
    
    Cost-Effective
    
    High Availability
    
    MySQL Compatibility
  - MatrixOne Architecture Design
    MatrixOne Architecture Design
    
    Architecture Design Overview
    
    Transactional Analytical Engine Architecture
    
    Detailed Logservice Architecture
    
    Logtail Protocol Architecture
    
    Transaction and Lock Mechanisms Architecture
    
    Detailed Proxy Architecture
    
    Detailed Caching and Hot-Cold Data Separation Architecture
    
    Detailed Stream Engine Architecture
  - What's New
- Getting Started
  Getting Started
  - Deploy standalone MatrixOne
    Deploy standalone MatrixOne
    
    Overview
    
    Deploy on macOS
    Deploy on macOS
    
    Building from source code
    
    Using binary package
    
    Using Docker
    
    Deploy on Linux
    Deploy on Linux
    
    Building from source code
    
    Using binary package
    
    Using Docker
  - Basic SQL
- Developing Guide
  Developing Guide
  - Connect to MatrixOne
    Connect to MatrixOne
    
    Connecting to MatrixOne with Database Client Tool
    
    Java connect to MatrixOne
    Java connect to MatrixOne
    
    Connect MatrixOne with JDBC
    
    Connect MatrixOne with Java ORMs
    
    Python connect to MatrixOne
    
    Connecting to MatrixOne with Golang
    
    MatrixOne SSL connection
  - Schema Design
    Schema Design
    
    Overview
    
    Create Database
    
    Create Table
    
    Create View
    
    Create Temporary Table
    
    Create Secondary Index
    
    Data Integrity
    Data Integrity
    
    Data Integrity Constraints Overview
    
    NOT NULL Constraints
    
    UNIQUE KEY Constraints
    
    PRIMARY KEY Constraints
    
    FOREIGN KEY Constraints
    
    AUTO INCREMENT Constraints
  - Write Data
    Write Data
    
    Import Data
    Import Data
    
    Insert
    
    Bulk Load
    Bulk Load
    
    Bulk Load Overview
    
    Load csv format data
    
    Load jsonlines format data
    
    Load data from S3
    
    Load data by using the `source`
    
    Update Data
    
    Delete Data
    
    Prepared
  - Export Data
    Export Data
    
    Export data by SELECT INTO
    
    Export data by MODUMP
  - Read Data
    Read Data
    
    Query Data from a Single Table
    
    Multi-table Join Queries
    
    Subquery
    
    Views
    
    Common Table Expression
    
    Window Function.
  - Account Design
    Account Design
    
    Multi-Account Overview
    
    Publish-Subscribe
  - Transactions
    Transactions
    
    General Transaction Overview
    
    Transaction by MatrixOne Server
    Transaction by MatrixOne Server
    
    Transaction Overview
    
    Explicit Transaction
    
    Implicit Transaction
    
    Pessimistic Transaction
    
    Optimistic Transaction
    
    Isolation Level
    
    MVCC
    
    How to use transaction
    How to use transaction
    
    User Guide
    
    Scenario
  - Application Developing Tutorials
    Application Developing Tutorials
    
    Java CRUD demo
    
    SpringBoot and JPA CRUD demo
    
    SpringBoot and MyBatis CRUD demo
    
    Python CRUD demo
    
    SQLAlchemy CRUD demo
    
    Golang CRUD demo
    
    Gorm CRUD demo
  - Ecological Tools
    Ecological Tools
    
    BI Tools
    BI Tools
    
    Visualizing MatrixOne Data with FineBI
    
    Visualizing MatrixOne Reports with Yonghong BI
    
    Visual Monitoring of MatrixOne with Superset
    
    ETL Tools
    ETL Tools
    
    Writing Data to MatrixOne Using SeaTunnel
    
    Writing Data to MatrixOne Using DataX
    
    Computing Engine
    Computing Engine
    
    Writing Batch data to MatrixOne Using Spark
    
    Writing Real-Time Data to MatrixOne Using Flink
    
    Scheduling Tools
    Scheduling Tools
    
    Connecting MatrixOne with DolphinScheduler
- Deploying
  Deploying
  - Plan MatrixOne Cluster Topology
    Plan MatrixOne Cluster Topology
    
    Cluster Topology Planning Overview
    
    Experience Environment Deployment Plan
    
    Minimum Production Environment Deployment Plan
    
    Recommended Production Environment Deployment Plan
  - MatrixOne distributed cluster deployment
  - Maintenance
    Maintenance
    
    Starting and stopping
    
    Updating
    
    Health check and resource monitoring
    
    Scaling
    
    Managing CN Groups with Proxy
    
    Import data from local Minio to MatrixOne
    
    Operator Management
- Maintenance
  Maintenance
  - Backup and Restore
    Backup and Restore
    
    MatrixOne Backup and Recovery Overview
    
    Backup and Recovery Concepts
    
    Backup and Restore by using mo-dump
  - Mount Data
    Mount Data
    
    Mount directory to Docker container
- Migrating
  Migrating
- Testing
  Testing
  - Performance Testing
    Performance Testing
    
    SSB Test with MatrixOne
    
    TPCH Test with MatrixOne
    
    TPCC Test with MatrixOne
  - Testing Tool
    Testing Tool
    
    MO-Tester
    
    MO-Tester Specification
- Performance Tuning
  Performance Tuning
  - SQL Performance Tuning Methods Overview
  - Understanding the Query Execution Plan
    Understanding the Query Execution Plan
    
    Query Execution Plan Overview
    
    Using EXPLAIN to learn the execution plan
    
    Explain Statements Using JOIN
    
    Explain Statements Using Subqueries
    
    Explain Statements Using Aggregation
    
    EXPLAIN Statements Using Views
  - Performance tuning best practices
    Performance tuning best practices
    
    Using Cluster by for performance tuning