Webinar | The New MariaDB Enterprise Platform for Agentic AI, Analytics, and Cloud
Register Now
LogoLogo
CtrlK
Download MariaDBContact Us
  • Home
  • MariaDB Platform
  • Server
  • MaxScale
  • Analytics
  • Galera Cluster
  • Connectors
  • Tools
  • MariaDB Cloud
  • Release Notes
  • General Resources
  • MariaDB Server Documentation
  • Quickstart Guides
  • Server Usage
  • Server Management
  • Security
  • Architecture
  • Clients & Utilities
  • HA & Performance
  • Reference
    • SQL Structure
    • SQL Statements
      • Comment Syntax
      • Account Management
      • Administrative Statements
        • BINLOG
        • CACHE INDEX
        • DESCRIBE
        • HELP Command
        • KILL
        • PURGE BINARY LOGS
        • RESET
        • SHUTDOWN
        • USE [DATABASE]
        • ANALYZE and EXPLAIN Statements
        • BACKUP Statements
        • FLUSH Statements
        • Plugin Statements
        • Replication Statements
        • SET Statements
        • SHOW Statements
          • About SHOW
          • Extended SHOW
          • SHOW ANALYZE
          • SHOW AUTHORS
          • SHOW BINARY LOGS
          • SHOW BINLOG EVENTS
          • SHOW MASTER STATUS
          • SHOW CHARACTER SET
          • SHOW CLIENT_STATISTICS
          • SHOW COLLATION
          • SHOW COLUMNS
          • SHOW CONTRIBUTORS
          • SHOW CREATE DATABASE
          • SHOW CREATE EVENT
          • SHOW CREATE FUNCTION
          • SHOW CREATE PACKAGE BODY
          • SHOW CREATE PACKAGE
          • SHOW CREATE PROCEDURE
          • SHOW CREATE SEQUENCE
          • SHOW CREATE SERVER
          • SHOW CREATE TABLE
          • SHOW CREATE TRIGGER
          • SHOW CREATE USER
          • SHOW CREATE VIEW
          • SHOW DATABASES
          • SHOW ENGINE INNODB STATUS
          • SHOW ENGINE
          • SHOW ENGINES
          • SHOW ERRORS
          • SHOW EVENTS
          • SHOW EXPLAIN
          • SHOW FUNCTION CODE
          • SHOW FUNCTION STATUS
          • SHOW GRANTS
          • SHOW INDEX_STATISTICS
          • SHOW INDEX
          • SHOW INNODB STATUS (removed)
          • SHOW LOCALES
          • SHOW OPEN TABLES
          • SHOW PACKAGE BODY STATUS
          • SHOW PACKAGE STATUS
          • SHOW PLUGINS SONAME
          • SHOW PLUGINS
          • SHOW PRIVILEGES
          • SHOW PROCEDURE CODE
          • SHOW PROCEDURE STATUS
          • SHOW PROCESSLIST
          • SHOW PROFILE
          • SHOW PROFILES
          • SHOW QUERY_RESPONSE_TIME
          • SHOW RELAYLOG EVENTS
          • SHOW REPLICA HOSTS
          • SHOW REPLICA STATUS
          • SHOW STATUS
          • SHOW TABLE_STATISTICS
          • SHOW TABLE STATUS
          • SHOW TABLES
          • SHOW TRIGGERS
          • SHOW USER_STATISTICS
          • SHOW USER_VARIABLES
          • SHOW VARIABLES
          • SHOW WARNINGS
          • SHOW WSREP_MEMBERSHIP
          • SHOW WSREP_STATUS
      • Data Definition (DDL)
      • Data Manipulation (DML)
      • Geometry Statements
      • Prepared Statements
      • Programmatic & Compound Statements
      • Stored Routine Statements
      • Table Statements
      • Transactions
    • SQL Functions
    • Data Types
    • Plugins
    • System Tables
    • Error Codes
    • Client/Server Protocol
Powered by GitBook
On this page

Was this helpful?

  1. Reference
  2. SQL Statements
  3. Administrative Statements

SHOW Statements

Learn about SHOW statements in MariaDB Server. These SQL commands provide insights into server status, database objects, configurations, and various internal states for monitoring and troubleshooting.

About SHOWExtended SHOWSHOW ANALYZESHOW AUTHORSSHOW BINARY LOGSSHOW BINLOG EVENTSSHOW MASTER STATUSSHOW CHARACTER SETSHOW CLIENT_STATISTICSSHOW COLLATIONSHOW COLUMNSSHOW CONTRIBUTORSSHOW CREATE DATABASESHOW CREATE EVENTSHOW CREATE FUNCTIONSHOW CREATE PACKAGE BODYSHOW CREATE PACKAGESHOW CREATE PROCEDURESHOW CREATE SEQUENCESHOW CREATE SERVERSHOW CREATE TABLESHOW CREATE TRIGGERSHOW CREATE USERSHOW CREATE VIEWSHOW DATABASESSHOW ENGINE INNODB STATUSSHOW ENGINESHOW ENGINESSHOW ERRORSSHOW EVENTSSHOW EXPLAINSHOW FUNCTION CODESHOW FUNCTION STATUSSHOW GRANTSSHOW INDEX_STATISTICSSHOW INDEXSHOW INNODB STATUS (removed)SHOW LOCALESSHOW OPEN TABLESSHOW PACKAGE BODY STATUSSHOW PACKAGE STATUSSHOW PLUGINS SONAMESHOW PLUGINSSHOW PRIVILEGESSHOW PROCEDURE CODESHOW PROCEDURE STATUSSHOW PROCESSLISTSHOW PROFILESHOW PROFILESSHOW QUERY_RESPONSE_TIMESHOW RELAYLOG EVENTSSHOW REPLICA HOSTSSHOW REPLICA STATUSSHOW STATUSSHOW TABLE_STATISTICSSHOW TABLE STATUSSHOW TABLESSHOW TRIGGERSSHOW USER_STATISTICSSHOW USER_VARIABLESSHOW VARIABLESSHOW WARNINGSSHOW WSREP_MEMBERSHIPSHOW WSREP_STATUS

Last updated 4 months ago

Was this helpful?

LogoLogo

Products

  • Enterprise Platform
  • Community Server
  • Download MariaDB
  • Pricing

Support

  • Customer Login
  • Technical Support
  • Remote DBA
  • Professional Services

Resources

  • MariaDB Blog
  • Webinars
  • Customer Stories
  • MariaDB Events
  • Documentation
  • Developer Hub

Company

  • About MariaDB
  • Newsroom
  • Leadership
  • MariaDB Careers
  • Legal
  • Privacy Policy

© 2025 MariaDB. All rights reserved.