ADMIN is used to run administration functions.
ADMIN function(arg1, arg2, ...)
GreptimeDB provides some administration functions to manage the database and data:
flush_table(table_name) to flush a table's memtables into SST file by table name.flush_region(region_id) to flush a region's memtables into SST file by region id. Find the region id through PARTITIONS table.compact_table(table_name, [type], [options]) to schedule a compaction task for a table by table name, read compaction for more details.compact_region(region_id) to schedule a compaction task for a region by region id.migrate_region(region_id, from_peer, to_peer, [timeout]) to migrate regions between datanodes, please read the Region Migration.procedure_state(procedure_id) to query a procedure state by its id.flush_flow(flow_name) to flush a flow's output into the sink table.For example:
-- Flush the table test --
admin flush_table("test");
-- Schedule a compaction for table test --
admin compact_table("test");
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4