Skip to main content
The SHOW statement allows you to view configuration parameter values that control various aspects of your Ditto instance’s behavior.

Syntax

DQL
SHOW Syntax Diagram

SHOW ALL

Display all configuration parameters and their current values:
DQL

Filtering with LIKE

You can filter the parameters displayed using pattern matching:
DQL
The pattern supports:
  • % - Matches zero or more characters
  • _ - Matches exactly one character

Escape Characters

If you need to match literal % or _ characters in parameter names, use the ESCAPE clause:
DQL

SHOW Specific Parameter

Display the value of a single configuration parameter:
DQL

Common Configuration Parameters

Some frequently used configuration parameters include:
Use SHOW ALL to see the complete list of available configuration parameters and their current values in your Ditto instance.

Usage Examples

See Also