Skip to content

Latest commit

 

History

History
45 lines (36 loc) · 1.44 KB

engines.md

File metadata and controls

45 lines (36 loc) · 1.44 KB
Raw

ENGINES

The ENGINES table provides information about storage engines. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is.

The ENGINES table has the following columns:

  • engine: the storage engine name.
  • support: the level of support for the storage engine:
Value Meaning
YES The engine is supported and is active
DEFAULT Like YES, plus this is the default engine
NO The engine is not supported
DISABLED The engine is supported but has been disabled
  • comment: A brief description of the storage engine.
  • transactions: Whether the storage engine supports transactions.
  • xa: Whether the storage engine supports XA transactions.
  • savepoints: Whether the storage engine supports savepoints.

For example:

SELECT * from INFORMATION_SCHEMA.ENGINES\G

The output is as follows:

*************************** 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