SHOW DB_DISCOVERY HEARTBEATS

Description

The SHOW DB_DISCOVERY HEARTBEATS syntax is used to query database discovery heartbeats for specified database.

Syntax

  1. ShowDatabaseDiscoveryType::=
  2. 'SHOW' 'DB_DISCOVERY' 'HEARTBEATS' ('FROM' databaseName)?
  3. databaseName ::=
  4. identifier

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

Return value description

ColumnDescription
nameDatabase discovery heartbeat name
propsDatabase discovery heartbeat properties

Example

  • Query database discovery heartbeats for specified database.
  1. SHOW DB_DISCOVERY HEARTBEATS FROM test1;
  1. mysql> SHOW DB_DISCOVERY HEARTBEATS FROM test1;
  2. +-------------------+---------------------------------+
  3. | name | props |
  4. +-------------------+---------------------------------+
  5. | group_0_heartbeat | {keep-alive-cron=0/5 * * * * ?} |
  6. +-------------------+---------------------------------+
  7. 1 row in set (0.00 sec)
  • Query database discovery heartbeats for current database.
  1. SHOW DB_DISCOVERY HEARTBEATS;
  1. mysql> SHOW DB_DISCOVERY HEARTBEATS;
  2. +-------------------+---------------------------------+
  3. | name | props |
  4. +-------------------+---------------------------------+
  5. | group_0_heartbeat | {keep-alive-cron=0/5 * * * * ?} |
  6. +-------------------+---------------------------------+
  7. 1 row in set (0.00 sec)

Reserved word

SHOW, DB_DISCOVERY, HEARTBEATS, FROM