TiDB Development Guide
  • TiDB Development Guide
  • Contributing to TiDB Development Guide
  • .github
    • pull_request_template
  • TiDB Development Guide
    • Summary
    • contribute-to-tidb
      • Cherry-pick a Pull Request
      • TiDB Code Style and Quality Guide
      • Committer Guide
      • Community Guideline
      • Contribute Code
      • Contribute to TiDB
      • Issue Triage
      • Make a Proposal
      • Miscellaneous Topics
      • Release Notes Language Style Guide
      • Report an Issue
      • Review a Pull Request
      • Write Document
    • extending-tidb
      • Add a function
      • Extending TiDB
    • get-started
      • Get the code, build, and run
      • Commit the code and submit a pull request
      • Debug and profile
      • Install Golang
      • Get Started
      • run-and-debug-integration-tests
      • Setup an IDE
      • Write and run unit tests
    • project-management
      • Project Management
      • Release Train Model
      • TiDB Versioning
    • system-tables
      • System tables
      • slow_query
    • understand-tidb
      • 1PC
      • Async Commit
      • Cost-based Optimization
      • DDL - Data Definition Language / Schema change handling
      • DML
      • DQL
      • Execution
      • Implementation of Typical Operators
      • Implementation of Vectorized Execution
      • Introduction of TiDB Architecture
      • Lock Resolver
      • Memory Management Mechanism
      • MVCC Garbage Collection
      • Optimistic Transaction
      • Parallel Execution Framework
      • Parser
      • Pessimistic Transaction
      • Plan Cache
      • Planner
      • Plugin
      • Privilege
      • Rule-based Optimization
      • Session
      • SQL Plan Management
      • Table Statistics
      • The Life cycle of a Statement
      • transaction-on-tikv
      • Transaction
      • system-tables
        • System tables
        • information_schema
          • information_schema
          • slow_query
Powered by GitBook
On this page

Was this helpful?

  1. TiDB Development Guide
  2. understand-tidb
  3. system-tables

System tables

There are multiple types of system tables:

  • mysql schema: There are mostly real tables stored on TiKV

  • information_schema: These tables are generated on request and not stored on disk.

  • performance_schema: These tables are generated on request and not stored on disk.

  • metrics_schema: These are metrics from Prometheus, not real tables.

  • SYS: these are views etc to make performance_schema easier to use.

See also the docs:

  • TiDB mysql schema

  • TiDB information_schema

  • TiDB performance_schema

  • TiDB sys schema

  • TiDB metrics_schema

  • MySQL performance_schema

  • MySQL information_schema

  • MySQL sys schema

  • MySQL mysql schema

Previoussystem-tablesNextinformation_schema

Last updated 2 months ago

Was this helpful?