Administration

This document addresses strategies and practices used in the operation of GreptimeDB systems and deployments.

Database/Cluster management

Runtime information

For example, find all the region id of a table:

  1. SELECT greptime_partition_id FROM PARTITIONS WHERE table_name = 'monitor'

Find the distribution of all regions in a table:

  1. SELECT b.peer_id as datanode_id,
  2. a.greptime_partition_id as region_id
  3. FROM information_schema.partitions a LEFT JOIN information_schema.region_peers b
  4. ON a.greptime_partition_id = b.region_id
  5. WHERE a.table_name='monitor'
  6. ORDER BY datanode_id ASC

The INFORMATION_SCHEMA database provides access to system metadata, such as the name of a database or table, the data type of a column, etc. Please read the reference.

Data management

Best Practices