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:
ValueMeaning
YESThe engine is supported and is active
DEFAULTLike YES, plus this is the default engine
NOThe engine is not supported
DISABLEDThe 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:

  1. SELECT * from INFORMATION_SCHEMA.ENGINES\G

The output is as follows:

  1. *************************** 1. row ***************************
  2.       engine: mito
  3.      support: DEFAULT
  4.      comment: Storage engine for time-series data
  5. transactions: NO
  6.           xa: NO
  7.   savepoints: NO
  8. *************************** 2. row ***************************
  9.       engine: metric
  10.      support: YES
  11.      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
  12. transactions: NO
  13.           xa: NO
  14.   savepoints: NO