📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

Sign In Start for Free

Administration Commands

This page provides reference information for the system administration commands in TiDB Cloud Lake.

System Monitoring

Command	Description
SHOW PROCESSLIST	Display active queries and connections
SHOW METRICS	View system performance metrics
KILL	Terminate running queries or connections
RUST BACKTRACE	Debug Rust stack traces

Access Control

Command	Description
FLUSH PRIVILEGES	Force every query node to reload role and privilege metadata

Configuration Management

Command	Description
SET	Set global configuration parameters
UNSET	Remove configuration settings
SET VARIABLE	Manage user-defined variables
SHOW SETTINGS	Display current system settings

Function Management

Command	Description
SHOW FUNCTIONS	List built-in functions
SHOW USER FUNCTIONS	List user-defined functions
SHOW TABLE FUNCTIONS	List table-valued functions

Storage Maintenance

Command	Description
VACUUM TABLE	Reclaim storage space from tables
VACUUM DROP TABLE	Clean up dropped table data
VACUUM TEMP FILES	Remove temporary files
VACUUM VIRTUAL COLUMN	Remove obsolete virtual column files
SHOW INDEXES	Display table indexes

Dynamic Execution

Command	Description
EXECUTE IMMEDIATE	Execute dynamically constructed SQL statements

Was this page helpful?