- Docs Home
- About TiDB
- Quick Start
- Develop- Overview
- Quick Start- Build a TiDB Cluster in TiDB Cloud (Developer Tier)
- CRUD SQL in TiDB
- Build a Simple CRUD App with TiDB
 
- Example Applications
- Connect to TiDB
- Design Database Schema
- Write Data
- Read Data
- Transaction
- Optimize
- Troubleshoot
- Reference
- Cloud Native Development Environment
- Third-party Support
 
- Deploy- Software and Hardware Requirements
- Environment Configuration Checklist
- Plan Cluster Topology
- Install and Start
- Verify Cluster Status
- Test Cluster Performance
 
- Migrate- Overview
- Migration Tools
- Migration Scenarios- Migrate from Aurora
- Migrate MySQL of Small Datasets
- Migrate MySQL of Large Datasets
- Migrate and Merge MySQL Shards of Small Datasets
- Migrate and Merge MySQL Shards of Large Datasets
- Migrate from CSV Files
- Migrate from SQL Files
- Migrate from One TiDB Cluster to Another TiDB Cluster
- Migrate from TiDB to MySQL-compatible Databases
 
- Advanced Migration
 
- Integrate- Overview
- Integration Scenarios
 
- Maintain
- Monitor and Alert
- Troubleshoot- TiDB Troubleshooting Map
- Identify Slow Queries
- Analyze Slow Queries
- SQL Diagnostics
- Identify Expensive Queries Using Top SQL
- Identify Expensive Queries Using Logs
- Statement Summary Tables
- Troubleshoot Hotspot Issues
- Troubleshoot Increased Read and Write Latency
- Save and Restore the On-Site Information of a Cluster
- Troubleshoot Cluster Setup
- Troubleshoot High Disk I/O Usage
- Troubleshoot Lock Conflicts
- Troubleshoot TiFlash
- Troubleshoot Write Conflicts in Optimistic Transactions
- Troubleshoot Inconsistency Between Data and Indexes
 
- Performance Tuning- Tuning Guide
- Configuration Tuning- System Tuning
- Software Tuning
 
- SQL Tuning- Overview
- Understanding the Query Execution Plan
- SQL Optimization Process- Overview
- Logic Optimization
- Physical Optimization
- Prepare Execution Plan Cache
 
- Control Execution Plans
 
 
- Tutorials
- TiDB Tools- Overview
- Use Cases
- Download
- TiUP- Documentation Map
- Overview
- Terminology and Concepts
- Manage TiUP Components
- FAQ
- Troubleshooting Guide
- Command Reference- Overview
- TiUP Commands
- TiUP Cluster Commands- Overview
- tiup cluster audit
- tiup cluster check
- tiup cluster clean
- tiup cluster deploy
- tiup cluster destroy
- tiup cluster disable
- tiup cluster display
- tiup cluster edit-config
- tiup cluster enable
- tiup cluster help
- tiup cluster import
- tiup cluster list
- tiup cluster patch
- tiup cluster prune
- tiup cluster reload
- tiup cluster rename
- tiup cluster replay
- tiup cluster restart
- tiup cluster scale-in
- tiup cluster scale-out
- tiup cluster start
- tiup cluster stop
- tiup cluster template
- tiup cluster upgrade
 
- TiUP DM Commands- Overview
- tiup dm audit
- tiup dm deploy
- tiup dm destroy
- tiup dm disable
- tiup dm display
- tiup dm edit-config
- tiup dm enable
- tiup dm help
- tiup dm import
- tiup dm list
- tiup dm patch
- tiup dm prune
- tiup dm reload
- tiup dm replay
- tiup dm restart
- tiup dm scale-in
- tiup dm scale-out
- tiup dm start
- tiup dm stop
- tiup dm template
- tiup dm upgrade
 
 
- TiDB Cluster Topology Reference
- DM Cluster Topology Reference
- Mirror Reference Guide
- TiUP Components
 
- PingCAP Clinic Diagnostic Service
- TiDB Operator
- Dumpling
- TiDB Lightning
- TiDB Data Migration- About TiDB Data Migration
- Architecture
- Quick Start
- Deploy a DM cluster
- Tutorials
- Advanced Tutorials
- Maintain- Cluster Upgrade
- Tools
- Performance Tuning
- Manage Data Sources
- Manage Tasks
- Export and Import Data Sources and Task Configurations of Clusters
- Handle Alerts
- Daily Check
 
- Reference- Architecture
- Command Line
- Configuration Files
- OpenAPI
- Compatibility Catalog
- Secure
- Monitoring and Alerts
- Error Codes
- Glossary
 
- Example
- Troubleshoot
- Release Notes
 
- Backup & Restore (BR)
- Point-in-Time Recovery
- TiDB Binlog
- TiCDC
- Dumpling
- sync-diff-inspector
- TiSpark
 
- Reference- Cluster Architecture
- Key Monitoring Metrics
- Secure
- Privileges
- SQL- SQL Language Structure and Syntax
- SQL Statements- ADD COLUMN
- ADD INDEX
- ADMIN
- ADMIN CANCEL DDL
- ADMIN CHECKSUM TABLE
- ADMIN CHECK [TABLE|INDEX]
- ADMIN SHOW DDL [JOBS|QUERIES]
- ADMIN SHOW TELEMETRY
- ALTER DATABASE
- ALTER INDEX
- ALTER INSTANCE
- ALTER PLACEMENT POLICY
- ALTER TABLE
- ALTER TABLE COMPACT
- ALTER TABLE SET TIFLASH MODE
- ALTER USER
- ANALYZE TABLE
- BACKUP
- BATCH
- BEGIN
- CHANGE COLUMN
- COMMIT
- CHANGE DRAINER
- CHANGE PUMP
- CREATE [GLOBAL|SESSION] BINDING
- CREATE DATABASE
- CREATE INDEX
- CREATE PLACEMENT POLICY
- CREATE ROLE
- CREATE SEQUENCE
- CREATE TABLE LIKE
- CREATE TABLE
- CREATE USER
- CREATE VIEW
- DEALLOCATE
- DELETE
- DESC
- DESCRIBE
- DO
- DROP [GLOBAL|SESSION] BINDING
- DROP COLUMN
- DROP DATABASE
- DROP INDEX
- DROP PLACEMENT POLICY
- DROP ROLE
- DROP SEQUENCE
- DROP STATS
- DROP TABLE
- DROP USER
- DROP VIEW
- EXECUTE
- EXPLAIN ANALYZE
- EXPLAIN
- FLASHBACK TABLE
- FLUSH PRIVILEGES
- FLUSH STATUS
- FLUSH TABLES
- GRANT <privileges>
- GRANT <role>
- INSERT
- KILL [TIDB]
- LOAD DATA
- LOAD STATS
- MODIFY COLUMN
- PREPARE
- RECOVER TABLE
- RENAME INDEX
- RENAME TABLE
- REPLACE
- RESTORE
- REVOKE <privileges>
- REVOKE <role>
- ROLLBACK
- SAVEPOINT
- SELECT
- SET DEFAULT ROLE
- SET [NAMES|CHARACTER SET]
- SET PASSWORD
- SET ROLE
- SET TRANSACTION
- SET [GLOBAL|SESSION] <variable>
- SHOW ANALYZE STATUS
- SHOW [BACKUPS|RESTORES]
- SHOW [GLOBAL|SESSION] BINDINGS
- SHOW BUILTINS
- SHOW CHARACTER SET
- SHOW COLLATION
- SHOW [FULL] COLUMNS FROM
- SHOW CONFIG
- SHOW CREATE PLACEMENT POLICY
- SHOW CREATE SEQUENCE
- SHOW CREATE TABLE
- SHOW CREATE USER
- SHOW DATABASES
- SHOW DRAINER STATUS
- SHOW ENGINES
- SHOW ERRORS
- SHOW [FULL] FIELDS FROM
- SHOW GRANTS
- SHOW INDEX [FROM|IN]
- SHOW INDEXES [FROM|IN]
- SHOW KEYS [FROM|IN]
- SHOW MASTER STATUS
- SHOW PLACEMENT
- SHOW PLACEMENT FOR
- SHOW PLACEMENT LABELS
- SHOW PLUGINS
- SHOW PRIVILEGES
- SHOW [FULL] PROCESSSLIST
- SHOW PROFILES
- SHOW PUMP STATUS
- SHOW SCHEMAS
- SHOW STATS_HEALTHY
- SHOW STATS_HISTOGRAMS
- SHOW STATS_META
- SHOW STATUS
- SHOW TABLE NEXT_ROW_ID
- SHOW TABLE REGIONS
- SHOW TABLE STATUS
- SHOW [FULL] TABLES
- SHOW [GLOBAL|SESSION] VARIABLES
- SHOW WARNINGS
- SHUTDOWN
- SPLIT REGION
- START TRANSACTION
- TABLE
- TRACE
- TRUNCATE
- UPDATE
- USE
- WITH
 
- Data Types
- Functions and Operators- Overview
- Type Conversion in Expression Evaluation
- Operators
- Control Flow Functions
- String Functions
- Numeric Functions and Operators
- Date and Time Functions
- Bit Functions and Operators
- Cast Functions and Operators
- Encryption and Compression Functions
- Locking Functions
- Information Functions
- JSON Functions
- Aggregate (GROUP BY) Functions
- Window Functions
- Miscellaneous Functions
- Precision Math
- Set Operations
- List of Expressions for Pushdown
- TiDB Specific Functions
 
- Clustered Indexes
- Constraints
- Generated Columns
- SQL Mode
- Table Attributes
- Transactions
- Garbage Collection (GC)
- Views
- Partitioning
- Temporary Tables
- Cached Tables
- Character Set and Collation
- Placement Rules in SQL
- System Tables- mysql
- INFORMATION_SCHEMA- Overview
- ANALYZE_STATUS
- CLIENT_ERRORS_SUMMARY_BY_HOST
- CLIENT_ERRORS_SUMMARY_BY_USER
- CLIENT_ERRORS_SUMMARY_GLOBAL
- CHARACTER_SETS
- CLUSTER_CONFIG
- CLUSTER_HARDWARE
- CLUSTER_INFO
- CLUSTER_LOAD
- CLUSTER_LOG
- CLUSTER_SYSTEMINFO
- COLLATIONS
- COLLATION_CHARACTER_SET_APPLICABILITY
- COLUMNS
- DATA_LOCK_WAITS
- DDL_JOBS
- DEADLOCKS
- ENGINES
- INSPECTION_RESULT
- INSPECTION_RULES
- INSPECTION_SUMMARY
- KEY_COLUMN_USAGE
- METRICS_SUMMARY
- METRICS_TABLES
- PARTITIONS
- PLACEMENT_POLICIES
- PROCESSLIST
- REFERENTIAL_CONSTRAINTS
- SCHEMATA
- SEQUENCES
- SESSION_VARIABLES
- SLOW_QUERY
- STATISTICS
- TABLES
- TABLE_CONSTRAINTS
- TABLE_STORAGE_STATS
- TIDB_HOT_REGIONS
- TIDB_HOT_REGIONS_HISTORY
- TIDB_INDEXES
- TIDB_SERVERS_INFO
- TIDB_TRX
- TIFLASH_REPLICA
- TIKV_REGION_PEERS
- TIKV_REGION_STATUS
- TIKV_STORE_STATUS
- USER_PRIVILEGES
- VARIABLES_INFO
- VIEWS
 
- METRICS_SCHEMA
 
 
- UI- TiDB Dashboard- Overview
- Maintain
- Access
- Overview Page
- Cluster Info Page
- Top SQL Page
- Key Visualizer Page
- Metrics Relation Graph
- SQL Statements Analysis
- Slow Queries Page
- Cluster Diagnostics
- Monitoring Page
- Search Logs Page
- Instance Profiling
- Session Management and Configuration
- FAQ
 
 
- CLI
- Command Line Flags
- Configuration File Parameters
- System Variables
- Storage Engines
- Telemetry
- Errors Codes
- Table Filter
- Schedule Replicas by Topology Labels
 
- FAQs
- Release Notes- All Releases
- Release Timeline
- TiDB Versioning
- TiDB Installation Packages
- v6.2
- v6.1
- v6.0
- v5.4
- v5.3
- v5.2
- v5.1
- v5.0
- v4.0
- v3.1
- v3.0
- v2.1
- v2.0
- v1.0
 
- Glossary
Command-line Flags
This document introduces DM's command-line flags.
DM-master
--advertise-addr
- The external address of DM-master used to receive client requests
- The default value is "{master-addr}"
- Optional flag. It can be in the form of "domain-name:port"
--advertise-peer-urls
- The external address for communication between DM-master nodes
- The default value is "{peer-urls}"
- Optional flag. It can be in the form of "http(s)://domain-name:port"
--config
- The configuration file path of DM-master
- The default value is ""
- Optional flag
--data-dir
- The directory used to store data of DM-master
- The default value is "default.{name}"
- Optional flag
--initial-cluster
- The "{node name}={external address}"list used to bootstrap DM-master cluster
- The default value is "{name}={advertise-peer-urls}"
- This flag needs to be specified if the joinflag is not specified. A configuration example of a 3-node cluster is"dm-master-1=http://172.16.15.11:8291,dm-master-2=http://172.16.15.12:8291,dm-master-3=http://172.16.15.13:8291"
--join
- The existing cluster's advertise-addrlist when a DM-master node joins this cluster
- The default value is ""
- This flag needs to be specified if the initial-clusterflag is not specified. Suppose a new node joins a cluster that has 2 nodes, a configuration example is"172.16.15.11:8261,172.16.15.12:8261"
--log-file
- The output file name of the log
- The default value is ""
- Optional flag
-L
- The log level
- The default value is "info"
- Optional flag
--master-addr
- The address on which DM-master listens to the client's requests
- The default value is ""
- Required flag
--name
- The name of a DM-master node
- The default value is "dm-master-{hostname}"
- Required flag
--peer-urls
- The listening address for communications between DM-master nodes
- The default value is "http://127.0.0.1:8291"
- Required flag
DM-worker
--advertise-addr
- The external address of DM-worker used to receive client requests
- The default value is "{worker-addr}"
- Optional flag. It can be in the form of "domain-name:port"
--config
- The configuration file path of DM-worker
- The default value is ""
- Optional flag
--join
- The {advertise-addr}list of DM-master nodes in a cluster when a DM-worker registers to this cluster
- The default value is ""
- Required flag. A configuration example of 3-node (DM-master node) cluster is "172.16.15.11:8261,172.16.15.12:8261,172.16.15.13:8261"
--log-file
- The output file name of the log
- The default value is ""
- Optional flag
-L
- The log level
- The default value is "info"
- Optional flag
--name
- The name of a DM-worker node
- The default value is "{advertise-addr}"
- Required flag
--worker-addr
- The address on which DM-worker listens to the client's requests
- The default value is ""
- Required flag
dmctl
--config
- The configuration file path of dmctl
- The default value is ""
- Optional flag
--master-addr
- The {advertise-addr}of any DM-master node in the cluster to be connected by dmctl
- The default value is ""
- It is a required flag when dmctl interacts with DM-master
--encrypt
- Encrypts the plaintext database password into ciphertext
- The default value is ""
- When this flag is specified, it is only used to encrypt the plaintext without interacting with the DM-master
--decrypt
- Decrypts ciphertext encrypted with dmctl into plaintext
- The default value is ""
- When this flag is specified, it is only used to decrypt the ciphertext without interacting with the DM-master
Was this page helpful?