# Administrative Statements

- [BINLOG](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/binlog.md): Executes binary log events directly using base64-encoded data. Primarily used by the mariadb-binlog utility to re-apply events to the server.
- [CACHE INDEX](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/cache-index.md): Assigns specific table indices to a named key cache. Optimizes server performance by preloading or dedicating memory to frequently accessed keys.
- [DESCRIBE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/describe.md): Provides information about a table's columns. Acts as a shortcut for SHOW COLUMNS, displaying field names, types, and other attributes.
- [HELP Command](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/help-command.md): Displays help information from the server's help tables. Useful for looking up SQL syntax and command descriptions directly from the client.
- [KILL](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/kill.md): Terminates a specific connection or query. Allows administrators to stop runaway threads or disconnect users to free up server resources.
- [PURGE BINARY LOGS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/purge-binary-logs.md): Official PURGE BINARY LOGS syntax: delete binlogs using TO 'log\_name' or BEFORE datetime\_expr, replica read constraints, and SHOW BINARY LOGS commands.
- [RESET](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/reset.md): Clears internal server buffers, caches, and status variables. Resets state information like the query cache or replication status without a restart.
- [SHUTDOWN](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/shutdown.md): Stops the MariaDB server process. Allows a client with the SHUTDOWN privilege to cleanly power down the database instance.
- [USE \[DATABASE\]](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/use-database.md): Selects the default database for the current session. Subsequent queries execute against this database unless explicitly qualified by name.
- [ANALYZE and EXPLAIN Statements](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements.md): Learn commands for query analysis. This section covers ANALYZE TABLE and EXPLAIN, used to view execution plans and optimize query performance.
- [ANALYZE FORMAT=JSON](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-format-json.md): Gain deep insight into query execution with JSON-formatted analysis. This command combines optimizer estimates with actual runtime statistics for precise performance tuning.
- [ANALYZE FORMAT=JSON Examples](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-formatjson-examples.md): Review practical examples of ANALYZE FORMAT=JSON output. Learn to identify performance bottlenecks by comparing estimated costs against actual execution metrics.
- [ANALYZE: Interpreting rows and filtered members](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-interpreting-rows-and-filtered-members.md): Understand the r\_rows and r\_filtered fields in analysis output. Learn how these actual runtime counters compare to the optimizer's rows and filtered estimates.
- [ANALYZE Statement](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-statement.md): Learn to use the ANALYZE statement to execute a query and produce a performance report. This command reveals how close the optimizer's plan was to the actual execution.
- [EXPLAIN ANALYZE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain-analyze.md): Understand the historical context of EXPLAIN ANALYZE in MariaDB. Learn how this syntax maps to the modern ANALYZE statement for profiling query execution.
- [EXPLAIN FORMAT=JSON](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain-format-json.md): Get comprehensive query plans in JSON format. This output provides detailed optimizer data, including costs and attached conditions, not found in the tabular view.
- [EXPLAIN](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain.md): Complete EXPLAIN statement reference: SELECT/UPDATE/DELETE syntax, EXTENDED and PARTITIONS options, FORMAT=JSON output, EXPLAIN FOR CONNECTION usage.
- [Using Buffer UPDATE Algorithm](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/using-buffer-update-algorithm.md): Understand the 'Using buffer' strategy for UPDATE operations. Learn how MariaDB prevents infinite update loops when modifying indexed columns during a range scan.
- [BACKUP Statements](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/backup-commands.md): Learn about backup statements for MariaDB Server. This section details SQL statements and utilities for creating consistent database backups, essential for disaster recovery and data protection.
- [BACKUP LOCK](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/backup-commands/backup-lock.md): Protect table files during backups. This command blocks DDL operations like ALTER TABLE while allowing read/write activity, ensuring file consistency for backup tools.
- [BACKUP STAGE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/backup-commands/backup-stage.md): Control backup phases for external tools. Learn how to cycle through stages like START, BLOCK\_DDL, and BLOCK\_COMMIT to perform consistent backups with minimal locking.
- [Storage Snapshots and BACKUP STAGE Statements](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/backup-commands/storage-snapshots-and-backup-stage-commands.md): Combine database commands with storage-level snapshots. Learn the correct sequence of BACKUP STAGE commands to freeze writes safely while taking a disk snapshot.
- [FLUSH Statements](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands.md): Explore commands to clear internal caches. Learn to use FLUSH to reload privileges, clear the query cache, or close open tables.
- [FLUSH](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md): Complete FLUSH statement reference: NO\_WRITE\_TO\_BINLOG/LOCAL syntax, FLUSH TABLES WITH READ LOCK/FOR EXPORT, FLUSH STATUS, and SSL/TLS certificate reload.
- [FLUSH QUERY CACHE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush-query-cache.md): Defragment the query cache to optimize memory usage. This command reorganizes the cache to eliminate fragmentation without removing existing cached queries.
- [FLUSH TABLES FOR EXPORT](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush-tables-for-export.md): Prepare individual tables for binary backup. This command flushes changes to disk and locks tables, allowing safe copying of .ibd files while the server runs.
- [Plugin Statements](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements.md): Manage server plugins. This section covers INSTALL PLUGIN, UNINSTALL PLUGIN, and SHOW PLUGINS for extending server functionality.
- [INSTALL PLUGIN](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/install-plugin.md): Install a specific plugin from a shared library. This statement adds the plugin to the mysql.plugin table and loads its code into the server memory.
- [INSTALL SONAME](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/install-soname.md): Load all plugins contained within a shared library file. This statement automatically discovers and installs every valid plugin found in the specified library.
- [UNINSTALL PLUGIN](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/uninstall-plugin.md): Remove a specific plugin from the server. This statement unloads the plugin code and deletes its entry from the mysql.plugin table to prevent reloading.
- [UNINSTALL SONAME](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/uninstall-soname.md): Uninstall all plugins loaded from a specific library. This statement removes every plugin associated with the library file and unloads the library itself.
- [Replication Statements](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements.md): Control replication topologies. Learn statements like CHANGE MASTER TO and START SLAVE to configure primaries and replicas.
- [CHANGE MASTER TO](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/change-master-to.md): Complete CHANGE MASTER TO reference: MASTER\_HOST/PORT/USER/PASSWORD syntax, MASTER\_LOG\_FILE/POS options, MASTER\_USE\_GTID configuration, and MASTER\_SSL settings.
- [RESET MASTER](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/reset-master.md)
- [RESET REPLICA](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/reset-replica.md)
- [SET GLOBAL SQL\_SLAVE\_SKIP\_COUNTER](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/set-global-sql_slave_skip_counter.md)
- [START REPLICA](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/start-replica.md)
- [STOP REPLICA](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/stop-replica.md)
- [Legacy Replication Statements](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements.md): Category for old replication statements
- [RESET SLAVE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-reset-slave.md)
- [SHOW SLAVE HOSTS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-show-slave-hosts.md)
- [SHOW SLAVE STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-show-slave-status.md)
- [START SLAVE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-start-slave.md)
- [STOP SLAVE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-stop-slave.md)
- [SET Statements](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands.md): Assign values to system variables. Learn to use the SET statement to configure GLOBAL and SESSION variables for tuning server behavior.
- [SET](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set.md): Assign values to different types of variables. Learn the syntax for setting user-defined variables, system variables, and stored program variables.
- [SET CHARACTER SET](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-character-set.md): Map strings to a specific character set. This command updates the character set for the client, results, and connection to ensure correct data encoding.
- [SET NAMES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-names.md): Configure the character set and collation for the current connection. This ensures the server correctly interprets data sent by the client application.
- [SET PATH](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-path.md)
- [SET SQL\_LOG\_BIN](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-sql_log_bin.md): Enable or disable binary logging for the current session. This statement allows administrators to perform operations without replicating them to replicas.
- [SET STATEMENT](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-statement.md): Set a system variable for the duration of a single query. This statement allows temporary configuration changes that apply only to the immediate statement.
- [SET TRANSACTION](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-transaction.md): Define isolation levels and access modes for transactions. Learn to configure the behavior of the next transaction or the entire session for data consistency.
- [SET Variable](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-variable.md): Assign values to user-defined variables. This guide explains how to store data in session-specific variables for reuse in subsequent SQL statements.
- [SHOW Statements](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show.md): View server metadata and status. This section lists SHOW statements for inspecting databases, tables, variables, and performance metrics.
- [About SHOW](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/about-show.md): Overview of the SHOW statement syntax. Learn how to use patterns and WHERE clauses to filter output from various SHOW statements.
- [Extended SHOW](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/extended-show.md): Understand the extensions to the SHOW statement. Learn how to use WHERE and LIKE clauses to perform complex filtering on metadata results.
- [SHOW ANALYZE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-analyze.md): Retrieve runtime statistics for a currently executing query. This statement provides insights into query plan execution without waiting for completion.
- [SHOW AUTHORS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-authors.md): Display a list of major contributors to the MariaDB and MySQL projects. View names, locations, and specific contributions of developers.
- [SHOW BINARY LOGS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binary-logs.md): List the binary log files on the server. View the file names and sizes to monitor replication logs and manage disk usage.
- [SHOW BINLOG EVENTS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binlog-events.md): Inspect the contents of a binary log file. This statement displays the events within a specific binlog, useful for debugging replication issues.
- [SHOW MASTER STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binlog-status.md): View the current status of the primary server's binary log. This statement returns the current log file name and position for replication synchronization.
- [SHOW CHARACTER SET](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-character-set.md): List available character sets. View the default collation, maximum length, and description for each supported character set.
- [SHOW CLIENT\_STATISTICS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-client-statistics.md): View statistics on client connections. This statement displays metrics like bytes sent/received and busy time for connected clients.
- [SHOW COLLATION](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-collation.md): List available collations. View the character set associated with each collation and identifying properties like ID and default status.
- [SHOW COLUMNS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-columns.md): Complete guide to displaying table columns in MariaDB. Complete SHOW COLUMNS syntax with field types, keys, and filtering options for production use.
- [SHOW CONTRIBUTORS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-contributors.md): List financial contributors to the MariaDB Foundation. View the names and contributions of companies and individuals supporting the project.
- [SHOW CREATE DATABASE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-database.md): View the CREATE DATABASE statement. This statement returns the SQL syntax required to recreate a specific database with its current options.
- [SHOW CREATE EVENT](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-event.md): Get the SQL statement to recreate a scheduled event. This statement displays the complete syntax used to define a specific event.
- [SHOW CREATE FUNCTION](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-function.md): Retrieve the CREATE FUNCTION statement. This statement shows the exact SQL used to define a stored function, including its body and characteristics.
- [SHOW CREATE PACKAGE BODY](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-package-body.md): Display the CREATE statement for a package body. This Oracle-compatible statement shows the implementation code of a stored package.
- [SHOW CREATE PACKAGE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-package.md): View the CREATE PACKAGE statement. This statement returns the interface definition of a stored package in MariaDB.
- [SHOW CREATE PROCEDURE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-procedure.md): Get the CREATE PROCEDURE statement. This statement returns the SQL syntax used to define a specific stored procedure.
- [SHOW CREATE SEQUENCE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-sequence.md): View the SQL used to create a sequence. This statement displays the CREATE SEQUENCE statement with current parameter values.
- [SHOW CREATE SERVER](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-server.md): Display the CREATE SERVER statement. This statement shows the configuration details for a defined federated server connection.
- [SHOW CREATE TABLE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-table.md): Get the SQL statement to recreate a table. This statement shows the complete CREATE TABLE syntax, including column definitions and indexes.
- [SHOW CREATE TRIGGER](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-trigger.md): Retrieve the CREATE TRIGGER statement. This statement displays the SQL syntax defining a specific trigger and its timing events.
- [SHOW CREATE USER](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-user.md): View the CREATE USER statement. This statement returns the SQL required to recreate a user account with its authentication details.
- [SHOW CREATE VIEW](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-view.md): Display the CREATE VIEW statement. This statement shows the SQL query that defines a specific view structure.
- [SHOW DATABASES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-databases.md): Complete reference for listing databases in MariaDB. Complete SHOW DATABASES syntax with pattern matching and privilege considerations for production use.
- [SHOW ENGINE INNODB STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md): View extensive status information for the InnoDB engine. This statement displays details on deadlocks, buffer pool usage, and I/O activity.
- [SHOW ENGINE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine.md): Display status information for a storage engine. This statement retrieves operational logs or status details for a specific engine.
- [SHOW ENGINES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engines.md): List available storage engines. View the support status (default, active, or disabled) and description for each engine.
- [SHOW ERRORS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-errors.md): Display errors from the last executed statement. View error codes, messages, and types for recent failures.
- [SHOW EVENTS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-events.md): List scheduled events. View metadata such as the event name, schedule, status, and timing for events in a database.
- [SHOW EXPLAIN](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-explain.md): Get the execution plan for a running query. This statement displays EXPLAIN output for a statement currently executing in another thread.
- [SHOW FUNCTION CODE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-function-code.md): Display the internal instruction representation of a stored function. This debug statement shows the low-level opcodes of the routine.
- [SHOW FUNCTION STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-function-status.md): List stored functions and their characteristics. View metadata like the database, name, type, and creator of stored functions.
- [SHOW GRANTS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-grants.md): Complete SHOW GRANTS reference for MariaDB. Complete syntax guide with filtering, pattern matching, and access control options with comprehensive examples.
- [SHOW INDEX\_STATISTICS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index-statistics.md): View usage statistics for table indexes. This statement displays how often specific indexes are used, helping optimize query performance.
- [SHOW INDEX](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index.md): Complete SHOW INDEX reference: SHOW {INDEX|INDEXES|KEYS} FROM tbl\_name syntax, output fields (Key\_name, Seq\_in\_index, Cardinality), and WHERE/LIKE filters.
- [SHOW INNODB STATUS (removed)](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-innodb-status-removed.md): Documentation for the deprecated SHOW INNODB STATUS statement. This statement was removed in favor of SHOW ENGINE INNODB STATUS.
- [SHOW LOCALES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-locales.md): List available error message locales. View the language IDs, names, and descriptions for supported localization settings.
- [SHOW OPEN TABLES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-open-tables.md): List currently open tables. View the database, table name, and lock status for tables in the table cache.
- [SHOW PACKAGE BODY STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-body-status.md): List stored package bodies. View metadata about the implementation part of Oracle-compatible packages.
- [SHOW PACKAGE STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-status.md): List stored packages. View metadata about the interface part of Oracle-compatible packages in the database.
- [SHOW PLUGINS SONAME](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins-soname.md): List plugins and their library files. View information about installed plugins and their associated shared object names.
- [SHOW PLUGINS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins.md): List installed server plugins. View the name, status, type, and library file for each active plugin.
- [SHOW PRIVILEGES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-privileges.md): List available system privileges. View the context and description for each privilege supported by the server.
- [SHOW PROCEDURE CODE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-procedure-code.md): Display the internal instruction representation of a stored procedure. This debug statement shows the low-level opcodes of the routine.
- [SHOW PROCEDURE STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-procedure-status.md): List stored procedures and their characteristics. View metadata like the database, name, type, and creator of stored procedures.
- [SHOW PROCESSLIST](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-processlist.md): Complete SHOW PROCESSLIST reference: FULL keyword for complete queries, PROCESS privilege, columns (Id, User, Host, db, Command, Time, State, Info).
- [SHOW PROFILE](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-profile.md): Display profiling information for a query. View resource usage statistics like CPU and block IO for the most recent statement.
- [SHOW PROFILES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-profiles.md): List queries for which profiling data is available. View the query ID and duration for recent statements when profiling is enabled.
- [SHOW QUERY\_RESPONSE\_TIME](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-query_response_time.md): View the distribution of query execution times. This statement groups queries into time-based buckets to analyze performance.
- [SHOW RELAYLOG EVENTS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-relaylog-events.md): Inspect events in the relay log. This statement displays replication events from the relay log on a replica server.
- [SHOW REPLICA HOSTS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-hosts.md): List registered replicas. This statement displays information about replica servers connected to the current primary.
- [SHOW REPLICA STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-status.md): Complete SHOW REPLICA STATUS: FOR CHANNEL/connection\_name syntax, SHOW ALL REPLICAS option, thread states (Slave\_IO/SQL\_Running), and lag/log/GTID fields.
- [SHOW STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-status.md): View server status variables. This statement displays counters and metrics for server activity, performance, and health.
- [SHOW TABLE\_STATISTICS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-statistics.md): View usage statistics for tables. This statement displays metrics like rows read, changed, and updated for each table.
- [SHOW TABLE STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-status.md): Get metadata for tables. View details like engine type, row count, data length, and create time for tables in a database.
- [SHOW TABLES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-tables.md): Complete guide to listing tables in MariaDB. Complete SHOW TABLES syntax reference with LIKE patterns, WHERE conditions, and filtering options.
- [SHOW TRIGGERS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-triggers.md): List triggers defined on tables. View metadata such as the trigger event, timing, and the table it is associated with.
- [SHOW USER\_STATISTICS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-user-statistics.md): View statistics on user activity. This statement displays metrics like CPU time and rows read for each user account.
- [SHOW USER\_VARIABLES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-user_variables.md): List defined user variables. This statement displays the names and values of variables set in the current session.
- [SHOW VARIABLES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-variables.md): Complete SHOW VARIABLES reference: GLOBAL/SESSION scope syntax, LIKE 'pattern' matching, WHERE expression filters, and INFORMATION\_SCHEMA table queries.
- [SHOW WARNINGS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-warnings.md): Display warnings from the last executed statement. View warning codes, messages, and levels for recent operations.
- [SHOW WSREP\_MEMBERSHIP](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-wsrep_membership.md): View Galera Cluster membership. This statement displays the UUID, name, and address of nodes in the cluster.
- [SHOW WSREP\_STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-wsrep_status.md): View Galera Cluster status variables. This statement displays internal status metrics for the wsrep provider.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.