Skip to content

ENGINES

ENGINES表提供了关于存储引擎的信息。当你需要检查 GreptimeDB 是否支持某个存储引擎或者查看默认的存储引擎时,该表非常有用。

ENGINES表包含以下列:

  • engine:存储引擎名称。
  • support:存储引擎的支持级别:
含义
YES支持且在使用中
DEFAULT支持且在使用中,且是默认的存储引擎
NO不支持
DISABLED支持但已被禁用
  • comment:存储引擎的简要描述。
  • transactions:存储引擎是否支持事务。
  • xa:存储引擎是否支持 XA 事务。
  • savepoints:存储引擎是否支持保存点。

例如:

sql
SELECT * from INFORMATION_SCHEMA.ENGINES\G
SELECT * from INFORMATION_SCHEMA.ENGINES\G

结果如下:

sql
*************************** 1. row ***************************
      engine: mito
     support: DEFAULT
     comment: Storage engine for time-series data
transactions: NO
          xa: NO
  savepoints: NO
*************************** 2. row ***************************
      engine: metric
     support: YES
     comment: Storage engine for observability scenarios, which is adept at handling a large number of small tables, making it particularly suitable for cloud-native monitoring
transactions: NO
          xa: NO
  savepoints: NO
*************************** 1. row ***************************
      engine: mito
     support: DEFAULT
     comment: Storage engine for time-series data
transactions: NO
          xa: NO
  savepoints: NO
*************************** 2. row ***************************
      engine: metric
     support: YES
     comment: Storage engine for observability scenarios, which is adept at handling a large number of small tables, making it particularly suitable for cloud-native monitoring
transactions: NO
          xa: NO
  savepoints: NO