# Administrative Statements

- [BINLOG](/docs/server/reference/sql-statements/administrative-sql-statements/binlog.md)
- [CACHE INDEX](/docs/server/reference/sql-statements/administrative-sql-statements/cache-index.md)
- [DESCRIBE](/docs/server/reference/sql-statements/administrative-sql-statements/describe.md)
- [HELP Command](/docs/server/reference/sql-statements/administrative-sql-statements/help-command.md)
- [KILL](/docs/server/reference/sql-statements/administrative-sql-statements/kill.md)
- [PURGE BINARY LOGS](/docs/server/reference/sql-statements/administrative-sql-statements/purge-binary-logs.md)
- [RESET](/docs/server/reference/sql-statements/administrative-sql-statements/reset.md)
- [SHUTDOWN](/docs/server/reference/sql-statements/administrative-sql-statements/shutdown.md)
- [USE \[DATABASE\]](/docs/server/reference/sql-statements/administrative-sql-statements/use-database.md)
- [ANALYZE and EXPLAIN Statements](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements.md): Learn about ANALYZE and EXPLAIN statements in MariaDB Server. This section details how to optimize queries by analyzing table distribution statistics and understanding query execution plans.
- [ANALYZE FORMAT=JSON](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-format-json.md)
- [ANALYZE FORMAT=JSON Examples](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-formatjson-examples.md)
- [ANALYZE: Interpreting rows and filtered members](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-interpreting-rows-and-filtered-members.md)
- [ANALYZE Statement](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-statement.md)
- [EXPLAIN ANALYZE](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain-analyze.md)
- [EXPLAIN FORMAT=JSON](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain-format-json.md)
- [EXPLAIN](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain.md)
- [Using Buffer UPDATE Algorithm](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/using-buffer-update-algorithm.md)
- [BACKUP Statements](/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](/docs/server/reference/sql-statements/administrative-sql-statements/backup-commands/backup-lock.md)
- [BACKUP STAGE](/docs/server/reference/sql-statements/administrative-sql-statements/backup-commands/backup-stage.md)
- [Storage Snapshots and BACKUP STAGE Statements](/docs/server/reference/sql-statements/administrative-sql-statements/backup-commands/storage-snapshots-and-backup-stage-commands.md)
- [FLUSH Statements](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands.md): Learn about FLUSH statements in MariaDB Server. This section details how to clear various internal caches and logs, essential for administrative tasks and ensuring consistent database state.
- [FLUSH QUERY CACHE](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush-query-cache.md)
- [FLUSH TABLES FOR EXPORT](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush-tables-for-export.md)
- [FLUSH](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md)
- [Plugin Statements](/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements.md): Learn about plugin SQL statements in MariaDB Server. This section details how to install, uninstall, enable, and disable server plugins, extending database functionality as needed.
- [INSTALL PLUGIN](/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/install-plugin.md)
- [INSTALL SONAME](/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/install-soname.md)
- [UNINSTALL PLUGIN](/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/uninstall-plugin.md)
- [UNINSTALL SONAME](/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/uninstall-soname.md)
- [Replication Statements](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements.md): Learn about replication SQL statements in MariaDB Server. This section covers commands for configuring, controlling, and monitoring replication, essential for high availability and data distribution.
- [CHANGE MASTER TO](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/change-master-to.md)
- [RESET MASTER](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/reset-master.md)
- [RESET REPLICA](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/reset-replica.md)
- [SET GLOBAL SQL\_SLAVE\_SKIP\_COUNTER](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/set-global-sql_slave_skip_counter.md)
- [START REPLICA](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/start-replica.md)
- [STOP REPLICA](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/stop-replica.md)
- [Legacy Replication Statements](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements.md): Category for old replication statements
- [RESET SLAVE](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-reset-slave.md)
- [SHOW SLAVE HOSTS](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-show-slave-hosts.md)
- [SHOW SLAVE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-show-slave-status.md)
- [START SLAVE](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-start-slave.md)
- [STOP SLAVE](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/legacy-replication-statements/legacy-commands-stop-slave.md)
- [SET Statements](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands.md): Learn about SET statements in MariaDB Server. This section details how to configure system variables at global, session, and local levels, enabling fine-tuning of database behavior and performance.
- [SET](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set.md)
- [SET SQL\_LOG\_BIN](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-sql_log_bin.md)
- [SET STATEMENT](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-statement.md): SET STATEMENT can be used to set the value of a system variable for the duration of the statement. It is also possible to set multiple variables.
- [SHOW Statements](/docs/server/reference/sql-statements/administrative-sql-statements/show.md): 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 SHOW](/docs/server/reference/sql-statements/administrative-sql-statements/show/about-show.md)
- [Extended SHOW](/docs/server/reference/sql-statements/administrative-sql-statements/show/extended-show.md)
- [SHOW ANALYZE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-analyze.md)
- [SHOW AUTHORS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-authors.md)
- [SHOW BINARY LOGS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binary-logs.md)
- [SHOW BINLOG EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binlog-events.md)
- [SHOW MASTER STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binlog-status.md)
- [SHOW CHARACTER SET](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-character-set.md)
- [SHOW CLIENT\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-client-statistics.md)
- [SHOW COLLATION](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-collation.md)
- [SHOW COLUMNS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-columns.md)
- [SHOW CONTRIBUTORS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-contributors.md)
- [SHOW CREATE DATABASE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-database.md)
- [SHOW CREATE EVENT](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-event.md)
- [SHOW CREATE FUNCTION](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-function.md)
- [SHOW CREATE PACKAGE BODY](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-package-body.md)
- [SHOW CREATE PACKAGE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-package.md)
- [SHOW CREATE PROCEDURE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-procedure.md)
- [SHOW CREATE SEQUENCE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-sequence.md)
- [SHOW CREATE SERVER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-server.md)
- [SHOW CREATE TABLE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-table.md)
- [SHOW CREATE TRIGGER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-trigger.md)
- [SHOW CREATE USER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-user.md)
- [SHOW CREATE VIEW](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-view.md)
- [SHOW DATABASES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-databases.md)
- [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md)
- [SHOW ENGINE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine.md)
- [SHOW ENGINES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engines.md)
- [SHOW ERRORS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-errors.md)
- [SHOW EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-events.md)
- [SHOW EXPLAIN](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-explain.md)
- [SHOW FUNCTION CODE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-function-code.md)
- [SHOW FUNCTION STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-function-status.md)
- [SHOW GRANTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-grants.md)
- [SHOW INDEX\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index-statistics.md)
- [SHOW INDEX](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index.md)
- [SHOW INNODB STATUS (removed)](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-innodb-status-removed.md)
- [SHOW LOCALES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-locales.md)
- [SHOW OPEN TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-open-tables.md)
- [SHOW PACKAGE BODY STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-body-status.md)
- [SHOW PACKAGE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-status.md)
- [SHOW PLUGINS SONAME](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins-soname.md)
- [SHOW PLUGINS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins.md)
- [SHOW PRIVILEGES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-privileges.md)
- [SHOW PROCEDURE CODE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-procedure-code.md)
- [SHOW PROCEDURE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-procedure-status.md)
- [SHOW PROCESSLIST](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-processlist.md)
- [SHOW PROFILE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-profile.md)
- [SHOW PROFILES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-profiles.md)
- [SHOW QUERY\_RESPONSE\_TIME](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-query_response_time.md)
- [SHOW RELAYLOG EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-relaylog-events.md)
- [SHOW REPLICA HOSTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-hosts.md)
- [SHOW REPLICA STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-status.md)
- [SHOW STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-status.md)
- [SHOW TABLE\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-statistics.md)
- [SHOW TABLE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-status.md)
- [SHOW TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-tables.md)
- [SHOW TRIGGERS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-triggers.md)
- [SHOW USER\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-user-statistics.md)
- [SHOW USER\_VARIABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-user_variables.md)
- [SHOW VARIABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-variables.md)
- [SHOW WARNINGS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-warnings.md)
- [SHOW WSREP\_MEMBERSHIP](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-wsrep_membership.md)
- [SHOW WSREP\_STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-wsrep_status.md)
